public bool Delete([FromBody] TblEmployeeMaster employee)
{
try
{
this._repoWrapper.Employee.Delete(employee);
this._repoWrapper.Employee.Save();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool Add([FromBody] TblEmployeeMaster employee)
{
try
{
this._repoWrapper.Employee.Create(employee);
this._repoWrapper.Employee.Save();
this._repoWrapper.Employee.SaveLoginDetails(employee);
this._repoWrapper.Employee.Save();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public static string UpdateEmployeeList(List <EmployeeMasterModel> list)
{
using (var context = new SalesReturndbEntities())
{
using (TransactionScope transaction = new TransactionScope())
{
List <EmployeeMasterModel> lst = new List <EmployeeMasterModel>();
foreach (var obj in list)
{
var duplicateCheck = context.TblEmployeeMasters.Where(x => x.IsActive == true && x.Id == obj.Id).FirstOrDefault();
if (duplicateCheck != null)
{
var check = lst.Where(x => x.IsActive == true && x.DepotName == obj.DepotName).FirstOrDefault();
if (check == null)
{
//update
duplicateCheck.DepotName = obj.DepotName;
duplicateCheck.CommercialCode = obj.CommercialCode;
duplicateCheck.CommercialHead = obj.CommercialHead;
duplicateCheck.ComplaintHandler = obj.ComplaintHandler;
duplicateCheck.ComplaintManager = obj.ComplaintManager;
duplicateCheck.CSO = obj.CSO;
duplicateCheck.Depotcode = obj.Depotcode;
duplicateCheck.ISC = obj.ISC;
duplicateCheck.LogisticsHead = obj.LogisticsHead;
duplicateCheck.ModifiedBy = obj.CreatedBy;
duplicateCheck.ModifiedDate = DateTime.Now;
context.Entry(duplicateCheck).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
lst.Add(obj);
}
else
{
return("Duplicate value not allowed");
}
}
else
{
var duplicateCheck1 = context.TblEmployeeMasters.Where(x => x.IsActive == true && x.DepotName == obj.DepotName).FirstOrDefault();
if (duplicateCheck1 == null)
{
//new entry
TblEmployeeMaster ReasonMaster = new TblEmployeeMaster()
{
DepotName = obj.DepotName,
CommercialCode = obj.CommercialCode,
CommercialHead = obj.CommercialHead,
ComplaintHandler = obj.ComplaintHandler,
ComplaintManager = obj.ComplaintManager,
CSO = obj.CSO,
Depotcode = obj.Depotcode,
ISC = obj.ISC,
LogisticsHead = obj.LogisticsHead,
IsActive = true,
CreatedBy = obj.CreatedBy,
CreatedDate = DateTime.Now,
};
context.Entry(ReasonMaster).State = System.Data.Entity.EntityState.Added;
context.SaveChanges();
lst.Add(obj);
}
else
{
return("Duplicate value not allowed");
}
}
}
transaction.Complete();
transaction.Dispose();
}
return("Success : succssfully saved");
}
}
public IEnumerable <ViewStockDetails> GetDatewiseExpencesDetails([FromBody] TblEmployeeMaster master)
{
var Product = this._repoWrapper.Product.GetDatewiseExpencesDetails(master);
return(Product);
}
