POST api/Employee/GetEmployeeSalaryDetailsforexcel

Request Information

URI Parameters

None.

Body Parameters

ExportExcelModel
NameDescriptionTypeAdditional information
Empid

integer

None.

Prefixfromdate

date

None.

suffixtodate

date

None.

Month

string

None.

TotalDays

integer

None.

empno

integer

None.

year

integer

None.

SLNO

integer

None.

EMPLOYEECODE

string

None.

NAME_OF_EMPLOYEES

string

None.

SITE

string

None.

W

string

None.

O

string

None.

Department

string

None.

Designation

string

None.

E

string

None.

T_D

string

None.

BASIC

decimal number

None.

STIPEND

decimal number

None.

WORKING_DAYS

integer

None.

DAY_S_ABSENT

decimal number

None.

DEDUCTION_AGAINST_ABSENSE

decimal number

None.

E_L_

decimal number

None.

PAYMENT_AGAINST_E_L_

decimal number

None.

GROSS_AMOUNT

decimal number

None.

HRA

decimal number

None.

LODGING_ALLOWANCE

decimal number

None.

Attire_Allowance

decimal number

None.

TRAINING_ALLOWANCE_ACHIEVED

decimal number

None.

MOBILE

decimal number

None.

BOOKS_AND_PERIODICALS_ALLOWANCE

decimal number

None.

INTERNET_ALLOWANCE

decimal number

None.

CONINUOUS_ATTENDENCE_ALLOWANCE

decimal number

None.

Conveyence_Allowance

decimal number

None.

PRODUCTION_BONUS

decimal number

None.

PRODUCTION_BONUS_ACHIEVED

decimal number

None.

OVERTIME

decimal number

None.

OVERTIME_AMOUNT

decimal number

None.

MEDICAL_ALLOWANCES

decimal number

None.

LTA

decimal number

None.

EDUCATION_ALLOWANCES

decimal number

None.

TOTAL_ALLOWANCES

decimal number

None.

PF

decimal number

None.

PTAX

decimal number

None.

E_S_I

decimal number

None.

TOTAL_DEDUCTION

decimal number

None.

OPENING_BALANCE

decimal number

None.

DEDUCTION

decimal number

None.

CLOSING_BALANCE

decimal number

None.

NET_AMOUNT

decimal number

None.

PAID_DATE

string

None.

Request Formats

application/json, text/json

Sample:
{
  "Empid": 1,
  "Prefixfromdate": "2025-12-06T09:45:13.0150216+05:30",
  "suffixtodate": "2025-12-06T09:45:13.0150216+05:30",
  "Month": "sample string 2",
  "TotalDays": 3,
  "empno": 4,
  "year": 5,
  "SLNO": 6,
  "EMPLOYEECODE": "sample string 7",
  "NAME_OF_EMPLOYEES": "sample string 8",
  "SITE": "sample string 9",
  "W": "sample string 10",
  "O": "sample string 11",
  "Department": "sample string 12",
  "Designation": "sample string 13",
  "E": "sample string 14",
  "T_D": "sample string 15",
  "BASIC": 1.1,
  "STIPEND": 1.1,
  "WORKING_DAYS": 1,
  "DAY_S_ABSENT": 1.1,
  "DEDUCTION_AGAINST_ABSENSE": 1.1,
  "E_L_": 1.1,
  "PAYMENT_AGAINST_E_L_": 1.1,
  "GROSS_AMOUNT": 1.1,
  "HRA": 1.1,
  "LODGING_ALLOWANCE": 1.1,
  "Attire_Allowance": 1.1,
  "TRAINING_ALLOWANCE_ACHIEVED": 1.1,
  "MOBILE": 1.1,
  "BOOKS_AND_PERIODICALS_ALLOWANCE": 1.1,
  "INTERNET_ALLOWANCE": 1.1,
  "CONINUOUS_ATTENDENCE_ALLOWANCE": 1.1,
  "Conveyence_Allowance": 1.1,
  "PRODUCTION_BONUS": 1.1,
  "PRODUCTION_BONUS_ACHIEVED": 1.1,
  "OVERTIME": 1.1,
  "OVERTIME_AMOUNT": 1.1,
  "MEDICAL_ALLOWANCES": 1.1,
  "LTA": 1.1,
  "EDUCATION_ALLOWANCES": 1.1,
  "TOTAL_ALLOWANCES": 1.1,
  "PF": 1.1,
  "PTAX": 1.1,
  "E_S_I": 1.1,
  "TOTAL_DEDUCTION": 1.1,
  "OPENING_BALANCE": 1.0,
  "DEDUCTION": 1.1,
  "CLOSING_BALANCE": 1.0,
  "NET_AMOUNT": 1.1,
  "PAID_DATE": "sample string 16"
}

