public ActionResult Create()
{
CourierPinZipCode courierPinZipCode = new CourierPinZipCode
{
CourierList = new SelectList(dropdown.BindCourier(CurrentUser.CompanyId), "Value", "Text"),
CountryList = new SelectList(dropdown.BindCountry(), "Value", "Text"),
StateList = new SelectList(Enumerable.Empty<SelectListItem>()),
CityList = new SelectList(Enumerable.Empty<SelectListItem>())
};
return View(courierPinZipCode);
}
public ActionResult Edit(CourierPinZipCode model)
{
int PinZipId = Convert.ToInt32(TempData["PinZipId"]);
model.Pin_ZIP_ID = PinZipId;
using (var con = new SqlConnection(_connectionString))
{
var result = con.Query<int>("Add_Edit_Delete_CourierPinZipCode",
new
{
model.Pin_ZIP_ID,
CountryID = model.Country,
CourierID = model.Courier,
Pin_CountryID = model.PIN_Country1,
Pin_State = model.PIN_State1,
Pin_City = model.PIN_City1,
model.Pin_Region,
model.Pin_Zone,
model.Pin_Code,
model.ShortCode,
model.Pin_TAT,
model.Pin_Cod,
model.ISExpress,
model.ReverseLogistics,
model.OrderPreference,
model.IsActive,
model.Comments,
User = CurrentUser.UserId,
Action = "U"
}, commandType: CommandType.StoredProcedure).FirstOrDefault();
var response = new ResponseModel();
if (result == 2)
{
response.IsSuccess = true;
response.Response = "Updated Successfully";
TempData["response"] = response;
}
else
{
response.IsSuccess = true;
response.Response = "Something went wrong";
TempData["response"] = response;
}
return RedirectToAction("PinZIPCode");
}
}
public ActionResult Create(CourierPinZipCode model)
{
using (var con = new SqlConnection(_connectionString))
{
var result = con.Query<int>("Add_Edit_Delete_CourierPinZipCode",
new
{
model.Pin_ZIP_ID,
CountryID = model.Country,
CourierID = model.Courier,
Pin_CountryID = model.PIN_Country1,
Pin_State = model.PIN_State1,
Pin_City = model.PIN_City1,
model.Pin_Region,
model.Pin_Zone,
model.Pin_Code,
model.ShortCode,
model.Pin_TAT,
model.Pin_Cod,
model.ISExpress,
model.ReverseLogistics,
model.OrderPreference,
model.IsActive,
model.Comments,
User = CurrentUser.UserId,
Action = "I"
}, commandType: CommandType.StoredProcedure).FirstOrDefault();
var response = new ResponseModel();
if (result == 1)
{
response.IsSuccess = true;
response.Response = " Successfully Added ";
TempData["response"] = response;
}
else
{
response.IsSuccess = true;
response.Response = " Pin Region Already Exist ";
TempData["response"] = response;
}
return RedirectToAction("PinZIPCode");
}
}
