/// <summary> /// Insert or Update StepDocMapped /// </summary> /// <param name="objStepDocMappedModel"></param> /// <returns></returns> public StepDocMappedModel InsertUpdateStepDocMapped(StepDocMappedModel objStepDocMappedModel) { try { 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("@StepDocMappedID", objStepDocMappedModel.StepDocMappedID) , new SqlParameter("@DocumentID", objStepDocMappedModel.DocumentID) , new SqlParameter("@StepID", objStepDocMappedModel.StepID) , new SqlParameter("@DisplayOrder", objStepDocMappedModel.DisplayOrder) , new SqlParameter("@IsActive", objStepDocMappedModel.IsActive) , new SqlParameter("@CreatedBy", objStepDocMappedModel.CreatedBy) , pErrorCode , pErrorMessage }; //If StepDocMappedId is 0 Than Insert StepDocMapped else Update StepDocMapped SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.ADMIN_INSERTUPDATESTEPDOCMAPPED, parmList); //set error code and message objStepDocMappedModel.ErrorCode = Convert.ToInt32(pErrorCode.Value); objStepDocMappedModel.Message = Convert.ToString(pErrorMessage.Value); return(objStepDocMappedModel); } catch (Exception ex) { throw ex; } }
/// <summary> /// Get StepDocMapped By Id /// </summary> /// <param name="StepDocMappedId"></param> /// <returns>StepDocMapped Model</returns> public StepDocMappedModel GetStepDocMappedById(int StepDocMappedId) { //Call GetStepDocMappedBYId method of dataLayer which will return Datatable. DataTable dt = objDLStepDocMapped.GetStepDocMappedById(StepDocMappedId); StepDocMappedModel objStepDocMappedModel = new StepDocMappedModel(); // if datatable has row than set object parameters if (dt.Rows.Count > 0) { objStepDocMappedModel = GetDataRowToEntity <StepDocMappedModel>(dt.Rows[0]); } return(objStepDocMappedModel); }
/// <summary> /// Get StepDocMapped List based on paging, searching and sorting parameter /// </summary> /// <param name="objViewStepDocMappedModel">object of Model ViewStepDocMappedModel</param> /// <returns></returns> public ViewStepDocMappedModel GetStepDocMappedList(int StepID, int DocumentID) { ViewStepDocMappedModel objViewStepDocMappedModel = new ViewStepDocMappedModel(); objViewStepDocMappedModel.StepDocMappedList = new List <StepDocMappedModel>(); //call GetStepDocMappedList Method which will retrun datatable of StepDocMapped DataTable dtStepDocMapped = objDLStepDocMapped.GetStepDocMappedByDocumentID(StepID, DocumentID); //fetch each row of datable foreach (DataRow dr in dtStepDocMapped.Rows) { //Convert datarow into Model object and set Model object property StepDocMappedModel itemStepDocMappedModel = GetDataRowToEntity <StepDocMappedModel>(dr); //Add StepDocMapped in List objViewStepDocMappedModel.StepDocMappedList.Add(itemStepDocMappedModel); } return(objViewStepDocMappedModel); }
public StepDocMappedModel InsertUpdateStepDocMapped(StepDocMappedModel objStepDocMappedModel) { return(objBLStepDocMapped.InsertUpdateStepDocMapped(objStepDocMappedModel)); }
/// <summary> /// Insert or Update StepDocMapped /// </summary> /// <param name="objStepDocMappedModel">object of StepDocMapped Model</param> /// <param name="ErrorCode"></param> /// <param name="ErrorMessage"></param> /// <returns></returns> public StepDocMappedModel InsertUpdateStepDocMapped(StepDocMappedModel objStepDocMappedModel) { //call InsertUpdateStepDocMapped Method of dataLayer and return StepDocMappedModel return(objDLStepDocMapped.InsertUpdateStepDocMapped(objStepDocMappedModel)); }