application/xml, text/xml

Sample:
<ExportExcelModel xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/MendinePayroll.Models">
  <Attire_Allowance>1.1</Attire_Allowance>
  <BASIC>1.1</BASIC>
  <BOOKS_AND_PERIODICALS_ALLOWANCE>1.1</BOOKS_AND_PERIODICALS_ALLOWANCE>
  <CLOSING_BALANCE>1</CLOSING_BALANCE>
  <CONINUOUS_ATTENDENCE_ALLOWANCE>1.1</CONINUOUS_ATTENDENCE_ALLOWANCE>
  <Conveyence_Allowance>1.1</Conveyence_Allowance>
  <DAY_S_ABSENT>1.1</DAY_S_ABSENT>
  <DEDUCTION>1.1</DEDUCTION>
  <DEDUCTION_AGAINST_ABSENSE>1.1</DEDUCTION_AGAINST_ABSENSE>
  <Department>sample string 12</Department>
  <Designation>sample string 13</Designation>
  <E>sample string 14</E>
  <EDUCATION_ALLOWANCES>1.1</EDUCATION_ALLOWANCES>
  <EMPLOYEECODE>sample string 7</EMPLOYEECODE>
  <E_L_>1.1</E_L_>
  <E_S_I>1.1</E_S_I>
  <Empid>1</Empid>
  <GROSS_AMOUNT>1.1</GROSS_AMOUNT>
  <HRA>1.1</HRA>
  <INTERNET_ALLOWANCE>1.1</INTERNET_ALLOWANCE>
  <LODGING_ALLOWANCE>1.1</LODGING_ALLOWANCE>
  <LTA>1.1</LTA>
  <MEDICAL_ALLOWANCES>1.1</MEDICAL_ALLOWANCES>
  <MOBILE>1.1</MOBILE>
  <Month>sample string 2</Month>
  <NAME_OF_EMPLOYEES>sample string 8</NAME_OF_EMPLOYEES>
  <NET_AMOUNT>1.1</NET_AMOUNT>
  <O>sample string 11</O>
  <OPENING_BALANCE>1</OPENING_BALANCE>
  <OVERTIME>1.1</OVERTIME>
  <OVERTIME_AMOUNT>1.1</OVERTIME_AMOUNT>
  <PAID_DATE>sample string 16</PAID_DATE>
  <PAYMENT_AGAINST_E_L_>1.1</PAYMENT_AGAINST_E_L_>
  <PF>1.1</PF>
  <PRODUCTION_BONUS>1.1</PRODUCTION_BONUS>
  <PRODUCTION_BONUS_ACHIEVED>1.1</PRODUCTION_BONUS_ACHIEVED>
  <PTAX>1.1</PTAX>
  <Prefixfromdate>2025-12-06T09:45:13.0150216+05:30</Prefixfromdate>
  <SITE>sample string 9</SITE>
  <SLNO>6</SLNO>
  <STIPEND>1.1</STIPEND>
  <TOTAL_ALLOWANCES>1.1</TOTAL_ALLOWANCES>
  <TOTAL_DEDUCTION>1.1</TOTAL_DEDUCTION>
  <TRAINING_ALLOWANCE_ACHIEVED>1.1</TRAINING_ALLOWANCE_ACHIEVED>
  <T_D>sample string 15</T_D>
  <TotalDays>3</TotalDays>
  <W>sample string 10</W>
  <WORKING_DAYS>1</WORKING_DAYS>
  <empno>4</empno>
  <suffixtodate>2025-12-06T09:45:13.0150216+05:30</suffixtodate>
  <year>5</year>
</ExportExcelModel>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

HttpResponseMessage
NameDescriptionTypeAdditional information
Version

Version

None.

Content

HttpContent

None.

StatusCode

HttpStatusCode

None.

ReasonPhrase

string

None.

Headers

Collection of Object

None.

RequestMessage

HttpRequestMessage

None.

IsSuccessStatusCode

boolean

None.