public ActionResult SaveLawGuide(string prm = "")
{
LawGuideModel objLawGuideModel = new LawGuideModel();
try
{
//if prm(Paramter) is empty means Add condition else edit condition
if (!String.IsNullOrEmpty(prm))
{
int LawGuideId;
//decrypt parameter and set in LawGuideId variable
int.TryParse(CommonUtils.Decrypt(prm), out LawGuideId);
//Get LawGuide detail by LawGuide Id
serviceResponse = objUtilityWeb.GetAsync(WebApiURL.LawGuide + "/GetLawGuideById?LawGuideId=" + LawGuideId.ToString());
objLawGuideModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <LawGuideModel>().Result : null;
}
SubCatDropDown(objLawGuideModel.SubCategoryID, null, null);
}
catch (Exception ex)
{
ErrorLog(ex, "LawGuide", "SaveLawGuide Get");
}
return(View("SaveLawGuide", objLawGuideModel));
}
/// <summary>
/// Get LawGuide By Id
/// </summary>
/// <param name="LawGuideId"></param>
/// <returns>LawGuide Model</returns>
public LawGuideModel GetLawGuideById(int LawGuideId)
{
//Call GetLawGuideBYId method of dataLayer which will return Datatable.
DataTable dt = objDLLawGuide.GetLawGuideById(LawGuideId);
LawGuideModel objLawGuideModel = new LawGuideModel();
// if datatable has row than set object parameters
if (dt.Rows.Count > 0)
{
objLawGuideModel = GetDataRowToEntity <LawGuideModel>(dt.Rows[0]);
}
return(objLawGuideModel);
}
/// <summary>
/// Get LawGuide List based on paging, searching and sorting parameter
/// </summary>
/// <param name="objViewLawGuideModel">object of Model ViewLawGuideModel</param>
/// <returns></returns>
public ViewLawGuideModel GetLawGuideList(ViewLawGuideModel objViewLawGuideModel)
{
List <LawGuideModel> lstLawGuideModel = new List <LawGuideModel>();
//if FilterLawGuideName is NULL than set to empty
objViewLawGuideModel.FilterSubCatName = objViewLawGuideModel.FilterSubCatName ?? String.Empty;
//if SortBy is NULL than set to empty
objViewLawGuideModel.SortBy = objViewLawGuideModel.SortBy ?? String.Empty;
//call GetLawGuideList Method which will retrun datatable of LawGuide
DataTable dtLawGuide = objDLLawGuide.GetLawGuideList(objViewLawGuideModel);
//fetch each row of datable
foreach (DataRow dr in dtLawGuide.Rows)
{
//Convert datarow into Model object and set Model object property
LawGuideModel itemLawGuideModel = GetDataRowToEntity <LawGuideModel>(dr);
//Add LawGuide in List
lstLawGuideModel.Add(itemLawGuideModel);
}
//set LawGuide List of Model ViewLawGuideModel
objViewLawGuideModel.LawGuideList = lstLawGuideModel;
//if LawGuide List count is not null and greater than 0 Than set Total Pages for Paging.
if (objViewLawGuideModel != null && objViewLawGuideModel.LawGuideList != null && objViewLawGuideModel.LawGuideList.Count > 0)
{
objViewLawGuideModel.CurrentPage = objViewLawGuideModel.LawGuideList[0].CurrentPage;
int totalRecord = objViewLawGuideModel.LawGuideList[0].TotalCount;
if (decimal.Remainder(totalRecord, objViewLawGuideModel.PageSize) > 0)
{
objViewLawGuideModel.TotalPages = (totalRecord / objViewLawGuideModel.PageSize + 1);
}
else
{
objViewLawGuideModel.TotalPages = totalRecord / objViewLawGuideModel.PageSize;
}
}
else
{
objViewLawGuideModel.TotalPages = 0;
objViewLawGuideModel.CurrentPage = 1;
}
return(objViewLawGuideModel);
}
public ActionResult SaveLawGuide(LawGuideModel objLawGuideModel)
{
try
{
if (ModelState.IsValid)
{
}
objLawGuideModel.IsActive = true;
objLawGuideModel.CreatedBy = LoggedInUserID;
//Insert or Update LawGuide
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.LawGuide + "/InsertUpdateLawGuide", objLawGuideModel);
objLawGuideModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <LawGuideModel>().Result : null;
//if error code is 0 means LawGuide saved successfully
if (Convert.ToInt32(objLawGuideModel.ErrorCode) == 0)
{
// Set success message
TempData["SucessMessage"] = "LawGuide Saved Successfully";
return(RedirectToAction("ViewLawGuide", "LawGuide"));
}
else if (Convert.ToInt32(objLawGuideModel.ErrorCode) == 52)
{
//If Errorcode is 52 means LawGuide Name is duplicate set duplicate LawGuide error message.
objLawGuideModel.Message = "LawGuide Duplicate not allowed";
objLawGuideModel.MessageType = CommonUtils.MessageType.Error.ToString().ToLower();
}
else
{
//set Error Message if error code is greater than 0 but not 52 (duplicate)
objLawGuideModel.Message = "Error while adding record";
objLawGuideModel.MessageType = CommonUtils.MessageType.Error.ToString().ToLower();
}
SubCatDropDown(objLawGuideModel.SubCategoryID, null, null);
}
catch (Exception ex)
{
ErrorLog(ex, "LawGuide", "SaveLawGuide POST");
}
return(View("SaveLawGuide", objLawGuideModel));
}
/// <summary>
/// Insert or Update LawGuide
/// </summary>
/// <param name="objLawGuideModel"></param>
/// <returns></returns>
public LawGuideModel InsertUpdateLawGuide(LawGuideModel objLawGuideModel)
{
try
{
objLawGuideModel.LawGuideName = objLawGuideModel.LawGuideName.ToString().Trim();
int ErrorCode = 0;
string ErrorMessage = "";
SqlParameter pErrorCode = new SqlParameter("@ErrorCode", ErrorCode);
pErrorCode.Direction = ParameterDirection.Output;
SqlParameter pErrorMessage = new SqlParameter("@ErrorMessage", ErrorMessage);
pErrorMessage.Direction = ParameterDirection.Output;
SqlParameter[] parmList =
{
new SqlParameter("@LawGuideID", objLawGuideModel.LawGuideID)
, new SqlParameter("@SubCategoryID", objLawGuideModel.SubCategoryID)
, new SqlParameter("@LawGuideName", objLawGuideModel.LawGuideName)
, new SqlParameter("@Description", objLawGuideModel.Description)
, new SqlParameter("@IsActive", objLawGuideModel.IsActive)
, new SqlParameter("@CreatedBy", objLawGuideModel.CreatedBy)
, pErrorCode
, pErrorMessage
};
//If LawGuideId is 0 Than Insert LawGuide else Update LawGuide
SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.Admin_InsertUpdateLawGuide, parmList);
//set error code and message
objLawGuideModel.ErrorCode = Convert.ToInt32(pErrorCode.Value);
objLawGuideModel.Message = Convert.ToString(pErrorMessage.Value);
return(objLawGuideModel);
}
catch (Exception ex)
{
throw ex;
}
}
public LawGuideModel InsertUpdateLawGuide(LawGuideModel objLawGuideModel)
{
return(objBLLawGuide.InsertUpdateLawGuide(objLawGuideModel));
}
/// <summary>
/// Insert or Update LawGuide
/// </summary>
/// <param name="objLawGuideModel">object of LawGuide Model</param>
/// <param name="ErrorCode"></param>
/// <param name="ErrorMessage"></param>
/// <returns></returns>
public LawGuideModel InsertUpdateLawGuide(LawGuideModel objLawGuideModel)
{
//call InsertUpdateLawGuide Method of dataLayer and return LawGuideModel
return(objDLLawGuide.InsertUpdateLawGuide(objLawGuideModel));
}
