public bool InsertProductData(ProductDetails objPD)
        {
            bool res = false;

            try
            {
                var sql = "[dbo].[InsertProductData]";
                DynamicParameters param = new DynamicParameters();
                param.Add("ProductName", objPD.ProductName);
                param.Add("ProductType", objPD.ProductType);
                param.Add("Unit", objPD.Unit);
                param.Add("ProductRate", objPD.ProductRate);
                param.Add("Descrption", objPD.Descrption);
                param.Add("CreatedDate", objPD.CreatedDate);
                
                cn.Open();
                res = Convert.ToBoolean(cn.Execute(sql, param, commandType: CommandType.StoredProcedure));
                cn.Close();


            }
            catch (Exception ex)
            {
            }
            finally
            {

            }
            return res;
        }
 public ActionResult ProductInsert(ProductDetails objPD)
 {
     bool res = false;
     objPD.ProductType = objPD.ProductType != null && objPD.ProductType == "Select" ? "" : objPD.ProductType;
     res = productdao.InsertProductData(objPD);
     return RedirectToAction("ProductInsert");
 }