public string InsertMaterialEAN(tbl_MaterialEAN MaterialEAN) { try { Context.MaterialEAN.Insert(MaterialEAN); Context.MaterialEAN.Save(); return(MaterialEAN.EAN13 + " Inserted Successfully!!"); } catch (Exception ex) { return("Error in saving details, Please try again!!"); } finally { } }
public string InsertUpdateMaterialEAN(MaterialModel MaterialModel) { try { List <tbl_MaterialEAN> LMaterialEAN = new List <tbl_MaterialEAN>(); string result = string.Empty; bool IsExsit = false; LMaterialEAN = this.GetByIdMaterialEAN(MaterialModel.EAN13); tbl_MaterialEAN MaterialEAN = new tbl_MaterialEAN(); MaterialEAN.MaterialID = MaterialModel.EMaterialID; MaterialEAN.UOM = MaterialModel.UOM; MaterialEAN.MaterialMix = MaterialModel.MaterialMix; MaterialEAN.EAN13 = MaterialModel.EAN13; MaterialEAN.ConvertValue = MaterialModel.ConvertValue; MaterialEAN.BaseUOM = MaterialModel.EBaseUOM; if (LMaterialEAN != null && LMaterialEAN.Count != 0) { IsExsit = true; } else { LMaterialEAN = new List <tbl_MaterialEAN>(); } if (!IsExsit) { this.InsertMaterialEAN(MaterialEAN); result = MaterialModel.EAN13 + "Inserted SuccessFully"; } else { Context.MaterialEAN.Update(MaterialEAN); Context.MaterialEAN.Save(); result = MaterialModel.EAN13 + "Updated SuccessFully"; } return(result); } catch (Exception ex) { return(null); } finally { } }