public async Task <utblMstPackageType> GetPackageTypeByIDAsync(long id)
{
utblMstPackageType obj = new utblMstPackageType();
obj = await objDB.utblMstPackageTypes.Where(x => x.PackageTypeID == id).FirstOrDefaultAsync();
return(obj);
}
public ActionResult Create(utblMstPackageType package)
{
if (ModelState.IsValid)
{
TempData["ErrMsg"] = db.Save(package);
return(Json(new { success = true }));
}
return(PartialView("pvCreate", package));
}
public ActionResult Edit(utblMstPackageType package)
{
if (ModelState.IsValid)
{
TempData["ErrMsg"] = db.Save(package);
// string url = Url.Action("list", "country");
return(Json(new { success = true }));
}
return(PartialView("pvEdit", package));
}
public async Task <string> SavePackage(utblMstPackageType model)
{
if (ModelState.IsValid)
{
return(await objDal.SavePackageTypeAsync(model));
}
string messages = string.Join("; ", ModelState.Values
.SelectMany(x => x.Errors)
.Select(x => x.ErrorMessage));
return("Operation Error: " + messages);
}
public async Task <string> SavePackageTypeAsync(utblMstPackageType model)
{
try
{
var parPID = new SqlParameter("@PackageTypeID", model.PackageTypeID);
var parPName = new SqlParameter("@PackageTypeName", model.PackageTypeName ?? "");
var parIsVis = new SqlParameter("@IsVisible", model.IsVisible);
return(await objDB.Database.SqlQuery <string>("udspMstPackageTypeAddEdit @PackageTypeID, @PackageTypeName,@IsVisible",
parPID, parPName, parIsVis).FirstOrDefaultAsync());
}
catch (Exception ex)
{
return("Error: " + ex.Message);
}
}
public int Delete(long id)
{
int result = 0;
utblMstPackageType obj = _db.utblMstPackageTypes.Find(id);
try
{
_db.utblMstPackageTypes.Remove(obj);
_db.SaveChanges();
result = 1;
return(result);
}
catch (Exception ex)
{
return(result);
}
}
public utblMstPackageType GetPackageByID(long id)
{
utblMstPackageType obj = _db.utblMstPackageTypes.FirstOrDefault(p => p.PackageTypeID == id);
return(obj);
}
