public static LoginModel GetEmployeeDetails(string id, string conn)
{
LoginModel user = null;
using (var DbContext = new SalesReturndbEntities())
{
var source = DbContext.SP_LFGDetails(id).FirstOrDefault();
var IfDepotPerson = DbContext.sp_CheckIfDepotPerson(id).FirstOrDefault();
if (source != null)
{
user = new LoginModel
{
EMP_CODE = source.EMP_CODE.ToString(),
Emp_First_name = source.Emp_First_name.ToString(),
Desg_Desc = source.Desg_Desc,
Dept_name = source.Dept_name,
IsDepotPerson = IfDepotPerson != null?true:false,
DepotName = IfDepotPerson?.DepotName,
DepotCode = IfDepotPerson?.DepotCode,
Seg_Name = source.Seg_Name,
DepotId = IfDepotPerson != null? IfDepotPerson.DepotId:0,
email_id = source.email_id,
Mobile_no = source.Mobile_no,
SBU_Name = source.SBU_Name,
Zone = source.Zone,
RegionHead = source.Regional_Head,
SegmentHead = source.Country_Head,
Oth_key = id,
Country = source.Country
};
var checkAdmin = DbContext.TblAdminMasters.Where(x => x.EmployeeCode.Equals(id) && x.IsActive == true).FirstOrDefault();
if (id.Equals("0") || checkAdmin != null)
{
user.RoleName = "Admin";
}
}
}
return(user);
}
