public bool SaveData(AppSettingDL objList)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
try
{
OpenEntityConnection();
int Result = 0;
string emSerialNo = (objList.EmpSerialForDocNotify == null ? 0 : objList.EmpSerialForDocNotify).ToString();
App_Settings ObjForUpdate = (from objLinq in objPharmaEntities.App_Settings
where objLinq.Company_Id == objList.Company_Id && objLinq.Branch_Id == objList.Branch_Id
select objLinq).FirstOrDefault();
if (ObjForUpdate != null)
{
//bool resultupdate = objPharmaEntities.ChangeTracker.HasChanges();
//if (resultupdate)
//{
ObjForUpdate.EmpSerialForDocNotify = Convert.ToDecimal(emSerialNo);
ObjForUpdate.CalcWithGrade = objList.CalcWithGrade;
ObjForUpdate.UseTimeInWorkFlowRequest = objList.UseTimeInWorkFlowRequest;
ObjForUpdate.PerioddayToForwordRequest = objList.PerioddayToForwordRequest;
ObjForUpdate.PeriodDayToNotifyFinishContract = objList.PeriodDayToNotifyFinishContract;
ObjForUpdate.PayrollDay = objList.PayrollDay;
ObjForUpdate.AllowedPeriodForStopRequestEffect = objList.AllowedPeriodForStopRequestEffect;
ObjForUpdate.WorkingHoursPerDay = objList.WorkingHoursPerDay;
ObjForUpdate.ApplyPermissionDiscount = objList.ApplyPermissionDiscount;
ObjForUpdate.VacAllownaceBOrA = "1";
ObjForUpdate.chkVacAfterMonth = objList.chkVacAfterMonth;
ObjForUpdate.chkPaidByLastSal = objList.chkPaidByLastSal;
ObjForUpdate.chkAbilityTransferVac = objList.chkAbilityTransferVac;
ObjForUpdate.chkAbilityTrncferToNext = objList.chkAbilityTrncferToNext;
ObjForUpdate.MaxTrnsferPeriod = objList.MaxTrnsferPeriod;
ObjForUpdate.VacTransferAllownceSalaryItem = objList.VacTransferAllownceSalaryItem;
ObjForUpdate.VacAllownceSalaryItem = objList.VacAllownceSalaryItem;
ObjForUpdate.AbsenceSalaryItem = objList.AbsenceSalaryItem;
ObjForUpdate.DelySalaryItem = objList.DelySalaryItem;
ObjForUpdate.ExtraSalaryItem = objList.ExtraSalaryItem;
ObjForUpdate.VacTicketHireItem_Id = objList.VacTicketHireItem_Id;
ObjForUpdate.AbsenceCalcWayByDay = objList.AbsenceCalcWayByDay;
ObjForUpdate.SalPrevDuesDHireItem_Id = objList.SalPrevDuesDHireItem_Id;
ObjForUpdate.IntegratedWithGL = objList.IntegratedWithGL;
ObjForUpdate.CalcSalDayRateWay = objList.CalcSalDayRateWay;
ObjForUpdate.SalDayRate = objList.SalDayRate;
ObjForUpdate.SalCalcWay = objList.SalCalcWay;
//ObjForUpdate.CustomerCompany_Code = objList.CustomerCompany_Code;
ObjForUpdate.MaxallowedTransferdays = objList.MaxallowedTransferdays;
ObjForUpdate.FlightRservationManEmail = objList.FlightRservationManEmail;
//ObjForUpdate.PeriodDayToNotifyFinishTesting = objList.PeriodDayToNotifyFinishTesting;
Result = objPharmaEntities.SaveChanges();
Result = 1;
return(Result > 0);
//}
//else
//{
// return true;
//}
}
else
{
App_Settings loclDtls = new App_Settings
{
Branch_Id = objList.Branch_Id,
Company_Id = objList.Company_Id,
EmpSerialForDocNotify = Convert.ToDecimal(emSerialNo),
CalcWithGrade = objList.CalcWithGrade,
UseTimeInWorkFlowRequest = objList.UseTimeInWorkFlowRequest,
PerioddayToForwordRequest = objList.PerioddayToForwordRequest,
WorkingHoursPerDay = objList.WorkingHoursPerDay,
PeriodDayToNotifyFinishContract = objList.PeriodDayToNotifyFinishContract,
PayrollDay = objList.PayrollDay,
AllowedPeriodForStopRequestEffect = objList.AllowedPeriodForStopRequestEffect,
ApplyPermissionDiscount = objList.ApplyPermissionDiscount,
VacAllownaceBOrA = objList.VacAllownaceBOrA,
chkVacAfterMonth = objList.chkVacAfterMonth,
chkPaidByLastSal = objList.chkPaidByLastSal,
chkAbilityTransferVac = objList.chkAbilityTransferVac,
chkAbilityTrncferToNext = objList.chkAbilityTrncferToNext,
MaxTrnsferPeriod = objList.MaxTrnsferPeriod,
VacTransferAllownceSalaryItem = objList.VacTransferAllownceSalaryItem,
VacAllownceSalaryItem = objList.VacAllownceSalaryItem,
AbsenceSalaryItem = objList.AbsenceSalaryItem,
DelySalaryItem = objList.DelySalaryItem,
ExtraSalaryItem = objList.ExtraSalaryItem,
VacTicketHireItem_Id = objList.VacTicketHireItem_Id,
AbsenceCalcWayByDay = objList.AbsenceCalcWayByDay,
SalPrevDuesDHireItem_Id = objList.SalPrevDuesDHireItem_Id,
IntegratedWithGL = objList.IntegratedWithGL,
CalcSalDayRateWay = objList.CalcSalDayRateWay,
SalDayRate = objList.SalDayRate,
SalCalcWay = objList.SalCalcWay,
//CustomerCompany_Code = objList.CustomerCompany_Code,
MaxallowedTransferdays = objList.MaxallowedTransferdays,
FlightRservationManEmail = objList.FlightRservationManEmail,
//PeriodDayToNotifyFinishTesting = objList.PeriodDayToNotifyFinishTesting
};
objPharmaEntities.App_Settings.Add(loclDtls);
//saves all above operations within one transaction
Result = objPharmaEntities.SaveChanges();
return(Result > 0);
}
}
catch (Exception ex)
{
catchEntityvalidation((System.Data.Entity.Validation.DbEntityValidationException)ex, System.Runtime.InteropServices.Marshal.GetExceptionCode().ToString(),
this.UserNameProperty.ToString(), this.GetType().Name.ToString(), methodBase.Name.ToString());
ex.InnerException.Message.ToString();
return(false);
}
finally
{
CloseEntityConnection();
}
}
public AppSettingDL GetDataByBranchandCompany(string strCompany_Id, string strBranch_Id)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
try
{
OpenEntityConnection();
App_Settings ObjlistAppSetting = (from objLinq in objPharmaEntities.App_Settings
where objLinq.Company_Id == strCompany_Id && objLinq.Branch_Id == strBranch_Id
select objLinq).FirstOrDefault();
if (ObjlistAppSetting != null)
{
AppSettingDL objAppSettingDL = new AppSettingDL();
{
objAppSettingDL.Branch_Id = ObjlistAppSetting.Branch_Id;
objAppSettingDL.Company_Id = ObjlistAppSetting.Company_Id;
objAppSettingDL.EmpSerialForDocNotify = ObjlistAppSetting.EmpSerialForDocNotify;
objAppSettingDL.CalcWithGrade = ObjlistAppSetting.CalcWithGrade;
objAppSettingDL.UseTimeInWorkFlowRequest = ObjlistAppSetting.UseTimeInWorkFlowRequest;
objAppSettingDL.PerioddayToForwordRequest = ObjlistAppSetting.PerioddayToForwordRequest;
objAppSettingDL.PeriodDayToNotifyFinishContract = ObjlistAppSetting.PeriodDayToNotifyFinishContract;
objAppSettingDL.PayrollDay = ObjlistAppSetting.PayrollDay;
objAppSettingDL.AllowedPeriodForStopRequestEffect = ObjlistAppSetting.AllowedPeriodForStopRequestEffect;
objAppSettingDL.WorkingHoursPerDay = ObjlistAppSetting.WorkingHoursPerDay;
objAppSettingDL.ApplyPermissionDiscount = ObjlistAppSetting.ApplyPermissionDiscount;
objAppSettingDL.VacAllownaceBOrA = "1";
objAppSettingDL.chkVacAfterMonth = ObjlistAppSetting.chkVacAfterMonth;
objAppSettingDL.chkPaidByLastSal = ObjlistAppSetting.chkPaidByLastSal;
objAppSettingDL.chkAbilityTransferVac = ObjlistAppSetting.chkAbilityTransferVac;
objAppSettingDL.chkAbilityTrncferToNext = ObjlistAppSetting.chkAbilityTrncferToNext;
objAppSettingDL.MaxTrnsferPeriod = ObjlistAppSetting.MaxTrnsferPeriod;
objAppSettingDL.VacTransferAllownceSalaryItem = ObjlistAppSetting.VacTransferAllownceSalaryItem;
objAppSettingDL.VacAllownceSalaryItem = ObjlistAppSetting.VacAllownceSalaryItem;
objAppSettingDL.AbsenceSalaryItem = ObjlistAppSetting.AbsenceSalaryItem;
objAppSettingDL.DelySalaryItem = ObjlistAppSetting.DelySalaryItem;
objAppSettingDL.ExtraSalaryItem = ObjlistAppSetting.ExtraSalaryItem;
objAppSettingDL.VacTicketHireItem_Id = ObjlistAppSetting.VacTicketHireItem_Id;
objAppSettingDL.AbsenceCalcWayByDay = ObjlistAppSetting.AbsenceCalcWayByDay;
objAppSettingDL.SalPrevDuesDHireItem_Id = ObjlistAppSetting.SalPrevDuesDHireItem_Id;
objAppSettingDL.IntegratedWithGL = ObjlistAppSetting.IntegratedWithGL;
objAppSettingDL.CalcSalDayRateWay = ObjlistAppSetting.CalcSalDayRateWay;
objAppSettingDL.SalDayRate = ObjlistAppSetting.SalDayRate;
objAppSettingDL.SalCalcWay = ObjlistAppSetting.SalCalcWay;
//objAppSettingDL.CustomerCompany_Code = ObjlistAppSetting.CustomerCompany_Code;
objAppSettingDL.MaxallowedTransferdays = ObjlistAppSetting.MaxallowedTransferdays;
objAppSettingDL.FlightRservationManEmail = ObjlistAppSetting.FlightRservationManEmail;
//objAppSettingDL.PeriodDayToNotifyFinishTesting = ObjlistAppSetting.PeriodDayToNotifyFinishTesting;
}
return(objAppSettingDL);
}
else
{
return(null);
}
}
catch (Exception ex)
{
catchEntityvalidation((System.Data.Entity.Validation.DbEntityValidationException)ex, System.Runtime.InteropServices.Marshal.GetExceptionCode().ToString(),
this.UserNameProperty.ToString(), this.GetType().Name.ToString(), methodBase.Name.ToString());
ex.InnerException.Message.ToString();
return(null);
}
finally
{
CloseEntityConnection();
}
}
