Example #1
0
        public bool InsertShopData(ShopData objSD)
        {
            int res = 0;
            try
            {
               
                //            var sql = @"INSERT INTO [dbo].[Shop_Details] (ShopNo,ShopName,Address1,Address2,City,District,Taluk,State,Country,PostalCode,SavedData,IsDeleted)
                //                     VALUES(@ShopNo,@ShopName,@Address1,@Address2,@City,@District,@Taluk,@State,@Country,@PostalCode,Getdate(),@IsDeleted)";
                var sql = "[dbo].[InsertShopData]";
                DynamicParameters param = new DynamicParameters();

                param.Add("ShopName", objSD.ShopName);
                param.Add("Address1", objSD.Address1);
                param.Add("Address2", objSD.Address2);
                param.Add("City", objSD.City);
                param.Add("District", objSD.District);
                param.Add("Taluk", objSD.Taluk);
                param.Add("State", objSD.State);
                param.Add("Country", objSD.Country);
                param.Add("PostalCode", objSD.PostalCode);

                cn.Open();
                res = cn.Execute(sql, param, commandType: CommandType.StoredProcedure);
                cn.Close();

              
            }
            catch (Exception ex)
            {

            }
            finally
            {
                cn.Close();
            }

            return Convert.ToBoolean(res);
        }
 public ActionResult ShopDataNew(ShopData objSD)
 {
     bool res = false;
     //res = shopdatadao.InsertShopData(objSD);
     return RedirectToAction("ShopDataNew", "Shop");
 }