public void CopyProcess(ProductWeightModel productweight) { try { string varCopy = (productweight.WeightOption == "C") ? "F" : "C"; int cnt = (from o in DB.DDSHAPE_DETAILS where o.CI_REFERENCE == productweight.CIreference && o.WEIGHT_OPTION == productweight.WeightOption select o).Count(); if (cnt == 0) { List <DDSHAPE_DETAILS> sdetails = (from o in DB.DDSHAPE_DETAILS where o.CI_REFERENCE == productweight.CIreference && o.WEIGHT_OPTION == varCopy select o).ToList <DDSHAPE_DETAILS>(); if (sdetails != null) { foreach (DDSHAPE_DETAILS sdetail in sdetails) { DDSHAPE_DETAILS shapedetail = new DDSHAPE_DETAILS(); shapedetail.CI_REFERENCE = productweight.CIreference; shapedetail.WEIGHT_OPTION = productweight.WeightOption; shapedetail.SHAPE_CODE = sdetail.SHAPE_CODE; shapedetail.SNO = GenerateSNO(productweight); shapedetail.HEAD1 = sdetail.HEAD1; shapedetail.HEAD2 = sdetail.HEAD2; shapedetail.HEAD3 = sdetail.HEAD3; shapedetail.VAL1 = sdetail.VAL1; shapedetail.VAL2 = sdetail.VAL2; shapedetail.VAL3 = sdetail.VAL3; shapedetail.VOLUME = sdetail.VOLUME; shapedetail.SIGN = sdetail.SIGN; shapedetail.ROWID = Guid.NewGuid(); DB.DDSHAPE_DETAILS.InsertOnSubmit(shapedetail); DB.SubmitChanges(); } } sdetails = null; } } catch (System.Data.Linq.ChangeConflictException) { DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.KeepChanges); } catch (Exception ex) { throw ex.LogException(); } }
public bool InsertDDShape_Details(string varOldCIref, string varNewCIRef) { List <DDSHAPE_DETAILS> lstddshape_details = new List <DDSHAPE_DETAILS>(); List <DDSHAPE_DETAILS> lstoldddshape_details = new List <DDSHAPE_DETAILS>(); DDSHAPE_DETAILS ddshape_detailsnew = new DDSHAPE_DETAILS(); DDSHAPE_DETAILS ddshape_detailsold = new DDSHAPE_DETAILS(); try { lstoldddshape_details = (from row in DB.DDSHAPE_DETAILS where row.CI_REFERENCE.Trim() == varOldCIref.Trim() select row).ToList <DDSHAPE_DETAILS>(); ddshape_detailsnew.ROWID = Guid.NewGuid(); if (lstoldddshape_details.Count > 0) { ddshape_detailsnew = new DDSHAPE_DETAILS(); ddshape_detailsold = lstddshape_details[0]; ddshape_detailsnew = ddshape_detailsold.DeepCopy(); ddshape_detailsnew.IDPK = 0; ddshape_detailsnew.CI_REFERENCE = varNewCIRef; DB.DDSHAPE_DETAILS.InsertOnSubmit(ddshape_detailsnew); DB.SubmitChanges(); } return(true); } catch (System.Data.Linq.ChangeConflictException) { DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.KeepChanges); } catch (Exception ex) { throw ex.LogException(); } return(true); }
public bool UpdateProductWeight(ProductWeightModel productwt) { bool _status = false; productwt.Status = ""; try { foreach (DataRowView dr in productwt.DVShapeDetails) { if (dr["SHAPE_CODE"].ToString() != "") { try { if (dr["ROWID"].ToString() != "") { DDSHAPE_DETAILS sdetails = (from o in DB.DDSHAPE_DETAILS where o.ROWID.ToString() == dr["ROWID"].ToString() select o).FirstOrDefault <DDSHAPE_DETAILS>(); if (sdetails != null) { sdetails.CI_REFERENCE = productwt.CIreference; //sdetails.CIREF_NO_FK = productwt.CIREF_NO_FK; sdetails.WEIGHT_OPTION = productwt.WeightOption; sdetails.SHAPE_CODE = dr["SHAPE_CODE"].ToString(); sdetails.SNO = dr["SNO"].ToString().ToDecimalValue(); sdetails.HEAD1 = dr["HEAD1"].ToString(); sdetails.HEAD2 = dr["HEAD2"].ToString(); sdetails.HEAD3 = dr["HEAD3"].ToString(); sdetails.VAL1 = dr["VAL1"].ToString().ToDecimalValue(); sdetails.VAL2 = dr["VAL2"].ToString().ToDecimalValue(); sdetails.VAL3 = dr["VAL3"].ToString().ToDecimalValue(); sdetails.VOLUME = dr["VOLUME"].ToString().ToDecimalValue(); sdetails.SIGN = dr["SIGN"].ToString(); DB.SubmitChanges(); sdetails = null; productwt.Status = "Record Updated successfully."; } } else { DDSHAPE_DETAILS sdetails = new DDSHAPE_DETAILS(); sdetails.CI_REFERENCE = productwt.CIreference; //if (productwt.CIREF_NO_FK > 0) // sdetails.CIREF_NO_FK = productwt.CIREF_NO_FK; sdetails.WEIGHT_OPTION = productwt.WeightOption; sdetails.SHAPE_CODE = dr["SHAPE_CODE"].ToString(); sdetails.SNO = GenerateSNO(productwt); sdetails.HEAD1 = dr["HEAD1"].ToString(); sdetails.HEAD2 = dr["HEAD2"].ToString(); sdetails.HEAD3 = dr["HEAD3"].ToString(); sdetails.VAL1 = dr["VAL1"].ToString().ToDecimalValue(); sdetails.VAL2 = dr["VAL2"].ToString().ToDecimalValue(); sdetails.VAL3 = dr["VAL3"].ToString().ToDecimalValue(); sdetails.VOLUME = dr["VOLUME"].ToString().ToDecimalValue(); sdetails.SIGN = dr["SIGN"].ToString(); sdetails.ROWID = Guid.NewGuid(); DB.DDSHAPE_DETAILS.InsertOnSubmit(sdetails); DB.SubmitChanges(); sdetails = null; productwt.Status = "Record Updated successfully."; } } catch (System.Data.Linq.ChangeConflictException) { DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.KeepChanges); productwt.Status = "Record Added successfully."; } catch (Exception ex) { throw ex.LogException(); } } } foreach (DataRow dr in productwt.DTDeletedRecords.Rows) { try { if (dr["ROWID"].ToString().Trim() != "") { DDSHAPE_DETAILS sdetails = (from o in DB.DDSHAPE_DETAILS where o.ROWID.ToString() == dr["ROWID"].ToString() select o).FirstOrDefault <DDSHAPE_DETAILS>(); if (sdetails != null) { DB.DDSHAPE_DETAILS.DeleteOnSubmit(sdetails); DB.SubmitChanges(); } sdetails = null; _status = true; } } catch (System.Data.Linq.ChangeConflictException) { DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.KeepChanges); _status = true; } catch (Exception ex) { _status = false; throw ex.LogException(); } } _status = true; } catch (System.Data.Linq.ChangeConflictException) { DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.KeepChanges); } catch (Exception ex) { DB.Transaction.Rollback(); throw ex.LogException(); } return(_status); }