public static IndentConsolidation GetIndentConsolidationObject(DataRow dr) { if (dr != null) { IndentConsolidation consolidation = new IndentConsolidation(); consolidation.ConsolidationId = Convert.ToInt32(dr["ConsolidationId"]); consolidation.CreatedDate = Convert.ToString(dr["CreatedDate"]); consolidation.Source = Convert.ToInt32(dr["SourceVal"]); consolidation.SourceCap = Convert.ToString(dr["SourceCap"]); consolidation.Status = Convert.ToInt32(dr["StatusVal"]); consolidation.StatusCap = Convert.ToString(dr["StatusCap"]); consolidation.ModifiedDate = Convert.ToString(dr["ModifiedDate"]); return(consolidation); } return(null); }
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); }
public IndentConsolidation GetConsolidationDetail(int ConsolidationId, bool IsUnderConsolidation) { IndentConsolidation consolidation = null; string SP_NAME = "usp_GetConsolidationDetail"; using (DataTaskManager dtManager = new DataTaskManager()) { //Declare and initialize the parameter list object. DBParameterList dbParam = new DBParameterList(); //Add the relevant 2 parameters dbParam.Add(new DBParameter("@ConsolidationId", ConsolidationId, DbType.Int32)); dbParam.Add(new DBParameter("@UnderConsolidation", IsUnderConsolidation, DbType.Int32)); dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH)); DataSet dsTemp = dtManager.ExecuteDataSet(SP_NAME, dbParam); string errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString(); if (string.IsNullOrEmpty(errorMessage) && dsTemp.Tables.Count > 0) { if (dsTemp.Tables[0].Rows.Count > 0) { consolidation = new IndentConsolidation(); DataRow dr = dsTemp.Tables[0].Rows[0]; consolidation.ConsolidationId = Convert.ToInt32(dr["ConsolidationId"]); consolidation.CreatedDate = Convert.ToString(dr["CreatedDate"]); consolidation.Source = Convert.ToInt32(dr["SourceVal"]); consolidation.SourceCap = Convert.ToString(dr["SourceCap"]); consolidation.Status = Convert.ToInt32(dr["StatusVal"]); consolidation.StatusCap = Convert.ToString(dr["StatusCap"]); consolidation.ModifiedDate = Convert.ToString(dr["ModifiedDate"]); } } return(consolidation); } }