public ActionResult EditRequest(EditRepairStatus Emodel)
{
if (!ModelState.IsValid)
{
return(RedirectToAction("PCRC"));
}
using (var con = new SqlConnection(_connectionString))
{
var result = con.Query <int>("Insert_CustomerSupportAction",
new
{
CC_NO = Emodel.CcNo,
Emodel.CallStatus,
Emodel.CallBackDatetime,
Emodel.Customer_Name,
Emodel.Mobile_No,
Emodel.Email_Id,
Emodel.Cust_Add,
Emodel.Cust_City,
Emodel.Cust_State,
Emodel.Remarks,
}, commandType: CommandType.StoredProcedure).FirstOrDefault();
if (result == 2)
{
TempData["Message"] = "Submitted Successfully";
}
else
{
TempData["Message"] = "Something Went Wrong";
}
return(RedirectToAction("PCRC"));
}
}
public ActionResult EditRepairStatus1(EditRepairStatus Emodel)
{
var value = "";
var finalValue = "";
var problem = Emodel.PrblmObsrvd.Length;
for (var i = 0; i <= problem - 1; i++)
{
var Data = Emodel.PrblmObsrvd[i].FirstOrDefault();
value = Data + ",";
finalValue = finalValue + value;
}
try
{
using (var con = new SqlConnection(_connectionString))
{
var result = con.Query <int>("UpdateRepairRequest",
new
{
CC_NO = Emodel.CcNo,
Emodel.Serial_No,
Emodel.IMEI1,
Emodel.IMEI2,
Emodel.SE_Action,
Emodel.VisitDatetime,
Emodel.Engg_Name,
Emodel.Pickupdatetime,
Emodel.CourierName,
Emodel.PhysicalDamage,
Emodel.WarrantyVoid,
PrblmObsrvd = finalValue,
Emodel.SpareType,
Emodel.SpareName,
Emodel.Quantity,
Emodel.ServiceCharge,
Emodel.SpareCost,
Emodel.EstimatedCost,
Emodel.IsApproved,
Emodel.RepairStatus,
Emodel.CllectableAmt,
Emodel.PaymentMode,
Emodel.CashRecvd,
Emodel.BalanceAmt,
Emodel.TransAmt,
Emodel.TransDateTime,
Emodel.TransNumber,
Emodel.RevisitDatetime,
Emodel.CreatedBy,
Emodel.MsgToCust,
Emodel.SERemarks
}, commandType: CommandType.StoredProcedure).FirstOrDefault();
if (result == 1)
{
TempData["Message"] = "Successfully Added";
}
else
{
TempData["Message"] = "Something Went Wrong";
}
}
return(View("RepairStatus"));
}
catch (Exception e)
{
throw;
}
}
