public static List <PendingRequestModel> getPendingRequest(string EmployeeCode)
{
using (var context = new SalesReturndbEntities())
{
List <PendingRequestModel> dataList = null;
var PendingRequestList = context.SP_GetPendingRequest(EmployeeCode).ToList();
if (PendingRequestList != null)
{
dataList = PendingRequestList.Select(x => new PendingRequestModel()
{
BatchNo = x.BatchNo,
DealerAddress = x.DealerAddress,
DealerCode = x.DealerCode,
DealerName = x.DealerName,
DepotName = x.DepotName,
DepotAddress = x.DepotAddress,
DepotCode = x.DepotCode,
FutureStatus = x.FutureStatus,
RequestHeaderId = x.RequestHeaderId,
FutureStatus_Id = x.FutureStatus_Id,
CurrentStatus_Id = x.CurrentStatus_Id,
SKUCode = x.SKUCode,
SKUName = x.SKUName,
CreatedBy_EMP_CODE = x.CreatedBy,
CreatedBy = context.SP_LFGDetails(x.CreatedBy).FirstOrDefault().Emp_First_name,
CreatedDate = x.CreatedDate,
TotalSRV = context.tblRequestDtls.Where(o => o.RequestHeaderId == x.RequestHeaderId && o.IsActive == true).Sum(p => p.SRVValue).Value,
RequestTypeOption = x.SKUCode,// for access data behalf on skucode
}).ToList();
return(dataList);
}
return(dataList);
}
}
public static string ApproveRequest(RecommendRequestObj data)
{
try
{
using (var context = new SalesReturndbEntities())
{
string RequestType = "approve";
var RequestDetail = context.tblRequestDtls.Where(x => x.RequestHeaderId == data.Request_Id && x.IsActive == true).ToList();
var approvalHeader = context.TblApproverHeaders.Where(x => x.Request_Id == data.Request_Id && x.IsActive == true).FirstOrDefault();
var ReqHdr = context.TblRequestHeaders.Where(x => x.RequestHeaderId == data.Request_Id && x.IsActive == true).FirstOrDefault();
RequestDetailObj_Render data1 = CommonDAL.GetRequestDetails(data.Request_Id, data.CurrentStatus_Id, data.FutureStatus_Id);
var UserDetail = context.SP_LFGDetails(approvalHeader.CreatedBy).FirstOrDefault();
var DepotDTl = context.sp_GetDealerDtlBy_DealerRepositoryId(ReqHdr.DealerId).FirstOrDefault();
string assignTo = string.Empty;
var DepotPersonDtl = context.TblEmployeeMasters.Where(x => x.DepotName == DepotDTl.Depot).FirstOrDefault();
if (data.FutureStatus_Id == 10019)
{
assignTo = DepotPersonDtl.Depotcode;
}
ApproverDAL.UpdateRequestStatus(false, Convert.ToInt32(data.Request_Id), data.EmployeeCode, assignTo, data.Active_Role, data.Requested_Role, data.CurrentStatus_Id, data.FutureStatus_Id, data.Remarks);
SendMail(approvalHeader, data, RequestType, assignTo);
return("Success : " + ReqHdr.RequestTypeOption + "-" + data.Request_Id + " Requested has been approved successfully.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ApprovalMatrixModal> getApprovalMatrixData()
{
using (var context = new SalesReturndbEntities())
{
List <ApprovalMatrixModal> objList = null;
var dataList = context.TblApprovalMatrices.Where(x => x.IsActive == true).ToList();
if (dataList != null)
{
objList = dataList.Select(x => new ApprovalMatrixModal()
{
Country = x.Country,
BUType = x.BUType,
Division = x.Division,
RequestType = x.RequestType,
SRV_Value = x.SRV_Value,
InvoiceAge = x.InvoiceAge,
ComplaintHandler = x.ComplaintHandler,
ComplaintManager = x.ComplaintManager,
LogisticsManager = x.LogisticsManager,
LogisticsHead = x.LogisticsHead,
SegmentHeadHRV = x.SegmentHeadHRV,
SegmentInvoiceAge = x.SegmentInvoiceAge,
Matrix_Id = x.Matrix_Id,
VPName = x.VP,
President = x.President,
}).ToList();
return(objList);
}
return(objList);
}
}
public static List <SP_GetBatchNo_Result> GetBatchNO(string SkuCode)
{
try
{
using (var context = new SalesReturndbEntities())
{
List <SP_GetBatchNo_Result> objList = context.SP_GetBatchNo(SkuCode).ToList();
objList.Add(new SP_GetBatchNo_Result
{
Product_ID = null,
SKUCode = "Other",
SKUDescription = "Other",
Batch_No = "Other"
});
return(objList);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <EmployeeMasterModel> getEmployeeList()
{
using (var context = new SalesReturndbEntities())
{
var dataList = context.TblEmployeeMasters.Where(x => x.IsActive == true).ToList();
List <EmployeeMasterModel> objList = new List <EmployeeMasterModel>();
if (dataList != null)
{
objList = dataList.Select(x => new EmployeeMasterModel()
{
CommercialCode = x.CommercialCode,
CommercialHead = x.CommercialHead,
ComplaintHandler = x.ComplaintHandler,
ComplaintManager = x.ComplaintManager,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
CSO = x.CSO,
Depotcode = x.Depotcode,
DepotName = x.DepotName,
Id = x.Id,
IsActive = x.IsActive,
ISC = x.ISC,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate,
LogisticsHead = x.LogisticsHead,
}).ToList();
return(objList);
}
return(objList);
}
}
public static List <CCStackHolder> GetCCStackHolderDetail()
{
using (var context = new SalesReturndbEntities())
{
var dataList = context.spGetCCStackHolderDetail().Where(x => x.IsDeleted == false).ToList();
List <CCStackHolder> objList = new List <CCStackHolder>();
if (dataList != null)
{
objList = dataList.Select(x => new CCStackHolder()
{
Catalyst = x.Catalyst,
ComplaintHandler = x.ComplaintHandler,
ComplaintManager = x.ComplaintManager,
CreatedBy = x.CreatedBy,
IsDeleted = x.IsDeleted,
ComplaintStakeHolders_ID = x.ComplaintStakeHolders_ID,
CreationDate = x.CreationDate,
LocalTechnical = x.LocalTechnical,
Manager = x.Manager,
SBU_Name = x.SBU_Name,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate,
}).ToList();
return(objList);
}
return(objList);
}
}
public static string DeleteList(int id, string employeeCode)
{
using (var context = new SalesReturndbEntities())
{
using (TransactionScope transaction = new TransactionScope())
{
var Check = context.TblEmployeeMasters.Where(x => x.IsActive == true && x.Id == id).FirstOrDefault();
if (Check != null)
{
//update
Check.IsActive = false;
Check.ModifiedBy = employeeCode;
Check.ModifiedDate = DateTime.Now;
context.Entry(Check).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
transaction.Complete();
transaction.Dispose();
}
}
return("Success : succssfully deleted.");
}
}
public static List <PendingRequestModel> GetOpenRequest(string empCode)
{
List <PendingRequestModel> List = new List <PendingRequestModel>();
using (var context = new SalesReturndbEntities())
{
var data = context.SP_GetOpenRequest(empCode).ToList();
if (data.Count != 0)
{
List = data.Select(x => new PendingRequestModel()
{
BatchNo = x.BatchNo,
DealerAddress = x.DealerAddress,
DealerCode = x.DealerCode,
DealerName = x.DealerName,
DepotName = x.DealerName,
DepotAddress = x.DepotAddress,
DepotCode = x.DepotCode,
RequestHeaderId = x.RequestHeaderId,
CurrentStatus = x.CurrentStatus,
CurrentStatus_Id = x.CurrentStatus_Id,
SKUCode = x.SKUCode,
SKUName = x.SKUName,
CreatedBy_EMP_CODE = x.CreatedBy,
CreatedBy = context.SP_LFGDetails(x.CreatedBy).FirstOrDefault().Emp_First_name,
CreatedDate = x.CreatedDate,
TotalSRV = context.tblRequestDtls.Where(o => o.RequestHeaderId == x.RequestHeaderId && o.IsActive == true).Sum(p => p.SRVValue),
}).ToList();
}
return(List);
}
}
public static string UpdateFlowList(List <FlowMatrixModel> obj)
{
using (var context = new SalesReturndbEntities())
{
foreach (var ob in obj)
{
try
{
var InsrtData = context.TblFlowMatrices.Where(x => x.IsActive == true && x.Id == ob.Id).FirstOrDefault();
InsrtData.Id = ob.Id;
InsrtData.ISC = ob.ISC;
InsrtData.LogisticsHead = ob.LogisticsHead;
InsrtData.President = ob.President;
InsrtData.RH = ob.RH;
InsrtData.SegmentHead = ob.SegmentHead;
InsrtData.VP = ob.VP;
InsrtData.ComplaintHandler = ob.ComplaintHandler;
InsrtData.ComplaintManager = ob.ComplaintManager;
InsrtData.ModifiedBy = ob.ModifiedBy;
context.Entry(InsrtData).State = EntityState.Modified;
context.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
return("Success");
}
}
public static MailAddressCollection GetCC(RecommendRequestObj obj)
{
try
{
using (var context = new SalesReturndbEntities())
{
MailAddressCollection ccEmail = new MailAddressCollection();
RequestDetailObj_Render data1 = CommonDAL.GetRequestDetails(obj.Request_Id, obj.CurrentStatus_Id, obj.FutureStatus_Id);
var RegionalHead = context.SP_LFGDetails(data1.EmployeeCode).FirstOrDefault();
if (RegionalHead != null)
{
if (!(RegionalHead.Regional_Head.ToUpper().Trim().Equals("NA") || RegionalHead.Regional_Head.Trim().Equals(string.Empty)))
{
var RegionalHeadData = context.SP_LFGDetails(RegionalHead.Regional_Head).FirstOrDefault();
ccEmail.Add(RegionalHeadData.email_id);
}
if (!(RegionalHead.segmentHead.ToUpper().Trim().Equals("NA") || RegionalHead.segmentHead.Trim().Equals(string.Empty)))
{
var SegmentHeadData = context.SP_LFGDetails(RegionalHead.segmentHead).FirstOrDefault();
ccEmail.Add(SegmentHeadData.email_id);
}
ccEmail.Add(RegionalHead.email_id);//Email Id of Requestor
}
var DepotMaster = context.SP_GetDepotList().Where(x => x.DepotId == data1.DepotId).FirstOrDefault();
var AssintoEmp = context.TblEmployeeMasters.Where(x => x.IsActive == true && x.DepotName == DepotMaster.DepotName).FirstOrDefault();
var ComplaintHandler = context.SP_LFGDetails(AssintoEmp.ComplaintHandler).FirstOrDefault();
var CompalintManager = context.SP_LFGDetails(AssintoEmp.ComplaintManager).FirstOrDefault();
ccEmail.Add(ComplaintHandler.email_id);
ccEmail.Add(CompalintManager.email_id);
var LogistickHead = context.SP_LFGDetails(AssintoEmp.LogisticsHead).FirstOrDefault();
ccEmail.Add(LogistickHead.email_id);
if (RegionalHead != null)
{
if (!(RegionalHead.VPHead.ToUpper().Trim().Equals("NA") || RegionalHead.VPHead.Trim().Equals(string.Empty)))
{
var vphead = context.sp_GetuserDetailsFromLFG(RegionalHead.VPHead).FirstOrDefault();
ccEmail.Add(vphead.email_id);
}
if (!(RegionalHead.President_Code.ToUpper().Trim().Equals("NA") || RegionalHead.President_Code.Trim().Equals(string.Empty)))
{
var President_Code = context.sp_GetuserDetailsFromLFG(RegionalHead.President_Code).FirstOrDefault();
ccEmail.Add(President_Code.email_id);
}
}
var depot = context.SP_LFGDetails(AssintoEmp.Depotcode).FirstOrDefault();
ccEmail.Add(depot.email_id);
var cso = context.SP_LFGDetails(AssintoEmp.CSO).FirstOrDefault();
ccEmail.Add(cso.email_id);
return(ccEmail);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int GetApprovedRequestCount(string empCode)
{
using (var context = new SalesReturndbEntities())
{
int Count = context.SP_GetApprovedRequest(empCode).Count();
return(Count);
}
}
public static List <spGetMasterReportData_Result> GetMasterReport(DateTime datefrom, DateTime dateTo)
{
using (var context = new SalesReturndbEntities())
{
var dataobj = context.spGetMasterReportData(datefrom, dateTo).ToList();
return(dataobj);
}
}
public static int GetPendingSRVBillingClosureRequestCount(string empCode)
{
using (var context = new SalesReturndbEntities())
{
int Count = context.SP_GetPendingRequestForDepot(empCode).Count();
return(Count);
}
}
public static int GetSalesTotalRequestCount(string empCode)
{
using (var context = new SalesReturndbEntities())
{
int Count = context.SP_GetTotalRequest(empCode).Where(x => x.SKUCode == "S").Count();
return(Count);
}
}
public static DateTime GetLastThreeMonthDate()
{
using (var context = new SalesReturndbEntities())
{
var dat = DateTime.Now.AddMonths(-3);
return(dat);
}
}
public static string UpdateAdminList(List <AdminMasterModal> data)
{
using (var context = new SalesReturndbEntities())
{
using (TransactionScope transaction = new TransactionScope())
{
foreach (var Obj in data)
{
//CommonDAL.CheckIfEmployeeExist(Obj.VPName);
var duplicateCheck = context.TblAdminMasters.Where(x => x.Admin_Id == Obj.Admin_Id && x.IsActive == true).FirstOrDefault();
if (duplicateCheck != null)
{
var duplicateCheckValue = context.TblAdminMasters.Where(x => x.EmployeeCode == Obj.EmployeeCode && x.Admin_Id != Obj.Admin_Id && x.IsActive == true).FirstOrDefault();
if (duplicateCheckValue == null)
{
duplicateCheck.EmployeeCode = Obj.EmployeeCode;
duplicateCheck.ModifiedBy = Obj.CreatedBy;
duplicateCheck.ModifiedDate = DateTime.Now;
context.Entry(duplicateCheck).State = EntityState.Modified;
context.SaveChanges();
}
}
else
{
var duplicateCheckValue = context.TblAdminMasters.Where(x => x.EmployeeCode == Obj.EmployeeCode && x.IsActive == true).FirstOrDefault();
if (duplicateCheckValue == null)
{
TblAdminMaster marix = new TblAdminMaster()
{
EmployeeCode = Obj.EmployeeCode,
IsActive = true,
CreatedBy = Obj.CreatedBy,
CreatedDate = DateTime.Now,
};
context.Entry(marix).State = EntityState.Added;
context.SaveChanges();
}
}
}
transaction.Complete();
transaction.Dispose();
}
return("Success : Admin list successfully updated.");
}
}
public static string CloseRequest(CloseRequestObjForStg_4 data)
{
using (var context = new SalesReturndbEntities())
{
string AssignTo = string.Empty;
string RetMsg = string.Empty;
var RequestDetail = context.tblRequestDtls.Where(x => x.RequestHeaderId == data.Request_Id).ToList();
var approvalHeader = context.TblApproverHeaders.Where(x => x.Request_Id == data.Request_Id).FirstOrDefault();
var ReqHdr = context.TblRequestHeaders.Where(x => x.RequestHeaderId == data.Request_Id && x.IsActive == true).FirstOrDefault();
var UserDetail = context.SP_LFGDetails(approvalHeader.CreatedBy).FirstOrDefault();
var DlrDtl = context.sp_GetDealerDtlBy_DealerRepositoryId(data.Request.DealerId).FirstOrDefault();
if (data.FutureStatus_Id == 10027 || data.CurrentStatus_Id == 10028 || data.CurrentStatus_Id == 10029)
{
var EmpMaster = context.TblEmployeeMasters.Where(x => x.DepotName == DlrDtl.Depot && x.IsActive == true).FirstOrDefault();
AssignTo = data.FutureStatus_Id == 10027 ? EmpMaster.Depotcode : "";
if (data.Request.IsCommercialSettlement == true)
{
var EpCheck = context.sp_CheckEPNumber(data.Request.EPNo).FirstOrDefault();
if (EpCheck == null)
{
return("Error: EP Number does not exists");
}
}
ReqHdr.IsCommercialSettlement = data.Request.IsCommercialSettlement;
ReqHdr.MaterialWillGoToDealer = data.Request.IsCommercialSettlement == true ? false : true;
ReqHdr.ReasonForCommercialSettlement = data.Request.IsCommercialSettlement == true ? data.Request.ReasonForCommercialSettlement : "";
ReqHdr.DetailsForMaterialGoToDealer = data.Request.IsCommercialSettlement == false ? data.Request.DetailsForMaterialGoToDealer : "";
ReqHdr.EPNo = data.Request.IsCommercialSettlement == true ? data.Request.EPNo : "";
ReqHdr.ModifiedBy = data.EmployeeCode;
ReqHdr.ModifiedDate = DateTime.Now;
context.Entry(ReqHdr).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
RetMsg = data.FutureStatus_Id == 10027 ? "Request has been forwarded to Depot!" : "Request has been closed successfully!";
}
else if (data.CurrentStatus_Id == 10030)
{
ReqHdr.DocketNumber = data.Request.DocketNumber;
ReqHdr.DocketDate = data.Request.DocketDate;
context.Entry(ReqHdr).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
RetMsg = "Request has been closed successfully!";
}
else
{
RetMsg = "Request has been closed successfully!";
}
ApproverDAL.UpdateRequestStatus(false, Convert.ToInt32(data.Request_Id), data.EmployeeCode, AssignTo, data.Active_Role, data.Requested_Role, data.CurrentStatus_Id, data.FutureStatus_Id, data.Remarks);
return("Success : " + ReqHdr.RequestTypeOption + data.Request_Id + " " + RetMsg);
}
}
public static string SaveRequestType(List <RequestTypeModal> list)
{
using (var context = new SalesReturndbEntities())
{
using (TransactionScope transaction = new TransactionScope())
{
foreach (var obj in list)
{
var duplicateCheck = context.TblRequestTypes.Where(x => x.IsActive == true && x.RequestType_Id == obj.RequestType_Id).FirstOrDefault();
if (duplicateCheck != null)
{
var duplicateValueCheck = context.TblRequestTypes.Where(x => x.RequestType.Equals(obj.RequestType) && x.IsActive == true && x.RequestType_Id != obj.RequestType_Id).FirstOrDefault();
if (duplicateValueCheck == null)
{
//update
duplicateCheck.RequestType = obj.RequestType;
duplicateCheck.ModifiedBy = obj.EmployeeCode;
duplicateCheck.ModifiedDate = DateTime.Now;
context.Entry(duplicateCheck).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
else
{
var duplicateValueCheck = context.TblRequestTypes.Where(x => x.RequestType.Equals(obj.RequestType) && x.IsActive == true).FirstOrDefault();
if (duplicateValueCheck == null)
{
//new entry
TblRequestType RequestType = new TblRequestType()
{
RequestType = obj.RequestType,
IsActive = true,
CreatedBy = obj.EmployeeCode,
CreatedDate = DateTime.Now,
};
context.Entry(RequestType).State = System.Data.Entity.EntityState.Added;
context.SaveChanges();
}
}
}
transaction.Complete();
transaction.Dispose();
}
return("Success : Request types succssfully saved");
}
}
public static string RejectRequest(RecommendRequestObj data)
{
using (var context = new SalesReturndbEntities())
{
string RequestProcessType = "reject";
string AssignTo = string.Empty;
var RequestDetail = context.tblRequestDtls.Where(x => x.RequestHeaderId == data.Request_Id).ToList();
var approvalHeader = context.TblApproverHeaders.Where(x => x.Request_Id == data.Request_Id).FirstOrDefault();
var ReqHdr = context.TblRequestHeaders.Where(x => x.RequestHeaderId == data.Request_Id && x.IsActive == true).FirstOrDefault();
var IfDepotPerson = context.TblEmployeeMasters.Where(x => x.Depotcode == ReqHdr.EmployeeCode && x.IsActive == true).FirstOrDefault();
var UserDetail = context.SP_LFGDetails(approvalHeader.CreatedBy).FirstOrDefault();
var Reqfuturestatus = context.TblFutureStatus.Where(x => x.IsActive == true && x.Request_ID == ReqHdr.RequestHeaderId).OrderByDescending(y => y.FutStatus_ID).FirstOrDefault();
if (data.FutureStatus_Id == 10026 && IfDepotPerson == null)
{
if (UserDetail.Regional_Head.Trim().Equals("NA") || UserDetail.Regional_Head.Trim().Equals("N/A"))
{
return("Error: Approval Matrix not defined!!");
}
else
{
AssignTo = UserDetail.Regional_Head;
ApproverDAL.UpdateRequestStatus(false, Convert.ToInt32(data.Request_Id), data.EmployeeCode, AssignTo, data.Active_Role, data.Requested_Role, data.CurrentStatus_Id, data.FutureStatus_Id, data.Remarks);
}
}
else if (data.FutureStatus_Id == 10026 && IfDepotPerson != null)
{
var DealerDtl = context.sp_GetDealerDtlBy_DealerRepositoryId(ReqHdr.DealerId).FirstOrDefault();
bool IsRMExist = DealerDtl != null ? (DealerDtl.RMCode.Equals(string.Empty) ? false : (DealerDtl.RMCode.Contains("NA") ? false : (DealerDtl.RMCode == null ? false : true))) : false;
//if (IsRMExist) {
if (UserDetail.Regional_Head != "NA" && UserDetail.Regional_Head != null && UserDetail.Regional_Head != "")
{
// AssignTo = DealerDtl.RMCode;
AssignTo = UserDetail.Regional_Head;
ApproverDAL.UpdateRequestStatus(false, Convert.ToInt32(data.Request_Id), data.EmployeeCode, AssignTo, data.Active_Role, data.Requested_Role, data.CurrentStatus_Id, data.FutureStatus_Id, data.Remarks);
}
else
{
return("Error: Approval Matrix not defined!!");
}
}
else
{
ApproverDAL.UpdateRequestStatus(false, Convert.ToInt32(data.Request_Id), data.EmployeeCode, AssignTo, data.Active_Role, data.Requested_Role, data.CurrentStatus_Id, data.FutureStatus_Id, data.Remarks);
}
SendMail(approvalHeader, data, RequestProcessType, ReqHdr.EmployeeCode);
return("Success : " + ReqHdr.RequestTypeOption + data.Request_Id + " Requested has been rejected successfully.");
}
}
public static bool CheckIfEmployeeExist(string EmployeeCode)
{
using (var context = new SalesReturndbEntities())
{
var check = context.SP_LFGDetails(EmployeeCode).FirstOrDefault();
if (check != null)
{
return(true);
}
else
{
return(false);
}
}
}
public static TblEmployeeMaster CheckIfDepotPerson(string Emp_Code)
{
using (var DbContext = new SalesReturndbEntities())
{
var source = DbContext.TblEmployeeMasters.Where(x => x.Depotcode == Emp_Code && x.IsActive == true).FirstOrDefault();
if (source != null)
{
return(source);
}
else
{
return(null);
}
}
}
public static string ReconsiderRequest(RecommendRequestObj data)
{
using (var context = new SalesReturndbEntities())
{
string RequestProcessType = "reconsider";
var RequestDetail = context.tblRequestDtls.Where(x => x.RequestHeaderId == data.Request_Id).ToList();
var approvalHeader = context.TblApproverHeaders.Where(x => x.Request_Id == data.Request_Id).FirstOrDefault();
//var UserDetail = context.SP_LFGDetails(approvalHeader.CreatedBy).FirstOrDefault();
var Reqfuturestatus = context.TblFutureStatus.Where(x => x.IsActive == true && x.Request_ID == approvalHeader.Request_Id).OrderByDescending(y => y.FutStatus_ID).FirstOrDefault();
ApproverDAL.UpdateRequestStatus(false, Convert.ToInt32(data.Request_Id), data.EmployeeCode, approvalHeader.CreatedBy, data.Active_Role, data.Requested_Role, data.CurrentStatus_Id, data.FutureStatus_Id, data.Remarks);
SendMail(approvalHeader, data, RequestProcessType, approvalHeader.CreatedBy);
return("Success : S-" + data.Request_Id + " Requested has been reconsidered successfully.");
}
}
public static EmployeeDetailsInfo GetEmployeeRequestDetails(long RequestId)
{
using (var context = new SalesReturndbEntities())
{
var item = context.SP_GetEmployeeDetailsForRequest(RequestId).FirstOrDefault();
EmployeeDetailsInfo list = new EmployeeDetailsInfo();
list.EMP_CODE = item.EMP_CODE;
list.Emp_First_name = item.Emp_First_name;
list.Added_Date = Convert.ToDateTime(item.CreatedDate);
list.SBU_Name = item.Seg_Name;
list.Dept_name = item.Dept_name;
return(list);
}
}
public static List <CountryModal> GetCountry()
{
using (var context = new SalesReturndbEntities())
{
var list = context.SP_GetCountry().ToList();
List <CountryModal> cityList = null;
if (list != null)
{
cityList = list.Select(x => new CountryModal()
{
CountryName = x.Country
}).ToList();
return(cityList);
}
return(cityList);
}
}
public static string GetHtml(string html, RecommendRequestObj obj)
{
using (var context = new SalesReturndbEntities())
{
RequestDetailObj_Render data1 = CommonDAL.GetRequestDetails(obj.Request_Id, obj.CurrentStatus_Id, obj.FutureStatus_Id);
string RequestNumber = data1.RequestTypeOption + "-" + data1.RequestHeader_Id;
int SKUCount = data1.RequestDetail.Count;
html = html.Replace("<CustomerCode>", data1.DealerCodeForMail);
html = html.Replace("<CustomerName>", data1.DealerNameForMail);
html = html.Replace("<RequestNumber>", RequestNumber);
html = html.Replace("<DepotName>", data1.DepotNameForMail);
var reason = context.TblReasonMasters.Where(x => x.ReasonMaster_Id == data1.ReasonForReturn_Id).FirstOrDefault();
html = html.Replace("<Reason>", reason.Reason);
html = html.Replace("<CountofSKUs>", SKUCount.ToString());
//html = html.Replace("Requestor Name;", SKUCount.ToString());
decimal?SalesReturnVolume = 0;
decimal?SRVValue = 0;
decimal?ExpiredVoulme = 0;
//ToString("0.00");
for (int i = 0; i < data1.RequestDetail.Count; i++)
{
if (data1.RequestDetail[i].Volume != null)
{
SalesReturnVolume += data1.RequestDetail[i].Volume;
}
if (data1.RequestDetail[i].SRVValue != null)
{
SRVValue = SRVValue + data1.RequestDetail[i].SRVValue;
}
if (Convert.ToInt32(data1.RequestDetail[i].selectedSKU.Shelf_Life) < 0)
{
ExpiredVoulme = ExpiredVoulme + data1.RequestDetail[i].Volume;
}
}
html = html.Replace("<SalesReturnVolume>", Convert.ToDecimal(string.Format("{0:F2}", SalesReturnVolume)).ToString());
html = html.Replace("<VolumeExpired>", Convert.ToDecimal(string.Format("{0:F2}", ExpiredVoulme)).ToString());
html = html.Replace("<SalesReturnAmount>", Convert.ToDecimal(string.Format("{0:F2}", SRVValue)).ToString());
return(html);
}
}
public static List <ReasonMasterModal> GetReasonMaster()
{
using (var context = new SalesReturndbEntities())
{
List <ReasonMasterModal> dataList = null;
var objList = context.TblReasonMasters.Where(x => x.IsActive == true).ToList();
if (objList != null)
{
dataList = objList.Select(x => new ReasonMasterModal()
{
Reason = x.Reason,
ReasonMaster_Id = x.ReasonMaster_Id
}).ToList();
return(dataList);
}
return(dataList);
}
}
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);
}
public static List <DivisionList> getDivisionForBU(string BU)
{
using (var context = new SalesReturndbEntities())
{
var list = context.SP_Get_Division_For_BU(BU).ToList();
List <DivisionList> DivisionList = null;
if (list != null)
{
DivisionList = list.Select(x => new DivisionList()
{
DivisionName = x.Dept_name
}).ToList();
return(DivisionList);
}
return(DivisionList);
}
}
public static List <AdminMasterModal> getAdminList()
{
using (var context = new SalesReturndbEntities())
{
var dataList = context.TblAdminMasters.Where(x => x.IsActive == true).ToList();
List <AdminMasterModal> objList = null;
if (dataList != null)
{
objList = dataList.Select(x => new AdminMasterModal()
{
Admin_Id = x.Admin_Id,
EmployeeCode = x.EmployeeCode
}).ToList();
return(objList);
}
return(objList);
}
}
public static List <EmployeeCommanModal> GetSalesDirector(SearchModal Obj)
{
using (var context = new SalesReturndbEntities())
{
var list = context.SP_GetEmployeeForBU_Division_Country(Obj.BUName, Obj.DivisionName, Obj.CountryName).ToList();
List <EmployeeCommanModal> empList = null;
if (list != null)
{
empList = list.Select(x => new EmployeeCommanModal()
{
EmployeeCode = x.EMP_CODE,
EmployeeName = x.Emp_First_name,
}).ToList();
return(empList);
}
return(empList);
}
}
