public string SaveSowPlannedDetails(SowDetailModel sowDetailModel)
{
string result = string.Empty;
try
{
SowDetail sowDetail = _OperationalPortalEntities.SowDetails.FirstOrDefault(x => x.SowDetailID == sowDetailModel.SowDetailID);
if (sowDetail != null)
{
Mapper.Map(sowDetailModel, sowDetail);
result = "SowDetails Updated Successfully";
}
else
{
sowDetail = new SowDetail();
Mapper.Map(sowDetailModel, sowDetail);
_OperationalPortalEntities.SowDetails.Add(sowDetail);
result = "SowDetails Saved Successfully";
}
_OperationalPortalEntities.SaveChanges();
}
catch (Exception ex)
{
result = ex.Message.ToString();
}
return(result);
}
public string SaveCustomerDetails(CustomerModel customerModel)
{
string result = string.Empty;
try
{
Customer customer = _OperationalPortalEntities.Customers.FirstOrDefault(x => x.CustomerID == customerModel.CustomerID);
if (customer != null)
{
Mapper.Map(customerModel, customer);
result = "Customer Updated Successfully";
}
else
{
customer = new Customer();
Mapper.Map(customerModel, customer);
_OperationalPortalEntities.Customers.Add(customer);
result = "Customer Saved Successfully";
}
_OperationalPortalEntities.SaveChanges();
}
catch (Exception ex)
{
result = ex.Message.ToString();
}
return(result);
}
public string SaveEmployeesRolesDetails(EmployeeRolesModel employeeRolesModel)
{
string result = string.Empty;
try
{
EmployeeRole employeeRole = _OperationalPortalEntities.EmployeeRoles.FirstOrDefault(x => x.RoleID == employeeRolesModel.RoleID);
if (employeeRole != null)
{
Mapper.Map(employeeRolesModel, employeeRole);
result = "EmployeeRole Updated Successfully";
}
else
{
employeeRole = new EmployeeRole();
Mapper.Map(employeeRolesModel, employeeRole);
_OperationalPortalEntities.EmployeeRoles.Add(employeeRole);
result = "EmployeeRole Saved Successfully";
}
_OperationalPortalEntities.SaveChanges();
}
catch (Exception ex)
{
result = ex.Message.ToString();
}
return(result);
}
public string SaveMSADetails(MSAModel msaModel)
{
string result = string.Empty;
try
{
MSA msa = _OperationalPortalEntities.MSAs.FirstOrDefault(x => x.MSAID == msaModel.MSAID);
if (msa != null)
{
Mapper.Map(msaModel, msa);
result = "MSA Updated Successfully";
}
else
{
msa = new MSA();
Mapper.Map(msaModel, msa);
msa.Customer = null;
_OperationalPortalEntities.MSAs.Add(msa);
result = "MSA Saved Successfully";
}
_OperationalPortalEntities.SaveChanges();
}
catch (Exception ex)
{
result = ex.Message.ToString();
}
return(result);
}
public string SavePoHeadersDetails(PoHeaderModel poHeaderModel)
{
string result = string.Empty;
try
{
PoHeader poHeader = _OperationalPortalEntities.PoHeaders.FirstOrDefault(x => x.PoHeaderID == poHeaderModel.PoHeaderID);
if (poHeader != null)
{
Mapper.Map(poHeaderModel, poHeader);
result = "PoHeader Updated Successfully";
}
else
{
poHeader = new PoHeader();
poHeader.SowHeader = null;
Mapper.Map(poHeaderModel, poHeader);
_OperationalPortalEntities.PoHeaders.Add(poHeader);
result = "PoHeader Saved Successfully";
}
_OperationalPortalEntities.SaveChanges();
}
catch (Exception ex)
{
result = ex.Message.ToString();
}
return(result);
}
public string SaveLocationsDetails(LocationModel locationModel)
{
string result = string.Empty;
try
{
Location location = _OperationalPortalEntities.Locations.FirstOrDefault(x => x.LocationID == locationModel.LocationID);
if (location != null)
{
Mapper.Map(locationModel, location);
result = "Location Updated Successfully";
}
else
{
location = new Location();
Mapper.Map(locationModel, location);
_OperationalPortalEntities.Locations.Add(location);
result = "Location Saved Successfully";
}
_OperationalPortalEntities.SaveChanges();
}
catch (Exception ex)
{
result = ex.Message.ToString();
}
return(result);
}
public string SaveSowHeaderDetails(SowHeaderModel sowHeaderModel)
{
string result = string.Empty;
try
{
SowHeader sowHeader = _OperationalPortalEntities.SowHeaders.FirstOrDefault(x => x.SowHeaderID == sowHeaderModel.SowHeaderID);
if (sowHeader != null)
{
Mapper.Map(sowHeaderModel, sowHeader);
result = "SowHeader Updated Successfully";
}
else
{
sowHeader = new SowHeader();
Mapper.Map(sowHeaderModel, sowHeader);
sowHeader.Customer = null;
_OperationalPortalEntities.SowHeaders.Add(sowHeader);
// _OperationalPortalEntities.Entry(sowHeader.CustomerId).State = EntityState.Unchanged;
result = "SowHeader Saved Successfully";
}
_OperationalPortalEntities.SaveChanges();
}
catch (Exception ex)
{
result = ex.Message.ToString();
}
return(result);
}
public string SavePoDetails(PoDetailsModel poDetailsModel)
{
string result = string.Empty;
try
{
PoDetail poDetails = _OperationalPortalEntities.PoDetails.FirstOrDefault(x => x.PoDetailsID == poDetailsModel.PoDetailsID);
if (poDetails != null)
{
Mapper.Map(poDetailsModel, poDetails);
result = "PoDetails Updated Successfully";
}
else
{
poDetails = new PoDetail();
Mapper.Map(poDetailsModel, poDetails);
_OperationalPortalEntities.PoDetails.Add(poDetails);
result = "PoDetails Saved Successfully";
}
_OperationalPortalEntities.SaveChanges();
}
catch (Exception ex)
{
result = ex.Message.ToString();
}
return(result);
}