public ActionResult Edit(TicketRate obj)
{
if (ModelState.IsValid)
{
try
{
var result = iTicketRate.Update(obj, "u");
return(Json(new
{
ErrorCode = result.ErrorCode,
Message = result.Msg,
Id = result.Id,
JsonRequestBehavior.AllowGet
}));
}
catch (Exception ex)
{
return(Json(new { ErrorCode = 1, Message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
Response.TrySkipIisCustomErrors = true;
string messages = string.Join("; ", ModelState.Values
.SelectMany(x => x.Errors)
.Select(x => x.ErrorMessage));
return(Json(new { ErrorCode = 1, Message = messages }, JsonRequestBehavior.AllowGet));
}
public TicketRate GetById(string Id)
{
SqlParameter[] param = { new SqlParameter("@flag", SqlDbType.VarChar, 50)
{
Value = "s"
}
, new SqlParameter("@id", SqlDbType.NVarChar, 128)
{
Value = Id
} };
DataRow result = SqlHelper.ExecuteDataRow("spTicketRate", param);
TicketRate obj = new TicketRate();
obj.Id = Convert.ToInt32(result["Id"]);
obj.Name = Convert.ToString(result["Name"]);
obj.Code = Convert.ToInt32(result["Code"]);
obj.CategoryId = Convert.ToInt32(result["category_id"]);
obj.TypeId = Convert.ToInt32(result["type_id"]);
obj.PackageId = Convert.ToInt32(result["package_id"]);
obj.Currency = Convert.ToString(result["Currency"]);
obj.BaseRate = Convert.ToInt32(result["base_rate"]);
obj.LocalTax = Convert.ToInt32(result["local_tax"]);
obj.VAT = Convert.ToInt32(result["VAT"]);
obj.Total = Convert.ToInt32(result["Total"]);
obj.RoundOff = Convert.ToInt32(result["round_of"]);
obj.GrandTotal = Convert.ToInt32(result["grand_total"]);
obj.IsActive = Convert.ToBoolean(result["IsActive"]);
return(obj);
}
public ActionResult Edit(string id)
{
ViewBag.Type = new SelectList(iDropDown.GetDropDowns("types"), "Id", "DisplayName"); //iDropDown.GetDropDowns("types", "");
ViewBag.Package = new SelectList(iDropDown.GetDropDowns("packages"), "Id", "DisplayName"); //iDropDown.GetDropDowns("packages", "");
ViewBag.Category = new SelectList(iDropDown.GetDropDowns("categories"), "Id", "DisplayName"); //iDropDown.GetDropDowns("categories", "");
TicketRate obj = iTicketRate.GetById(id);
return(PartialView(obj));
}
public DbResult Update(TicketRate entity, string flag)
{
return(repo.Update(entity, flag));
}
public DbResult Update(TicketRate obj, string flag)
{
SqlParameter[] param = { new SqlParameter("@flag", SqlDbType.VarChar, 50)
{
Value = flag == "i"? "i":"u"
}
, new SqlParameter("@Id", SqlDbType.Int)
{
Value = obj.Id
}
, new SqlParameter("@Name", SqlDbType.VarChar, 100)
{
Value = obj.Name
}
, new SqlParameter("@Code", SqlDbType.Int)
{
Value = obj.Code
}
, new SqlParameter("@Category_id", SqlDbType.Int)
{
Value = obj.CategoryId
}
, new SqlParameter("@Type_id", SqlDbType.Int)
{
Value = obj.TypeId
}
, new SqlParameter("@Package_id", SqlDbType.Int)
{
Value = obj.PackageId
}
, new SqlParameter("@Currency", SqlDbType.VarChar, 50)
{
Value = obj.Currency
}
, new SqlParameter("@BaseRate", SqlDbType.Money)
{
Value = obj.BaseRate
}
, new SqlParameter("@LocalTax", SqlDbType.Money)
{
Value = obj.LocalTax
}
, new SqlParameter("@VAT", SqlDbType.Money)
{
Value = obj.VAT
}
, new SqlParameter("@Total", SqlDbType.Money)
{
Value = obj.Total
}
, new SqlParameter("@RoundOff", SqlDbType.Money)
{
Value = obj.RoundOff
}
, new SqlParameter("@GrandTotal", SqlDbType.Money)
{
Value = obj.GrandTotal
}
, new SqlParameter("@user", SqlDbType.NVarChar, 128)
{
Value = SessionHelper.GetUserID()
}
, new SqlParameter("@IsActive", SqlDbType.NVarChar, 128)
{
Value = obj.IsActive
} };
return(SqlHelper.ParseDbResult("spTicketRate", param));
}
