public List <HiringMonth_FollowUpDL> GetEmpHiringMonthDues(string Company_Id, string Branch_Id, string MonthNo)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
try
{
OpenEntityConnection();
List <HiringMonth_FollowUpDL> objectList = new List <HiringMonth_FollowUpDL>();
object[] param1 =
{
new SqlParameter("@Company_Id", Company_Id),
new SqlParameter("@Branch_Id", Branch_Id),
new SqlParameter("@MonthNo", MonthNo)
};
var objlist = objPharmaEntities.Database.SqlQuery <HiringMonth_FollowUpDL>("exec dbo.SPGetEmpMonthDues @Company_Id,@Branch_Id,@MonthNo", param1).ToList();
foreach (var obj in objlist)
{
HiringMonth_FollowUpDL objHiringMonth_FollowUpDL = new HiringMonth_FollowUpDL();
objHiringMonth_FollowUpDL.HireItem_Id = obj.HireItem_Id;
objHiringMonth_FollowUpDL.HireItem_Name = obj.HireItem_Name;
objHiringMonth_FollowUpDL.HireItem_NameEn = obj.HireItem_NameEn;
objHiringMonth_FollowUpDL.HireItem_Value = obj.HireItem_Value;
objHiringMonth_FollowUpDL.Emp_Serial_No = obj.Emp_Serial_No;
objHiringMonth_FollowUpDL.HireItem_Type = obj.HireItem_Type;
objHiringMonth_FollowUpDL.CompanyId = obj.CompanyId;
objHiringMonth_FollowUpDL.BranchId = obj.BranchId;
objHiringMonth_FollowUpDL.MonthNo = obj.MonthNo;
objectList.Add(objHiringMonth_FollowUpDL);
}
return(objectList);
//Rec_No ,ReferenceNo ,Request_Id
//,Company_Id ,Branch_Id ,Emp_Serial_No ,TransDate ,FromDate ,ToDate ,BackDate ,Reason ,InsUser ,InsDate ,Order_Status ,PlaceOfResidence ,DocumentPath ,RequestTypeName ,StatusName
}
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 List <HiringMonth_FollowUpDL> SelectAllHiringMonth_FollowUp(string Company_Id, string Branch_Id, decimal Emp_serialNo, string MonthNo)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
try
{
OpenEntityConnection();
List <HiringMonth_FollowUpDL> objectList = new List <HiringMonth_FollowUpDL>();
var objlist = (from objLinq in objPharmaEntities.Hr_HiringMonth_FollowUp_Hdr
join objlinqhdr in objPharmaEntities.Hr_HiringMonth_FollowUp_Dtls
on objLinq.Rec_Hdr_Id equals objlinqhdr.RecHdr_Id
where objLinq.Company_Id == Company_Id && objLinq.Branch_Id == Branch_Id && objLinq.Emp_Serial_No == Emp_serialNo && objLinq.Month_No == MonthNo
orderby objlinqhdr.HireItem_Id
//&& objLinq.Grade_Id == Grade_Id
select new
{
Branch_Id = objLinq.Branch_Id,
Company_Id = objLinq.Company_Id,
Emp_Serial_No = objLinq.Emp_Serial_No,
Month_No = objLinq.Month_No,
HireItem_Id = objlinqhdr.HireItem_Id,
HireItem_Type = objlinqhdr.HireItem_Type,
HireItem_Value = objlinqhdr.HireItem_Value,
HireItem_ActuallValue = objlinqhdr.HireItem_ActuallValue,
HireItem_DiffValue = objlinqhdr.HireItem_DiffValue,
RecHdr_Id = objlinqhdr.RecHdr_Id,
Dtls_Id = objlinqhdr.Dtls_Id,
Sal_Month_Status = objLinq.Sal_Month_Status
}).ToList();
foreach (var obj in objlist)
{
HiringMonth_FollowUpDL objHiringMonth_FollowUpDL = new HiringMonth_FollowUpDL();
objHiringMonth_FollowUpDL.BranchId = obj.Branch_Id;
objHiringMonth_FollowUpDL.CompanyId = obj.Company_Id;
objHiringMonth_FollowUpDL.Emp_Serial_No = obj.Emp_Serial_No;
objHiringMonth_FollowUpDL.MonthNo = obj.Month_No;
objHiringMonth_FollowUpDL.HireItem_Id = obj.HireItem_Id;
objHiringMonth_FollowUpDL.HireItem_Type = obj.HireItem_Type;
objHiringMonth_FollowUpDL.HireItem_Value = obj.HireItem_Value;
objHiringMonth_FollowUpDL.HireItem_ActuallValue = obj.HireItem_ActuallValue;
objHiringMonth_FollowUpDL.HireItem_DiffValue = obj.HireItem_DiffValue;
objHiringMonth_FollowUpDL.RecHdr_Id = obj.RecHdr_Id;
objHiringMonth_FollowUpDL.Dtls_Id = obj.Dtls_Id;
objHiringMonth_FollowUpDL.Sal_Month_Status = obj.Sal_Month_Status;
objectList.Add(objHiringMonth_FollowUpDL);
}
return(objectList);
//Rec_No ,ReferenceNo ,BranchAccount_Id
//,Company_Id ,Branch_Id ,Emp_Serial_No ,TransDate ,FromDate ,ToDate ,BackDate ,Reason ,InsUser ,InsDate ,Order_Status ,PlaceOfResidence ,DocumentPath ,BranchAccountTypeName ,StatusName
}
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();
}
}
