public QualityViewModel()
{
Friendly_Message = new List <FriendlyMessageInfo>();
Pager = new PaginationInfo();
Quality = new QualityInfo();
Quality_Grid = new List <QualityInfo>();
Filter = new Quality_Filter();
Yarn_Types = new List <AttributeCodeInfo>();
Weaves_Types = new List <AttributeCodeInfo>();
Quality_Application_Mapping = new QualityApplicationMappingInfo();
Quality_Application_Mapping_Grid = new List <QualityApplicationMappingInfo>();
Application = new ApplicationInfo();
Quality_Market_Segment_Mapping = new QualityMarketSegmentMappingInfo();
Quality_Market_Segment_Mapping_Grid = new List <QualityMarketSegmentMappingInfo>();
Market_Segment = new MarketSegmentInfo();
}
private QualityMarketSegmentMappingInfo Get_Quality_Market_Segment_Mapping_Values(DataRow dr)
{
QualityMarketSegmentMappingInfo qualityMarketSegment = new QualityMarketSegmentMappingInfo();
qualityMarketSegment.Quality_Market_Segment_Id = Convert.ToInt32(dr["Quality_Market_Segment_Id"]);
qualityMarketSegment.Segment_Name = Convert.ToString(dr["Market_Segment_Name"]);
return(qualityMarketSegment);
}
private List <SqlParameter> Set_Values_In_Segments(QualityMarketSegmentMappingInfo qualityMarketSegments)
{
List <SqlParameter> sqlParamList = new List <SqlParameter>();
sqlParamList.Add(new SqlParameter("@Quality_Id", qualityMarketSegments.Quality_Id));
sqlParamList.Add(new SqlParameter("@Market_Segment_Id", qualityMarketSegments.Market_Segment_Id));
if (qualityMarketSegments.Quality_Market_Segment_Id == 0)
{
sqlParamList.Add(new SqlParameter("@CreatedBy", qualityMarketSegments.CreatedBy));
}
sqlParamList.Add(new SqlParameter("@UpdatedBy", qualityMarketSegments.UpdatedBy));
if (qualityMarketSegments.Quality_Market_Segment_Id != 0)
{
sqlParamList.Add(new SqlParameter("@Quality_Market_Segment_Id)", qualityMarketSegments.Quality_Market_Segment_Id));
}
return(sqlParamList);
}
public void Insert_Segment(QualityMarketSegmentMappingInfo qualityMarketSegments)
{
_qualityRepo.Insert_Segment(qualityMarketSegments);
}
public void Insert_Segment(QualityMarketSegmentMappingInfo qualityMarketSegments)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Segments(qualityMarketSegments), StoredProcedures.Insert_Segment_sp.ToString(), CommandType.StoredProcedure);
}
