Пример #1
0
 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
     {
     }
 }
Пример #2
0
        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
            {
            }
        }