public async Task AddDivisionMaster(DivisionMaster prodData)
{
var maxId = await WithConnection(async c =>
{
return(await c.QueryAsync <int>("SELECT max(DivisionIndex) FROM DivisionMaster"));
});
//Setting Primary Key
if (maxId.SingleOrDefault() == 0)
{
prodData.DivisionIndex = 1;
}
else
{
prodData.DivisionIndex = maxId.SingleOrDefault() + 1;
}
//Filling Other Records like User Id, Creation & Update Date
prodData.CreateUserIndex = 1; //Later Logged in User
prodData.UpdateUserIndex = 1; //Later Logged in User
prodData.CreateDateTime = DateTime.Now;
prodData.UpdateDateTime = DateTime.Now;
await WithConnection(async c =>
{
return(await c.QueryAsync <int>(SQLConstants.InsertDivisionMaster, prodData));
});
}
public object DeleteDivision([FromBody] DivisionParam DivParam)
{
DivisionMaster SingleVale = new DivisionMaster();
var result = SingleVale.DeleteDivision(DivParam);
return(result);
}
public object AddDivision([FromBody] DivisionParam DivParam)
{
DivisionMaster Add = new DivisionMaster();
var Result = Add.SaveDivision(DivParam);
return(Result);
}
public object DisplayDivision([FromBody] DivisionParam DivParam)
{
DivisionMaster ObjDisplay = new DivisionMaster();
var result = ObjDisplay.DisplayDiv(DivParam);
return(result);
}
public async Task <IHttpActionResult> Create(DivisionMaster prodData)
{
if (prodData != null)
{
await DivisionMasterDA.AddDivisionMaster(prodData);
return(Ok());
}
return(BadRequest("Request cannot be NULL"));
}
public void InsertDivision(DivisionMaster Division)
{
Division.Deactivate = "N";
Division.EnteredBy = 10;
Division.EntryDate = DateTime.Now;
Division.ModifiedBy = null;
Division.ModifiedDate = null;
Division.DeactivateBy = null;
Division.DeactivateDate = null;
_DivisionRepository.Insert(Division);
}
/// <summary>
/// Description :SubDevision List By DevisionId
/// Function Name :SubDivisionListByDivisionId
/// OutPut parameter :DataSet
/// Create Date : 11 May 2016
/// Author Name : Vishal Verma
/// </summary>
/// <remarks>
///**************************** Modification History *************************************************************
/// Sr No: Date Modified by Tracker Description
///*****************************************************************************************************************
///*****************************************************************************************************************
///
///</remarks>
public IHttpActionResult SubDivisionListByDivisionId(DivisionMaster Division)
{
IList <DivisionMaster> _divisionList = _CommonListService.GetAllSubDivisionsbyDivisonId(Division).ToList();
var divisionData = _divisionList.Select(dl => new
{
SubDivisionId = dl.Id,
SubDivisionName = dl.divisionName
});
return(Json(SerializeObj.SerializeObject(new { divisionData = divisionData })));
}
//Added by Dheeraj/
public IHttpActionResult InsertDivision(DivisionMaster Division)
{
string status = "";
try
{
if (Division.parentdivisionid == null)
{
Division.divisionlevel = 1;
}
else
{
Division.divisionlevel = 2;
}
status = _DivisionService.DuplicityCheck(Division);
if (status == "Y")
{
if (Division.Id == 0)
{
_DivisionService.InsertDivision(Division);
}
else
{
DivisionMaster mobj_division = _DivisionService.GetDivisionById(Division);
mobj_division.divisionName = Division.divisionName;
mobj_division.divisionlevel = Division.divisionlevel;
mobj_division.parentdivisionid = Division.parentdivisionid;
mobj_division.ModifiedBy = Division.EnteredBy;
mobj_division.ModifiedDate = System.DateTime.Now;
_DivisionService.UpdateDivision(mobj_division);
}
status = _localizationService.GetResource("Master.API.Success.Message");
}
else
{
status = "Duplicate";
}
}
catch (ACSException ex)
{
status = ex.InnerException.Message;
}
catch (Exception ex)
{
status = ex.InnerException.Message;
}
return(Json(status));
}
public string DuplicityCheck(DivisionMaster Division)
{
var dupes = _DivisionRepository.Table.Where(x => x.divisionlevel == Division.divisionlevel &&
x.parentdivisionid == Division.parentdivisionid &&
x.divisionName == Division.divisionName &&
x.Deactivate == "N" &&
(Division.Id != 0 ? x.Id : 0) != (Division.Id != 0 ? Division.Id : 1)).FirstOrDefault();
if (dupes != null)
{
return("N");
}
else
{
return("Y");
}
}
//Update the Sub division
public IHttpActionResult DivisionDelete(DivisionMaster _division)
{
string status = string.Empty;
try
{
DivisionMaster _Division = _DivisionService.GetDivisionById(_division);
_Division.Deactivate = "Y";
_Division.ModifiedBy = _division.EnteredBy;
_Division.ModifiedDate = DateTime.Now;
_DivisionService.UpdateDivision(_Division);
status = "OK";
}
catch (ACSException ex)
{
status = ex.InnerException.Message;
}
catch (Exception ex)
{
status = ex.InnerException.Message;
}
return(Json(status));
}
public void DeleteDivision(DivisionMaster Division)
{
_DivisionRepository.Delete(Division);
}
public void UpdateDivision(DivisionMaster Division)
{
_DivisionRepository.Update(Division);
}
public DivisionMaster GetDivisionById(DivisionMaster Division)
{
return(_DivisionRepository.Table.Where(i => i.Id == Division.Id).FirstOrDefault());
}
/// <summary>
/// Gets all Divisions
/// </summary>
/// <param name="showDeactivated">A value indicating whether to show hidden records</param>
/// <returns>Sub Division collection</returns>
public virtual IList <DivisionMaster> GetAllSubDivisionsbyDivisonId(DivisionMaster Division)
{
return(_DivisionRepository.Table.Where(d => d.parentdivisionid == Division.Id).OrderBy(c => c.divisionName).ToList());
}
// call report with reportname only
void callreport(string Reportname)
{
Telerik.Reporting.TypeReportSource typeReportSource =
new Telerik.Reporting.TypeReportSource();
string reportname;
reportname = Reportname;
switch (reportname)
{
#region Master
case "Action Maintenance":
ActionIDMaintenance ActionMaintenance = new ActionIDMaintenance();
typeReportSource.TypeName = typeof(ActionIDMaintenance).AssemblyQualifiedName;
break;
case "Batch Setup":
BatchMaster BatchList = new BatchMaster();
typeReportSource.TypeName = typeof(BatchMaster).AssemblyQualifiedName;
break;
case "Company Asset Setup":
//CompanyAssetMaster companyAsset = new CompanyAssetMaster();
//typeReportSource.TypeName = typeof(CompanyAssetMaster).AssemblyQualifiedName;
break;
case "Complain Code Setup":
ComplainMaster complainCode = new ComplainMaster();
typeReportSource.TypeName = typeof(ComplainMaster).AssemblyQualifiedName;
break;
case "Country Setup":
CountrySetup countrySetup = new CountrySetup();
typeReportSource.TypeName = typeof(CountrySetup).AssemblyQualifiedName;
break;
case "Daytype Setup":
DayMaster dayTYpeSetup = new DayMaster();
typeReportSource.TypeName = typeof(DayMaster).AssemblyQualifiedName;
break;
case "Division Setup":
DivisionMaster divisionMaster = new DivisionMaster();
typeReportSource.TypeName = typeof(DivisionMaster).AssemblyQualifiedName;
break;
case "Facility Setup":
FacilitiesMaster facilitiesMaster = new FacilitiesMaster();
typeReportSource.TypeName = typeof(FacilitiesMaster).AssemblyQualifiedName;
break;
case "Nationality Setup":
NationalityMaster nationalityMaster = new NationalityMaster();
typeReportSource.TypeName = typeof(NationalityMaster).AssemblyQualifiedName;
break;
case "Religion Setup":
ReligionMaster religionMaster = new ReligionMaster();
typeReportSource.TypeName = typeof(ReligionMaster).AssemblyQualifiedName;
break;
case "Room Setup":
RoomMaster roomMaster = new RoomMaster();
typeReportSource.TypeName = typeof(RoomMaster).AssemblyQualifiedName;
break;
case "Suggestion Master":
SuggestionMaster suggestionMaster = new SuggestionMaster();
typeReportSource.TypeName = typeof(SuggestionMaster).AssemblyQualifiedName;
break;
case "Employer Setup":
EmployerMaster employerMaster = new EmployerMaster();
typeReportSource.TypeName = typeof(EmployerMaster).AssemblyQualifiedName;
break;
case "Loan Type":
SuggestionMaster suggestionMaster1 = new SuggestionMaster();
typeReportSource.TypeName = typeof(SuggestionMaster).AssemblyQualifiedName;
break;
#endregion
#region Setup
case "Attendence Machine":
AttendenceSetup AttendenceSetup = new AttendenceSetup();
typeReportSource.TypeName = typeof(AttendenceSetup).AssemblyQualifiedName;
break;
case "Benefit Setup":
BenefitMaster BenefitMaster = new BenefitMaster();
typeReportSource.TypeName = typeof(BenefitMaster).AssemblyQualifiedName;
break;
case "Branch Setup":
BranchMaster branchmaster = new BranchMaster();
typeReportSource.TypeName = typeof(BranchMaster).AssemblyQualifiedName;
break;
case "Calender Setup":
CalenderSetup CalenderList = new CalenderSetup();
typeReportSource.TypeName = typeof(CalenderSetup).AssemblyQualifiedName;
break;
case "Deduction Setup":
DeductionMaster DeductionList = new DeductionMaster();
typeReportSource.TypeName = typeof(DeductionMaster).AssemblyQualifiedName;
break;
case "Employee Class Setup":
ClassMaster classMaster = new ClassMaster();
typeReportSource.TypeName = typeof(ClassMaster).AssemblyQualifiedName;
break;
case "End of Service Master":
EOSMaster eOSList = new EOSMaster();
typeReportSource.TypeName = typeof(EOSMaster).AssemblyQualifiedName;
break;
case "Grade Setup":
EOSMaster eOSList1 = new EOSMaster();
typeReportSource.TypeName = typeof(EOSMaster).AssemblyQualifiedName;
break;
case "Gratuity Setup":
GratuitySetup GratuityList = new GratuitySetup();
typeReportSource.TypeName = typeof(GratuitySetup).AssemblyQualifiedName;
break;
case "Leave Assignment":
LeaveMasterMaster LeaveCodeList = new LeaveMasterMaster();
typeReportSource.TypeName = typeof(LeaveMasterMaster).AssemblyQualifiedName;
break;
case "Leave Type":
LeaveMasterMaster LeaveCodeList1 = new LeaveMasterMaster();
typeReportSource.TypeName = typeof(LeaveMasterMaster).AssemblyQualifiedName;
break;
case "Overtime Setup":
OvertimeSetup OvertimeList = new OvertimeSetup();
typeReportSource.TypeName = typeof(OvertimeSetup).AssemblyQualifiedName;
break;
case "Pay Code Setup":
PaycodeMaster PaycodeList = new PaycodeMaster();
typeReportSource.TypeName = typeof(PaycodeMaster).AssemblyQualifiedName;
break;
case "Position Setup":
PositionSetup PositionList = new PositionSetup();
typeReportSource.TypeName = typeof(PositionSetup).AssemblyQualifiedName;
break;
case "Project Setup":
ProjectMaster ProjectList = new ProjectMaster();
typeReportSource.TypeName = typeof(ProjectMaster).AssemblyQualifiedName;
break;
case "Supervisor Setup":
SuperviserSetup SuperviserList = new SuperviserSetup();
typeReportSource.TypeName = typeof(SuperviserSetup).AssemblyQualifiedName;
break;
case "Transaction Sequence":
TransactionSequence TransactionSequenceList = new TransactionSequence();
typeReportSource.TypeName = typeof(TransactionSequence).AssemblyQualifiedName;
break;
#endregion
#region Employee
case "Employee Pay Code":
EmployeeMonthlySalary employeeMonthlySalary = new EmployeeMonthlySalary();
typeReportSource.TypeName = typeof(EmployeeMonthlySalary).AssemblyQualifiedName;
break;
case "Employee Address":
EmployeeAddresslist employeeAddresslist = new EmployeeAddresslist();
typeReportSource.TypeName = typeof(EmployeeAddresslist).AssemblyQualifiedName;
break;
case "Employee Card":
EmployeeCard employeeCard = new EmployeeCard();
typeReportSource.TypeName = typeof(EmployeeCard).AssemblyQualifiedName;
break;
case "Employee Contract":
EmployeeContractlist employeeContractlist = new EmployeeContractlist();
typeReportSource.TypeName = typeof(EmployeeContractlist).AssemblyQualifiedName;
break;
case "Employee IBAN":
EmployeeIBANChecking employeeIBANChecking = new EmployeeIBANChecking();
typeReportSource.TypeName = typeof(EmployeeIBANChecking).AssemblyQualifiedName;
break;
case "Employee Master":
EmployeeMasterList employeeMasterList = new EmployeeMasterList();
typeReportSource.TypeName = typeof(EmployeeMasterList).AssemblyQualifiedName;
break;
case "Employee Personal Info":
EmployeePersonalinfo employeePersonalinfo = new EmployeePersonalinfo();
typeReportSource.TypeName = typeof(EmployeePersonalinfo).AssemblyQualifiedName;
break;
//case "Employee Master":
// Employeemaster employeePersonalinfo = new EmployeePersonalinfo();
// typeReportSource.TypeName = typeof(EmployeePersonalinfo).AssemblyQualifiedName;
// break;
#endregion
case "BenefitDetailList":
BenefitDetailDRL BenefitDetailList = new BenefitDetailDRL();
typeReportSource.TypeName = typeof(BenefitDetailDRL).AssemblyQualifiedName;
break;
case "BranchList":
BranchMaster BranchList = new BranchMaster();
typeReportSource.TypeName = typeof(BranchMaster).AssemblyQualifiedName;
break;
case "ClassList":
ClassMaster ClassList = new ClassMaster();
typeReportSource.TypeName = typeof(ClassMaster).AssemblyQualifiedName;
break;
case "DeductionWithDetailList":
DeductionDetailDRL DeductionWithDetailList = new DeductionDetailDRL();
typeReportSource.TypeName = typeof(DeductionDetailDRL).AssemblyQualifiedName;
break;
/* case "DeductionDetailList":
*
* DeductionWithDetailList DeductionDetailList = new DeductionWithDetailList();
* typeReportSource.TypeName = typeof(DeductionWithDetailList).AssemblyQualifiedName;
* break;
*/
case "GratuitywithDetailList":
GratuitySetupDRL GratuitywithDetailList = new GratuitySetupDRL();
typeReportSource.TypeName = typeof(GratuitySetupDRL).AssemblyQualifiedName;
break;
case "GratuityDTLList":
GratuitySetupDTL GratuityDTLList = new GratuitySetupDTL();
typeReportSource.TypeName = typeof(GratuitySetupDTL).AssemblyQualifiedName;
break;
case "GratuityPaycodeList":
GratuityPaycode GratuityPaycodeList = new GratuityPaycode();
typeReportSource.TypeName = typeof(GratuityPaycode).AssemblyQualifiedName;
break;
case "LeavePatternList":
LeavePattern LeavePatternList = new LeavePattern();
typeReportSource.TypeName = typeof(LeavePattern).AssemblyQualifiedName;
break;
case "OvertimeWithDetailList":
OvertimeSetupDRL OvertimeWithDetailList = new OvertimeSetupDRL();
typeReportSource.TypeName = typeof(OvertimeSetupDRL).AssemblyQualifiedName;
break;
case "OvertimeDTLList":
OvertimeSetupDTL OvertimeDTLList = new OvertimeSetupDTL();
typeReportSource.TypeName = typeof(OvertimeSetupDTL).AssemblyQualifiedName;
break;
case "OvertimePaycodeList":
OvertimePaycode OvertimePaycodeList = new OvertimePaycode();
typeReportSource.TypeName = typeof(OvertimePaycode).AssemblyQualifiedName;
break;
#region Leave Transaction Reports
case "LeavetransactionbyID":
LeaveTrxEntryByID LeaveTransaction = new LeaveTrxEntryByID();
typeReportSource.TypeName = typeof(LeaveTrxEntryByID).AssemblyQualifiedName;
break;
#endregion
}
ReportViewer1.ReportSource = typeReportSource;
ReportViewer1.RefreshReport();
}
public IHttpActionResult SubDivision(DivisionMaster _division)
{
DivisionMaster _Division = _DivisionService.GetDivisionById(_division);
return(Json(_Division));
}
