private void btnSave_Click(object sender, EventArgs e)
        {
            var listNormDetails = grdData.Rows.Select(t => new ProductNormTemplateDetailModel()
            {
                ProductionMaterialId =Convert.ToInt32(t.Cells["MaterialId"].Value),
                BatchQuantity = Convert.ToDecimal(t.Cells["BatchQty"].Value),
                CartoonQuantity = Convert.ToDecimal(t.Cells["CartoonQty"].Value)
            }).ToList();

            var normtemplateModel = new ProductNormTemplateModel()
            {
                OutputQuantity = txtOutputQty.Value,
                WasteQuantity = txtWasteQty.Value,
                PreparedBy = 1,
                PreparedDate = DateTime.Now.Date
            };
            var proModel = new ProductModel()
            {
                BrandId = (int)cmbBrand.SelectedValue,
                ExerciseDuty = Convert.ToByte(chkExerciseDuty.Checked),
                IsVat = Convert.ToByte(chkVAT.Checked),
                FlavourId = (int)cmbFlavour.SelectedValue,
                ProductName = txtProductName.Text,
                SKUCode = txtProductName.Text,
                weight = float.Parse(txtWeight.Text),
                UnitOfMeasureId = (int)cmbUnit.SelectedValue,
                PacketPerCartoon = (int)txtPacketsPerCartoon.Value,
                PerCartoonRate = txtRatePerCartoon.Value,
                ProductNormTemplateModel = normtemplateModel,
                ProductNormTemplateDetailModels = listNormDetails,
                CreatedBy = 1,
                CreatedDate = DateTime.Now.Date,
            };
            _productService.SaveProductAndNormTempalte(proModel);
        }
        private ProductNormTemplateModel SaveNormTemplateSummary(ProductNormTemplateModel productNormTemplate)
        {
            try
            {

                var data = new ProductNormTemplate()
                {
                    ProductId = productNormTemplate.ProductId,
                    OutputQuantity = productNormTemplate.OutputQuantity,
                    WasteQuantity = productNormTemplate.WasteQuantity,
                    PreparedBy = productNormTemplate.PreparedBy,
                    PreparedDate = productNormTemplate.PreparedDate,
                    ModifiedBy = productNormTemplate.ModifiedBy,
                    ModifiedDate = productNormTemplate.ModifiedDate
                };
                _context.Entry(data).State = EntityState.Added;
                _context.SaveChanges();
                productNormTemplate.ProductNormTemplateId = data.ProductNormTemplateId;
                return productNormTemplate;

            }
            catch (Exception)
            {

                throw;
            }
        }
        private bool EditNormTemplateSummary(ProductNormTemplateModel productNormTemplate)
        {
            try
            {

                var data =
                    _context.ProductNormTemplates.FirstOrDefault(
                        a => a.ProductNormTemplateId == productNormTemplate.ProductNormTemplateId);
                if (data != null)
                {
                    data.ProductId = productNormTemplate.ProductId;
                    data.OutputQuantity = productNormTemplate.OutputQuantity;
                    data.WasteQuantity = productNormTemplate.WasteQuantity;
                    data.ModifiedBy = productNormTemplate.ModifiedBy;
                    data.ModifiedDate = productNormTemplate.ModifiedDate;
                };
                _context.Entry(data).State = EntityState.Added;
                _context.SaveChanges();
                return true;

            }
            catch (Exception)
            {

                throw;
            }
        }