public List <Fixture_VM> GetData(Fixture_VM Model)
{
var query = new List <Fixture_VM>();
try
{
using (var db = new DBConnection())
{
var ds = new DataSet();
var par = new SqlParameter[] {
new SqlParameter("@p_FixtureID", GetDBNULL(Model.FixtureID)),
new SqlParameter("@p_FixtureCode", GetDBNULLString(Model.FixtureCode)),
new SqlParameter("@p_FixtureName", GetDBNULLString(Model.FixtureName)),
new SqlParameter("@p_FixtureCost", GetDBNULL(Model.FixtureCost)),
new SqlParameter("@p_IsChildResult", GetDBNULL(Model.IsChildResult))
};
ds = db.ExecuteDataSet("GetFixture", par);
query = ConvertToList <Fixture_VM>(ds.Tables[0]);
if (Model.IsChildResult == true)
{
query[0].FixturePartList = ConvertToList <FixturePart_VM>(ds.Tables[1]);
}
}
}
catch (Exception ex)
{
logger.Error("FixtureRepository_GetData Error: ", ex);
throw;
}
return(query);
}
public int Delete(Fixture_VM Model)
{
int result = 0;
try
{
using (var db = new DBConnection())
{
var par = new SqlParameter[] {
new SqlParameter("@p_FixtureID", GetDBNULL(Model.FixtureID)),
new SqlParameter("@p_EndUserID", GetDBNULL(Model.CurrentEndUserID)),
new SqlParameter("@p_UserRoleID", GetDBNULL(Model.CurrentUserRoleID)),
new SqlParameter("@p_ScreenID", GetDBNULL(Model.CurrentScreenID)),
new SqlParameter("@p_AccessPoint", GetDBNULLString(Model.AccessPoint))
};
result = db.ExecuteNonQueryRollBack("DeleteFixture", par);
}
}
catch (Exception ex)
{
logger.Error("FixtureRepository_Delete Error: ", ex);
throw;
}
return(result);
}
public JsonResult AddUpdateData(Fixture_VM Model)
{
if (ModelState.IsValid)
{
try
{
GetUserInfo(Model);
if (Model.FixtureID == 0 || Model.FixtureID == null)
{
var data = _FixtureRepo.Add(Model);
return(GetAddEditDeleteResponse(data, "Add"));
}
else if (Model.FixtureID > 0)
{
var data = _FixtureRepo.Update(Model);
return(GetAddEditDeleteResponse(data, "Update"));
}
}
catch (Exception ex)
{
logger.Error("FixtureController_AddUpdateData Error: ", ex);
return(GetAddEditErrorException(ex));
}
}
return(GetModelStateIsValidException(ViewData));
}
public IEnumerable <SelectListItem> GetFixture(Fixture_VM Model)
{
IEnumerable <Fixture_VM> query = new FixtureRepository().GetData(Model);
IEnumerable <SelectListItem> list = query.Select(x => new SelectListItem()
{
Text = x.FixtureName, Value = x.FixtureID.ToString()
}).ToList();
return(list);//.OrderBy(x => x.Text);
}
public int Add(Fixture_VM Model)
{
int result = 0;
try
{
using (var db = new DBConnection())
{
var dt_FixturePart = new DataTable();
if (Model.FixturePart_TableTypeList != null && Model.FixturePart_TableTypeList.Count > 0)
{
dt_FixturePart = ConvertToDatatable(Model.FixturePart_TableTypeList);
}
else
{
dt_FixturePart = ConvertToDatatable(new List <FixturePart_TableType_VM>());
}
var output = new SqlParameter("@p_FixtureID", 0)
{
Direction = ParameterDirection.Output
};
var par = new SqlParameter[] {
new SqlParameter("@p_FixtureName", GetDBNULL(Model.FixtureName)),
new SqlParameter("@p_FixtureCost", GetDBNULL(Model.FixtureCost)),
new SqlParameter("@p_FixtureCode", GetDBNULLString(Model.FixtureCode)),
new SqlParameter("@p_FixturePart", dt_FixturePart)
{
TypeName = "FixturePart_TableType"
},
new SqlParameter("@p_EndUserID", GetDBNULL(Model.CurrentEndUserID)),
new SqlParameter("@p_UserRoleID", GetDBNULL(Model.CurrentUserRoleID)),
new SqlParameter("@p_ScreenID", GetDBNULL(Model.CurrentScreenID)),
new SqlParameter("@p_AccessPoint", GetDBNULL(Model.AccessPoint)),
output
};
db.ExecuteNonQueryRollBack("AddFixture", par);
result = Convert.ToInt32(output.Value);
}
}
catch (Exception ex)
{
logger.Error("FixtureRepository_Add Error: ", ex);
throw;
}
return(result);
}
public JsonResult GetData(Fixture_VM Model)
{
try
{
var vm = _FixtureRepo.GetData(Model);
return(GetDataResponse(vm));
}
catch (Exception ex)
{
return(GetDataResponseException(ex));
}
}
public JsonResult Delete(Fixture_VM Model)
{
if (CheckAccess(Model.CurrentScreenID, "Fixture"))
{
try
{
GetUserInfo(Model);
if (Model.FixtureID > 0 && Model.FixtureID != null)
{
var data = _FixtureRepo.Delete(Model);
return(GetAddEditDeleteResponse(data, "Delete"));
}
}
catch (Exception ex)
{
logger.Error("FixtureController_Delete Error: ", ex);
return(GetAddEditErrorException(ex));
}
}
return(GetModelStateIsValidException(ViewData));
}
/// <summary>
///
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public IEnumerable <SelectListItem> GetFixture(Fixture_VM Model)
{
IEnumerable <Fixture_VM> query = new FixtureRepository().GetData(Model);
IEnumerable <SelectListItem> list;
if (Model.FixtureID != null)
{
list = query.Select(x => new SelectListItem()
{
Text = x.FixtureName + " (" + x.FixtureCost + ")", Value = x.FixtureID.ToString(), Selected = (x.FixtureID == Model.FixtureID ? true : false)
}).ToList();
}
else
{
list = query.Select(x => new SelectListItem()
{
Text = x.FixtureName + " (" + x.FixtureCost + ")", Value = x.FixtureID.ToString()
}).ToList();
}
return(list.OrderBy(x => x.Text));
}
