public MainCatogory GetMainAssest(int?MCId)
{
PetaPoco.Database db = null;
var dbConn = DataContext.Database.Connection;
MainCatogory assest = new MainCatogory();
try
{
using (DataContext)
{
dbConn.Open();
db = new PetaPoco.Database(dbConn);
db.EnableAutoSelect = false;
assest = db.Query <MainCatogory>("exec usp_GetMainAssest " + "@MCId",
new { MCId = MCId }).FirstOrDefault();
dbConn.Close();
}
}
catch (Exception ex)
{
throw;
}
finally
{
if (dbConn != null)
{
dbConn.Close();
}
}
return(assest);
}
public int AddMainAssest(MainCatogory assest)
{
int id = 0;
PetaPoco.Database db = null;
var dbConn = DataContext.Database.Connection;
try
{
dbConn.Open();
db = new PetaPoco.Database(dbConn);
db.EnableAutoSelect = false;
id = db.ExecuteScalar <int>("declare @@ret INT; exec @@ret = usp_AddMainAssest " + " @MCName,@MCSymbol; select @@ret;",
new
{
@MCName = assest.MCName,
@MCSymbol = assest.MCSymbol
});
}
catch (Exception ex)
{
}
finally
{
if (dbConn != null)
{
dbConn.Close();
}
}
return(id);
}
public ActionResult ReviewMainCatogory(int?MCId)
{
UserService service = new UserService();
MainCatogory assest = new MainCatogory();
//ViewBag.Divisions = new SelectList(AllDivisions(), "Value", "Text");
assest = service.GetMainAssest(MCId);
return(View("ReviewMainAssest", assest));
}
public int UpdateMainAssest(MainCatogory assest)
{
int id = 0;
try
{
id = _repository.UpdateMainAssest(assest);
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
public ActionResult AddEditMainAssest(int?MCId)
{
UserService service = new UserService();
MainCatogory assest = new MainCatogory();
assest = service.GetMainAssest(MCId);
if (assest == null)
{
assest = new MainCatogory();
}
//ViewBag.Divisions = new SelectList(AllDivisions(), "Value", "Text");
//ViewBag.Designations = new SelectList(AllDesignation(user.Division), "Value", "Text");
return(View("AddEditMainAssest", assest));
}
public MainCatogory GetMainAssest(int?MCId)
{
MainCatogory assest = new MainCatogory();
try
{
assest = _repository.GetMainAssest(MCId);
}
catch (Exception ex)
{
throw;
}
return(assest);
}
public ActionResult SaveMainAssest(MainCatogory assest)
{
int id = 0;
UserService service = new UserService();
try
{
if (assest.MCId > 0)
{
id = service.UpdateMainAssest(assest);
return(Json(new { Status = true, Id = id, Message = "Record updated successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
id = service.AddMainAssest(assest);
return(Json(new { Status = true, Id = id, Message = "Record added successfully" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { Status = false, Message = "Error Occured" }, JsonRequestBehavior.AllowGet));
}
}