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