/// <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))); }