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);
}
