//public bool Save(IIndentConsolidation objIndentConsolidation, int intConsolidationStatus, ref int intConsolidationId, ref string poNumbers, ref string toiNumbers, ref string errorMessage) public bool Save(IIndentConsolidation objIndentConsolidation, int intConsolidationStatus, ref int intConsolidationId, ref string errorMessage) { string USP_INDENT_SAVE = "usp_IndentConsolidationSave"; DBParameterList dbParam; bool isSuccess = false; using (DataTaskManager dtManager = new DataTaskManager()) { //dtManager.BeginTransaction(); { dbParam = new DBParameterList(); dbParam.Add(new DBParameter(Common.PARAM_DATA, Common.ToXml(objIndentConsolidation), DbType.String)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, errorMessage, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); DataTable dt = dtManager.ExecuteDataTable(USP_INDENT_SAVE, dbParam); errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); if (errorMessage.Length > 0) { isSuccess = false; //dtManager.RollbackTransaction(); } else { if (dt == null) { isSuccess = false; // dtManager.RollbackTransaction(); } else { isSuccess = true; intConsolidationId = Convert.ToInt32(Validators.CheckForDBNull(dt.Rows[0]["ConsolidationId"], Common.INT_DBNULL)); //poNumbers = dt.Rows[0]["PONumbers"].ToString(); //toiNumbers = dt.Rows[0]["TOINumbers"].ToString(); //dtManager.CommitTransaction(); } } } } return(isSuccess); }
public List <IndentConsolidation> Search(IIndentConsolidation objIndentConsolidationReq, string PONumber, string TOINumber, ref string errorMessage) { string USP_INDENT_SEARCH = "usp_IndentConsolidationSearch"; List <IndentConsolidation> lstIndentConsolidation = new List <IndentConsolidation>(); DBParameterList dbParam; using (DataTaskManager dtManager = new DataTaskManager()) { dbParam = new DBParameterList(); dbParam.Add(new DBParameter(Common.PARAM_DATA, Common.ToXml(objIndentConsolidationReq), DbType.String)); dbParam.Add(new DBParameter(Common.PARAM_DATA2, Common.INT_DBNULL, DbType.Int32)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, errorMessage, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); dbParam.Add(new DBParameter("@PONumber", PONumber, DbType.String)); dbParam.Add(new DBParameter("@TOINumber", TOINumber, DbType.String)); DataTable dt = dtManager.ExecuteDataTable(USP_INDENT_SEARCH, dbParam); errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { IndentConsolidation indentConsolidation = new IndentConsolidation(); // indentConsolidation.IndentNo = dt.Rows[i]["IndentNo"].ToString(); indentConsolidation.ConsolidationId = Convert.ToInt32(dt.Rows[i]["ConsolidationId"]); indentConsolidation.Status = Convert.ToInt32(dt.Rows[i]["StatusVal"]); indentConsolidation.StatusCap = Convert.ToString(dt.Rows[i]["StatusCap"]); indentConsolidation.Source = Convert.ToInt32(dt.Rows[i]["SourceVal"]); indentConsolidation.SourceCap = Convert.ToString(dt.Rows[i]["SourceCap"]); indentConsolidation.CreatedDate = Convert.ToDateTime(dt.Rows[i]["CreatedDate"]).ToString(Common.DATE_TIME_FORMAT); indentConsolidation.ModifiedDate = Convert.ToDateTime(dt.Rows[i]["ModifiedDate"]).ToString(Common.DATE_TIME_FORMAT); lstIndentConsolidation.Add(indentConsolidation); } } } return(lstIndentConsolidation); }