public async Task <ActionResult> UREVASform(string CourierId)
{
using (var con = new SqlConnection(_connectionString))
{
var result = new ReverseAWBStatusModel();
result = con.Query <ReverseAWBStatusModel>("Select CourierName from Courier_Master where CourierId=@CourierId ", new { @CourierId = CourierId }, commandType: CommandType.Text).FirstOrDefault();
var result1 = con.Query <UREVASTable>("UREVAS_Page_Single_Table", null, commandType: CommandType.StoredProcedure).ToList();
result.AksTable = result1;
result.ReverseAWBStatusList = new SelectList(await CommonModel.GetReverseAWBStatus(), "Value", "Text");
return(View(result));
}
}
public ActionResult FinalUpdateReverseAWB(ReverseAWBStatusModel m)
{
using (var con = new SqlConnection(_connectionString))
{
var result = con.Query <int>("Insert_into_Reverse_AWB_Allocation_From_UREVAS",
new { UREVAS_ReverseAWBStatus = m.ReverseAWBStatus, UREVAS_Status = m.Status, UREVAS_Remarks = m.Remarks, CC_NO = m.CC_NO }
, commandType: CommandType.StoredProcedure).FirstOrDefault();
if (result == 1)
{
return(RedirectToAction("UpdateReverseAWB", "Logistics"));
}
return(View());
}
}
public ActionResult UREVASform(ReverseAWBStatusModel m)
{
using (var con = new SqlConnection(_connectionString))
{
var result = con.Query <int>("SubmitDataByUREVAS", new { m.CC_NO, m.ReverseAWBStatus }, commandType: CommandType.StoredProcedure).FirstOrDefault();
if (result == 1)
{
TempData["Message"] = "Updated Successfully";
}
else
{
TempData["Message"] = "Something Went Wrong";
}
}
return(RedirectToAction("UpdateReverseAWB", "Logistics"));
}
