public int EditIssueMaterial(IssueMaterialModel model)
        {
            try
            {
                using (_context = new HSSNInventoryEntities())
                {
                    var editModel = _context.IssueMaterials.FirstOrDefault(a => a.IssueProductMaterilId == model.IssueProductMaterilId);
                    if (editModel != null)
                    {
                        editModel.IssueProductMaterilId = model.IssueProductMaterilId;
                        editModel.Issuedcode = model.Issuedcode;
                        editModel.Issuedby = model.Issuedby;
                        editModel.BillOfMaterialId = model.BillOfMaterialId;
                        editModel.IssueRemarks = model.IssueRemarks;

                    }
                    _context.Entry(editModel).State = EntityState.Modified;
                    _context.SaveChanges();
                    return editModel.IssueProductMaterilId;
                }
            }
            catch (Exception e)
            {

                Console.WriteLine(e);
                throw;
            }
        }
        private void btnSave_Click(object sender, EventArgs e)
        {
            var model = new IssueMaterialModel()
            {
                IssueProductMaterilId = issuematerialid,
                Issuedcode = Convert.ToInt32(txtIssuecode.Text),
                Issuedby = Convert.ToInt32(CmbIssuedBy.SelectedValue),
                BillOfMaterialId = Convert.ToInt32(cmbBOMCode.SelectedValue),
                IssueDateTime = Convert.ToDateTime(DateTime.Now.ToShortDateString()),
                IssueRemarks = txtIssueRemarks.Text,
            };
            var griddata = datafunc();
            if (model.IssueProductMaterilId == 0)
            {
                int Issueid = _issueMaterialservice.saveIssuematerial(model);
                _issueMaterialservice.saveIssueproductionDetail(griddata, Issueid);
            }
            else
            {
                int issueid = _issueMaterialservice.EditIssueMaterial(model);
                _issueMaterialservice.EditIssueproductionDetail(griddata, issueid);
            }

            _commonService.UpdateSerialNumberVoucherType("IC");
        }
        public int saveIssuematerial(IssueMaterialModel Model)
        {
            try
            {
                using (_context= new HSSNInventoryEntities())
                {
                    var data = new IssueMaterial()
                    {
                        Issuedcode = Model.Issuedcode,
                        Issuedby = Model.Issuedby,
                        BillOfMaterialId = Model.BillOfMaterialId,
                        IssueDateTime = Model.IssueDateTime,
                        ReturnBy = Model.ReturnBy,
                        ReturnDatetimer = Model.ReturnDatetimer,
                        IssueReceivedBy = Model.IssueReceivedBy,
                        ReturnReceivedBy = Model.ReturnReceivedBy,
                        IssueRemarks = Model.IssueRemarks,
                        ReturnRemarks = Model.ReturnRemarks,

                    };
                    _context.Entry(data).State=EntityState.Added;
                    _context.SaveChanges();
                    return data.IssueProductMaterilId;
                }
            }
            catch (Exception)
            {

                throw;
            }
        }