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 QualityApplicationMappingInfo Get_Quality_Application_Values(DataRow dr)
{
QualityApplicationMappingInfo qualityApplication = new QualityApplicationMappingInfo();
qualityApplication.Quality_Application_Id = Convert.ToInt32(dr["Quality_Application_Id"]);
qualityApplication.Application_Name = Convert.ToString(dr["Application_Name"]);
return(qualityApplication);
}
private List <SqlParameter> Set_Values_In_Applications(QualityApplicationMappingInfo qualityApplications)
{
List <SqlParameter> sqlParamList = new List <SqlParameter>();
sqlParamList.Add(new SqlParameter("@Quality_Id", qualityApplications.Quality_Id));
sqlParamList.Add(new SqlParameter("@Application_Name_Id", qualityApplications.Application_Name_Id));
if (qualityApplications.Quality_Application_Id == 0)
{
sqlParamList.Add(new SqlParameter("@CreatedBy", qualityApplications.CreatedBy));
}
sqlParamList.Add(new SqlParameter("@UpdatedBy", qualityApplications.UpdatedBy));
if (qualityApplications.Quality_Application_Id != 0)
{
sqlParamList.Add(new SqlParameter("@Quality_Appication_Id)", qualityApplications.Quality_Application_Id));
}
return(sqlParamList);
}
public void Insert_Application(QualityApplicationMappingInfo qualityApplications)
{
_qualityRepo.Insert_Application(qualityApplications);
}
public void Insert_Application(QualityApplicationMappingInfo qualityApplications)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Applications(qualityApplications), StoredProcedures.Insert_Application_sp.ToString(), CommandType.StoredProcedure);
}