//public static InsightSupplierCustomDetail GetInsightSupplierCustomDetailByInsightSupplierId(int insightSupplierId) //{ // Database db = DatabaseFactory.CreateDatabase("SPARInsightManagement"); // string sqlCommand = "GetInsightSupplierCustomDetailByInsightSupplierId"; // DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); // db.AddInParameter(dbCommand, "@InsightSupplierId", DbType.Int32, insightSupplierId); // db.AddOutParameter(dbCommand, "@InsightSupplierCustomDetailId", DbType.Int32, 4); // db.AddOutParameter(dbCommand, "@CustomType", DbType.String, 50); // db.AddOutParameter(dbCommand, "@CustomFrequency", DbType.String, 50); // db.AddOutParameter(dbCommand, "@CustomResponsibility", DbType.String, 50); // db.AddOutParameter(dbCommand, "@Detail", DbType.String, 50); // db.AddOutParameter(dbCommand, "@SourceFile", DbType.String, 50); // db.AddOutParameter(dbCommand, "@Status", DbType.String, 50); // db.ExecuteNonQuery(dbCommand); // InsightSupplierCustomDetail insightSupplierCustomDetail = new InsightSupplierCustomDetail(); // insightSupplierCustomDetail.InsightSupplierId = insightSupplierId; // insightSupplierCustomDetail.InsightSupplierCustomDetailId = Convert.ToInt32(db.GetParameterValue(dbCommand, "InsightSupplierCustomDetailId")); // insightSupplierCustomDetail.CustomType = db.GetParameterValue(dbCommand, "CustomType").ToString(); // insightSupplierCustomDetail.CustomFrequency = db.GetParameterValue(dbCommand, "CustomFrequency").ToString(); // insightSupplierCustomDetail.CustomResponsibility = db.GetParameterValue(dbCommand, "CustomResponsibility").ToString(); // insightSupplierCustomDetail.Detail = db.GetParameterValue(dbCommand, "Detail").ToString(); // insightSupplierCustomDetail.SourceFile = db.GetParameterValue(dbCommand, "SourceFile").ToString(); // insightSupplierCustomDetail.Status = db.GetParameterValue(dbCommand, "Status").ToString(); // return insightSupplierCustomDetail; //} public static InsightSupplierCustomDetail GetInsightSupplierCustomDetailByInsightSupplierCustomDetailId(int insightSupplierCustomDetailId) { Database db = DatabaseFactory.CreateDatabase("SPARInsightManagement"); string sqlCommand = "GetInsightSupplierCustomDetailByInsightSupplierCustomDetailId"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@InsightSupplierCustomDetailId", DbType.Int32, insightSupplierCustomDetailId); db.AddOutParameter(dbCommand, "@InsightSupplierId", DbType.Int32, 4); db.AddOutParameter(dbCommand, "@CustomTypeId", DbType.Int32, 4); db.AddOutParameter(dbCommand, "@CustomFrequencyId", DbType.Int32, 4); db.AddOutParameter(dbCommand, "@CustomResponsibilityId", DbType.Int32, 4); db.AddOutParameter(dbCommand, "@Detail", DbType.String, 8000); db.AddOutParameter(dbCommand, "@SourceFile", DbType.String, 8000); db.AddOutParameter(dbCommand, "@StatusId", DbType.Int32, 4); db.ExecuteNonQuery(dbCommand); InsightSupplierCustomDetail insightSupplierCustomDetail = new InsightSupplierCustomDetail(); insightSupplierCustomDetail.InsightSupplierCustomDetailId = insightSupplierCustomDetailId; insightSupplierCustomDetail.InsightSupplierId = Convert.ToInt32(db.GetParameterValue(dbCommand, "InsightSupplierId")); insightSupplierCustomDetail.CustomTypeId = Convert.ToInt32(db.GetParameterValue(dbCommand, "CustomTypeId")); insightSupplierCustomDetail.CustomFrequencyId = Convert.ToInt32(db.GetParameterValue(dbCommand, "CustomFrequencyId")); insightSupplierCustomDetail.CustomResponsibilityId = Convert.ToInt32(db.GetParameterValue(dbCommand, "CustomResponsibilityId")); insightSupplierCustomDetail.Detail = db.GetParameterValue(dbCommand, "Detail").ToString(); insightSupplierCustomDetail.SourceFile = db.GetParameterValue(dbCommand, "SourceFile").ToString(); insightSupplierCustomDetail.StatusId = Convert.ToInt32(db.GetParameterValue(dbCommand, "StatusId")); return(insightSupplierCustomDetail); }
public static List <InsightSupplierCustomDetail> GetInsightSupplierCustomDetailByInsightSupplierId(int insightSupplierId) { List <InsightSupplierCustomDetail> list = new List <InsightSupplierCustomDetail>(); Database db = DatabaseFactory.CreateDatabase("SPARInsightManagement"); string sqlCommand = "GetInsightSupplierCustomDetailByInsightSupplierId"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@InsightSupplierId", DbType.Int32, insightSupplierId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { InsightSupplierCustomDetail insightSupplierCustomDetail = new InsightSupplierCustomDetail(); insightSupplierCustomDetail.InsightSupplierId = insightSupplierId; insightSupplierCustomDetail.InsightSupplierCustomDetailId = Convert.ToInt32(dataReader["InsightSupplierCustomDetailId"]); insightSupplierCustomDetail.CustomType = dataReader["CustomType"].ToString(); insightSupplierCustomDetail.CustomFrequency = dataReader["CustomFrequency"].ToString(); insightSupplierCustomDetail.CustomResponsibility = dataReader["CustomResponsibility"].ToString(); insightSupplierCustomDetail.Detail = dataReader["Detail"].ToString(); insightSupplierCustomDetail.SourceFile = dataReader["SourceFile"].ToString(); insightSupplierCustomDetail.Status = dataReader["Status"].ToString(); list.Add(insightSupplierCustomDetail); } } return(list); }