/// <summary>
/// Updates the lookup detail record dal.
/// </summary>
/// <param name="_objLookupDetail">The objLookup detail.</param>
/// <returns>System.Int32.</returns>
public int UpdateLookupDetailRecordDAL(LookupDetail _objLookupDetail)
{
return(ExecuteScalarInt32Sp("TMS_Admin_LookupDetailUpdateRecord",
ParamBuilder.Par("@LookupDetailP_Name", _objLookupDetail.LookupDetailP_Name), ParamBuilder.Par("@LookupDetailS_Name", _objLookupDetail.LookupDetailS_Name),
ParamBuilder.Par("@Updatedby", _objLookupDetail.Updatedby), ParamBuilder.Par("@UpdatedDate", _objLookupDetail.UpdatedDate),
ParamBuilder.Par("@LookupDetaiId", _objLookupDetail.LookupDetaiId), ParamBuilder.Par("@IsActive", _objLookupDetail.IsActive), ParamBuilder.Par("@IsSelected", _objLookupDetail.IsSelected),
ParamBuilder.Par("@LookupID", _objLookupDetail.LookupID)));
}
/// <summary>
/// Inserts the lookup detail record dal.
/// </summary>
/// <param name="_objLookupDetail">The object lookup detail.</param>
/// <returns>System.Int64.</returns>
public long InsertLookupDetailRecordDAL(LookupDetail _objLookupDetail)
{
var parameters = new[] { ParamBuilder.Par("@LookupDetailId", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_Admin_LookupDetailInsertRecord", parameters,
ParamBuilder.Par("@LookupDetailP_Name", _objLookupDetail.LookupDetailP_Name), ParamBuilder.Par("@LookupDetailS_Name", _objLookupDetail.LookupDetailS_Name),
ParamBuilder.Par("@CreatedBy", _objLookupDetail.Createdby), ParamBuilder.Par("@CreatedDate", _objLookupDetail.CreatedDate),
ParamBuilder.Par("@LookupId", _objLookupDetail.LookupID), ParamBuilder.Par("@IsActive", _objLookupDetail.IsActive), ParamBuilder.Par("@IsSelected", _objLookupDetail.IsSelected)
));
}
/// <summary>
/// Inserts the lookup detail record bal.
/// </summary>
/// <param name="_objLookup">The object lookup.</param>
/// <returns>System.Int64.</returns>
public long InsertLookupDetailRecordBAL(LookupDetail _objLookup)
{
return(DAL.InsertLookupDetailRecordDAL(_objLookup));
}
/// <summary>
/// Deletes the lookup detail record bal.
/// </summary>
/// <param name="_objLookupDetail">The object lookup detail.</param>
/// <returns>System.Int32.</returns>
public int DeleteLookupDetailRecordBAL(LookupDetail _objLookupDetail)
{
return(DAL.DeleteLookupDetailRecordDAL(_objLookupDetail));
}
/// <summary>
/// Updates the lookup detail record bal.
/// </summary>
/// <param name="_objLookupDetail">The object lookup detail.</param>
/// <returns>System.Int32.</returns>
public int UpdateLookupDetailRecordBAL(LookupDetail _objLookupDetail)
{
return(DAL.UpdateLookupDetailRecordDAL(_objLookupDetail));
}
public ActionResult LookupDetail_Destroy([DataSourceRequest] DataSourceRequest request, LookupDetail objLookup)
{
objLookup.Updatedby = Convert.ToInt64(CurrentUser.NameIdentifier);
objLookup.UpdatedDate = DateTime.Now;
var Resp = _objeIookupBAL.DeleteLookupDetailRecordBAL(objLookup);
if (Resp != 1)
{
ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError);
}
var resultData = new[] { objLookup };
return(Json(resultData.AsQueryable().ToDataSourceResult(request, ModelState)));
}
public ActionResult LookupDetail_Create([DataSourceRequest] DataSourceRequest request, string LookupIdCreate, LookupDetail _LookupDetail)
{
_LookupDetail.Createdby = Convert.ToInt64(CurrentUser.NameIdentifier);
_LookupDetail.LookupID = Convert.ToInt64(LookupIdCreate);;
_LookupDetail.CreatedDate = DateTime.Now;
var Result = _objeIookupBAL.InsertLookupDetailRecordBAL(_LookupDetail);
_LookupDetail.LookupDetaiId = Result;
return(Json(new[] { _LookupDetail }.ToDataSourceResult(request, ModelState)));
}
/// <summary>
/// Deletes the lookup detail record dal.
/// </summary>
/// <param name="_objLookupDetail">The objLookup detail.</param>
/// <returns>System.Int32.</returns>
public int DeleteLookupDetailRecordDAL(LookupDetail _objLookupDetail)
{
return(ExecuteScalarInt32Sp("TMS_Admin_LookupDetailDeleteRecord",
ParamBuilder.Par("@Updatedby", _objLookupDetail.Updatedby), ParamBuilder.Par("@UpdatedDate", _objLookupDetail.UpdatedDate),
ParamBuilder.Par("@LookupDetaiId", _objLookupDetail.LookupDetaiId)));
}
