public Hr_EmpPermission_Settings GetPermmissionSettingDataByBranchandCompany(string strCompany_Id, string strBranch_Id)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
try
{
OpenEntityConnection();
Hr_EmpPermission_Settings ObjEmpPermission_Settings = (from objLinq in objPharmaEntities.Hr_EmpPermission_Settings
where objLinq.Company_Id == strCompany_Id && objLinq.Branch_Id == strBranch_Id
select objLinq).FirstOrDefault();
if (ObjEmpPermission_Settings != null)
{
Hr_EmpPermission_Settings objEmpPermission_SettingsDL = new Hr_EmpPermission_Settings();
{
objEmpPermission_SettingsDL.Branch_Id = ObjEmpPermission_Settings.Branch_Id;
objEmpPermission_SettingsDL.Company_Id = ObjEmpPermission_Settings.Company_Id;
objEmpPermission_SettingsDL.AllowedValueInMonthByHour = ObjEmpPermission_Settings.AllowedValueInMonthByHour;
objEmpPermission_SettingsDL.AllowedValueInDayByHour = ObjEmpPermission_Settings.AllowedValueInDayByHour;
objEmpPermission_SettingsDL.PeriodForDay = ObjEmpPermission_Settings.PeriodForDay;
objEmpPermission_SettingsDL.HourNoForDiscount = ObjEmpPermission_Settings.HourNoForDiscount;
objEmpPermission_SettingsDL.AllowToExceedMonthValue = ObjEmpPermission_Settings.AllowToExceedMonthValue;
objEmpPermission_SettingsDL.AllowToExceedDayValue = ObjEmpPermission_Settings.AllowToExceedDayValue;
objEmpPermission_SettingsDL.OnlyApplyDiscount = ObjEmpPermission_Settings.OnlyApplyDiscount;
objEmpPermission_SettingsDL.CountOfPermissionAllowedInMonth = ObjEmpPermission_Settings.CountOfPermissionAllowedInMonth;
objEmpPermission_SettingsDL.AllowToExceedCountAllowedInMonth = ObjEmpPermission_Settings.AllowToExceedCountAllowedInMonth;
objEmpPermission_SettingsDL.AllowedMenthodType = ObjEmpPermission_Settings.AllowedMenthodType;
}
return(objEmpPermission_SettingsDL);
}
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();
}
}
public bool SavePermmissionSettingData(Hr_EmpPermission_Settings objList)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
try
{
OpenEntityConnection();
int Result = 0;
// string emSerialNo = (objList.EmpSerialForDocNotify == null ? 0 : objList.EmpSerialForDocNotify).ToString();
Hr_EmpPermission_Settings ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpPermission_Settings
where objLinq.Company_Id == objList.Company_Id && objLinq.Branch_Id == objList.Branch_Id
select objLinq).FirstOrDefault();
if (ObjForUpdate != null)
{
ObjForUpdate.AllowedValueInMonthByHour = objList.AllowedValueInMonthByHour;
ObjForUpdate.AllowedValueInDayByHour = objList.AllowedValueInDayByHour;
ObjForUpdate.PeriodForDay = objList.PeriodForDay;
ObjForUpdate.HourNoForDiscount = objList.HourNoForDiscount;
ObjForUpdate.AllowToExceedMonthValue = objList.AllowToExceedMonthValue;
ObjForUpdate.AllowToExceedDayValue = objList.AllowToExceedDayValue;
ObjForUpdate.OnlyApplyDiscount = objList.OnlyApplyDiscount;
ObjForUpdate.CountOfPermissionAllowedInMonth = objList.CountOfPermissionAllowedInMonth;
ObjForUpdate.AllowToExceedCountAllowedInMonth = objList.AllowToExceedCountAllowedInMonth;
ObjForUpdate.AllowedMenthodType = objList.AllowedMenthodType;
Result = objPharmaEntities.SaveChanges();
return(Result > 0);
}
else
{
if (objList != null)
{
Hr_EmpPermission_Settings loclDtls = new Hr_EmpPermission_Settings
{
Branch_Id = objList.Branch_Id,
Company_Id = objList.Company_Id,
AllowedValueInMonthByHour = objList.AllowedValueInMonthByHour,
AllowedValueInDayByHour = objList.AllowedValueInDayByHour,
PeriodForDay = objList.PeriodForDay,
HourNoForDiscount = objList.HourNoForDiscount,
AllowToExceedMonthValue = objList.AllowToExceedMonthValue,
AllowToExceedDayValue = objList.AllowToExceedDayValue,
OnlyApplyDiscount = objList.OnlyApplyDiscount,
CountOfPermissionAllowedInMonth = objList.CountOfPermissionAllowedInMonth,
AllowToExceedCountAllowedInMonth = objList.AllowToExceedCountAllowedInMonth,
AllowedMenthodType = objList.AllowedMenthodType,
};
objPharmaEntities.Hr_EmpPermission_Settings.Add(loclDtls);
//saves all above operations within one transaction
Result = objPharmaEntities.SaveChanges();
return(Result > 0);
}
else
{
return(false);
}
}
}
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();
}
}
