public HttpResponseMessage UpdatePlantStorageDetails(TEPOPlantStorageDetail plntstoragedtl)
{
try
{
TEPOPlantStorageDetail plntObj = db.TEPOPlantStorageDetails.Where(a => a.PlantStorageDetailsID == plntstoragedtl.PlantStorageDetailsID && a.isdeleted == false).FirstOrDefault();
if (plntObj != null)
{
TEProject proj = db.TEProjects.Where(a => a.ProjectID == plntstoragedtl.ProjectID && a.IsDeleted == false).FirstOrDefault();
plntObj.LastModifiedOn = DateTime.Now;
plntObj.isdeleted = false;
if (proj != null)
{
plntObj.ProjectName = proj.ProjectName;
plntObj.ProjectCode = proj.ProjectCode;
}
TEGSTNStateMaster state = db.TEGSTNStateMasters.Where(a => a.StateID == plntstoragedtl.StateID && a.IsDeleted == false).FirstOrDefault();
if (state != null)
{
plntObj.StateCode = state.StateCode;
plntObj.StateCodeDescription = state.StateName;
}
plntObj.Address = plntstoragedtl.Address;
plntObj.CompanyCode = plntstoragedtl.CompanyCode;
plntObj.CountryCode = plntstoragedtl.CountryCode;
plntObj.GSTIN = plntstoragedtl.GSTIN;
plntObj.PlantStorageCode = plntstoragedtl.PlantStorageCode;
plntObj.Type = plntstoragedtl.Type;
plntObj.StateID = plntstoragedtl.StateID;
plntObj.ProjectID = plntstoragedtl.ProjectID;
db.Entry(plntObj).CurrentValues.SetValues(plntObj);
db.SaveChanges();
sinfo.errorcode = 0;
sinfo.errormessage = "Successfully Updated";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
else
{
sinfo.errorcode = 0;
sinfo.errormessage = "Unable to Update";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
}
catch (Exception ex)
{
ExceptionObj.RecordUnHandledException(ex);
sinfo.errorcode = 1;
sinfo.errormessage = "Fail To Update";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
}
public HttpResponseMessage UpdatePOHSNRate(TEPOHSNTaxCodeMapping HSNTaxCode)
{
TEPOHSNTaxCodeMapping HSNObj = context.TEPOHSNTaxCodeMappings.Where(a => a.UniqueID == HSNTaxCode.UniqueID && a.IsDeleted == false).FirstOrDefault();
if (HSNObj != null)
{
int VendReg = Convert.ToInt32(HSNTaxCode.VendorRegionCode);
int DeliReg = Convert.ToInt32(HSNTaxCode.DeliveryPlantRegionCode);
HSNObj.LastModifiedOn = DateTime.Now;
HSNObj.IsDeleted = false;
TEGSTNStateMaster Venstate = context.TEGSTNStateMasters.Where(a => a.StateCode == HSNTaxCode.VendorRegionCode && a.IsDeleted == false).FirstOrDefault();
if (Venstate != null)
{
HSNObj.VendorRegionCode = Venstate.StateCode;
HSNObj.VendorRegionDescription = Venstate.StateName;
}
TEGSTNStateMaster Delstate = context.TEGSTNStateMasters.Where(a => a.StateCode == HSNTaxCode.DeliveryPlantRegionCode && a.IsDeleted == false).FirstOrDefault();
if (Delstate != null)
{
HSNObj.DeliveryPlantRegionCode = Delstate.StateCode;
HSNObj.DeliveryPlantRegionDescription = Delstate.StateName;
}
HSNObj.ApplicableTo = HSNTaxCode.ApplicableTo;
HSNObj.DestinationCountry = HSNTaxCode.DestinationCountry;
//HSNObj.GSTVendorClassification = HSNTaxCode.GSTVendorClassification;
// HSNObj.HSNCode = HSNTaxCode.HSNCode;
HSNObj.MaterialGSTApplicability = HSNTaxCode.MaterialGSTApplicability;
HSNObj.VendorGSTApplicability = HSNTaxCode.VendorGSTApplicability;
HSNObj.ValidFrom = HSNTaxCode.ValidFrom;
HSNObj.ValidTo = HSNTaxCode.ValidTo;
HSNObj.TaxType = HSNTaxCode.TaxType;
HSNObj.TaxCode = HSNTaxCode.TaxCode;
HSNObj.TaxRate = HSNTaxCode.TaxRate;
HSNObj.LastModifiedBy = HSNTaxCode.LastModifiedBy;
context.Entry(HSNObj).CurrentValues.SetValues(HSNObj);
context.SaveChanges();
sinfo.errorcode = 0;
sinfo.errormessage = "Successfully Updated";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
else
{
sinfo.errorcode = 0;
sinfo.errormessage = "Unable to Update";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
}
public HttpResponseMessage SavePOHSNRate(TEPOHSNTaxCodeMapping HSNTaxCode)
{
if (this.Check_Redund(HSNTaxCode))
{
int VendReg = Convert.ToInt32(HSNTaxCode.VendorRegionCode);
int DeliReg = Convert.ToInt32(HSNTaxCode.DeliveryPlantRegionCode);
HSNTaxCode.LastModifiedOn = DateTime.Now;
HSNTaxCode.IsDeleted = false;
TEGSTNStateMaster Venstate = context.TEGSTNStateMasters.Where(a => a.StateCode == HSNTaxCode.VendorRegionCode && a.IsDeleted == false).FirstOrDefault();
if (Venstate != null)
{
HSNTaxCode.VendorRegionCode = Venstate.StateCode;
HSNTaxCode.VendorRegionDescription = Venstate.StateName;
}
TEGSTNStateMaster Delstate = context.TEGSTNStateMasters.Where(a => a.StateCode == HSNTaxCode.DeliveryPlantRegionCode && a.IsDeleted == false).FirstOrDefault();
if (Delstate != null)
{
HSNTaxCode.DeliveryPlantRegionCode = Delstate.StateCode;
HSNTaxCode.DeliveryPlantRegionDescription = Delstate.StateName;
}
context.TEPOHSNTaxCodeMappings.Add(HSNTaxCode);
context.SaveChanges();
sinfo.errorcode = 0;
sinfo.errormessage = "Successfully Saved";
}
else
{
sinfo.errorcode = 1;
sinfo.errormessage = "Combination already present in the Database";
}
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
public HttpResponseMessage SavePlantStorageDetails(TEPOPlantStorageDetail plntstoragedtl)
{
try
{
TEProject proj = db.TEProjects.Where(a => a.ProjectID == plntstoragedtl.ProjectID && a.IsDeleted == false).FirstOrDefault();
plntstoragedtl.LastModifiedOn = DateTime.Now;
plntstoragedtl.isdeleted = false;
if (proj != null)
{
plntstoragedtl.ProjectName = proj.ProjectName;
plntstoragedtl.ProjectCode = proj.ProjectCode;
}
TEGSTNStateMaster state = db.TEGSTNStateMasters.Where(a => a.StateID == plntstoragedtl.StateID && a.IsDeleted == false).FirstOrDefault();
if (state != null)
{
plntstoragedtl.StateCode = state.StateCode;
plntstoragedtl.StateCodeDescription = state.StateName;
}
db.TEPOPlantStorageDetails.Add(plntstoragedtl);
db.SaveChanges();
sinfo.errorcode = 0;
sinfo.errormessage = "Successfully Saved";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
catch (Exception ex)
{
ExceptionObj.RecordUnHandledException(ex);
sinfo.errorcode = 1;
sinfo.errormessage = "Fail To Save";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
}
