internal void DeleteSubDomain(int subDom) { using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.DeleteSubDomain, subDom ); using (var command = MySqlDbConnection.Command(connection, _statement)) { command.ExecuteNonQuery(); } } }
internal void DeleteDocumentMaster(int dmId) { using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.DeleteDocumentMaster, dmId ); using (var command = MySqlDbConnection.Command(connection, _statement)) { command.ExecuteNonQuery(); } } }
internal void DeleteQuestionControl(int qctId) { using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.DeleteQuestionControl, qctId ); using (var command = MySqlDbConnection.Command(connection, _statement)) { command.ExecuteNonQuery(); } } }
internal void InsertDocumentMaster(DOCUMENT_MASTER dm) { using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.InsertDocumentMaster, string.Concat("'", dm.SUB_DOM_ID.Value, "'"), string.Concat("'", dm.CONTENT, "'"), string.Concat("'", string.IsNullOrWhiteSpace(dm.DEL_FLG) ? "N" : dm.DEL_FLG, "'"), string.Concat("'", string.IsNullOrWhiteSpace(dm.ORGL_USER) ? "ADMIN" : dm.ORGL_USER, "'"), "SYSDATE()" ); using (var command = MySqlDbConnection.Command(connection, _statement)) { command.ExecuteNonQuery(); } } }
internal void InsertDomain(DOMAIN dm) { using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.InsertDomain, string.Concat("'", dm.NAME, "'"), string.Concat("'", dm.DESCRIPTION, "'"), string.Concat("'", string.IsNullOrWhiteSpace(dm.DEL_FLG) ? "N" : dm.DEL_FLG, "'"), //dm.DEL_FLG string.Concat("'", string.IsNullOrWhiteSpace(dm.ORGL_USER) ? "ADMIN" : dm.ORGL_USER, "'"), "SYSDATE()" ); using (var command = MySqlDbConnection.Command(connection, _statement)) { command.ExecuteNonQuery(); } } }
internal List <QUESTION_ITEM> GetQuestionItem(int sqcId) { var QuestionItem = new List <QUESTION_ITEM>(); using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.GetQuestionItem, sqcId > 0 ? Convert.ToString(sqcId) : "SQC_ID"); //sqcId); using (var command = MySqlDbConnection.Command(connection, _statement)) { using (var reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { var questItem = new QUESTION_ITEM(); questItem.QI_ID = UtilityDL.CheckNull <int>(reader["QI_ID"]); questItem.SQC_ID = UtilityDL.CheckNull <int>(reader["SQC_ID"]); questItem.QC_ID = UtilityDL.CheckNull <int>(reader["QC_ID"]); questItem.DOM_ID = UtilityDL.CheckNull <int>(reader["DOM_ID"]); questItem.SUB_DOM_ID = UtilityDL.CheckNull <int>(reader["SUB_DOM_ID"]); questItem.NAME = UtilityDL.CheckNull <string>(reader["NAME"]); questItem.DESCRIPTION = UtilityDL.CheckNull <string>(reader["DESCRIPTION"]); questItem.SEQ_NO = UtilityDL.CheckNull <int>(reader["SEQ_NO"]); questItem.ORGL_STAMP = UtilityDL.CheckNull <DateTime>(reader["ORGL_STAMP"]); questItem.ORGL_USER = UtilityDL.CheckNull <string>(reader["ORGL_USER"]); questItem.UPDT_STAMP = UtilityDL.CheckNull <DateTime>(reader["UPDT_STAMP"]); questItem.UPDT_USER = UtilityDL.CheckNull <string>(reader["UPDT_USER"]); questItem.DEL_FLG = UtilityDL.CheckNull <string>(reader["DEL_FLG"]); QuestionItem.Add(questItem); } } } } return(QuestionItem); } }
internal void UpdateDocumentMaster(DOCUMENT_MASTER dm) { using (var connection = MySqlDbConnection.NewConnection) { //var str = MySQLquery.UpdateDomain; _statement = string.Format(MySQLquery.UpdateDocumentMaster, dm.SUB_DOM_ID.HasValue ? Convert.ToString(dm.SUB_DOM_ID.Value) : "SUB_DOM_ID", string.IsNullOrWhiteSpace(dm.CONTENT) ? "CONTENT" : string.Concat("'", dm.CONTENT, "'"), string.IsNullOrWhiteSpace(dm.UPDT_USER) ? "UPDT_USER" : string.Concat("'", dm.UPDT_USER, "'"), "SYSDATE()", dm.DM_ID.Value ); using (var command = MySqlDbConnection.Command(connection, _statement)) { command.ExecuteNonQuery(); } } }
internal void InsertControlMaster(CONTROL_MASTER cm) { using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.InsertControlMaster, string.Concat("'", cm.CONTROL_TYP, "'"), string.Concat("'", cm.NAME, "'"), string.Concat("'", cm.LABEL, "'"), string.Concat("'", cm.SAMPLE_PIC, "'"), string.Concat("'", string.IsNullOrWhiteSpace(cm.DEL_FLG) ? "N" : cm.DEL_FLG, "'"), string.Concat("'", string.IsNullOrWhiteSpace(cm.ORGL_USER) ? "ADMIN" : cm.ORGL_USER, "'"), "SYSDATE()" ); using (var command = MySqlDbConnection.Command(connection, _statement)) { command.ExecuteNonQuery(); } } }
internal void UpdateDomain(DOMAIN dm) { using (var connection = MySqlDbConnection.NewConnection) { //var str = MySQLquery.UpdateDomain; _statement = string.Format(MySQLquery.UpdateDomain, string.IsNullOrWhiteSpace(dm.NAME) ? "NAME" : string.Concat("'", dm.NAME, "'"), string.IsNullOrWhiteSpace(dm.DESCRIPTION) ? "DESCRIPTION" : string.Concat("'", dm.DESCRIPTION, "'"), string.IsNullOrWhiteSpace(dm.UPDT_USER) ? "UPDT_USER" : string.Concat("'", dm.UPDT_USER, "'"), "SYSDATE()", dm.DOM_ID.Value ); using (var command = MySqlDbConnection.Command(connection, _statement)) { command.ExecuteNonQuery(); } } }
internal List <SUB_QUESTION_CATEGORY> GetSubQuestionCategory(int qcId) { var SubQuestionCategory = new List <SUB_QUESTION_CATEGORY>(); using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.GetSubQuestionCat, qcId > 0 ? Convert.ToString(qcId) : "QC_ID"); //qcId); using (var command = MySqlDbConnection.Command(connection, _statement)) { using (var reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { var subQuestCat = new SUB_QUESTION_CATEGORY(); subQuestCat.SQC_ID = UtilityDL.CheckNull <int>(reader["SQC_ID"]); subQuestCat.QC_ID = UtilityDL.CheckNull <int>(reader["QC_ID"]); subQuestCat.DOM_ID = UtilityDL.CheckNull <int>(reader["DOM_ID"]); subQuestCat.SUB_DOM_ID = UtilityDL.CheckNull <int>(reader["SUB_DOM_ID"]); subQuestCat.NAME = UtilityDL.CheckNull <string>(reader["NAME"]); subQuestCat.DESCRIPTION = UtilityDL.CheckNull <string>(reader["DESCRIPTION"]); subQuestCat.SEQ_NO = UtilityDL.CheckNull <int>(reader["SEQ_NO"]); subQuestCat.ORGL_STAMP = UtilityDL.CheckNull <DateTime>(reader["ORGL_STAMP"]); subQuestCat.ORGL_USER = UtilityDL.CheckNull <string>(reader["ORGL_USER"]); subQuestCat.UPDT_STAMP = UtilityDL.CheckNull <DateTime>(reader["UPDT_STAMP"]); subQuestCat.UPDT_USER = UtilityDL.CheckNull <string>(reader["UPDT_USER"]); subQuestCat.DEL_FLG = UtilityDL.CheckNull <string>(reader["DEL_FLG"]); SubQuestionCategory.Add(subQuestCat); } } } } return(SubQuestionCategory); } }
internal void UpdateSubDomain(SUB_DOMAIN sdm) { using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.UpdateSubDomain, sdm.DOM_ID.HasValue ? Convert.ToString(sdm.DOM_ID.Value) : "DOM_ID", string.IsNullOrWhiteSpace(sdm.NAME) ? "NAME" : string.Concat("'", sdm.NAME, "'"), string.IsNullOrWhiteSpace(sdm.DESCRIPTION) ? "DESCRIPTION" : string.Concat("'", sdm.DESCRIPTION, "'"), string.IsNullOrWhiteSpace(sdm.UPDT_USER) ? "UPDT_USER" : string.Concat("'", sdm.UPDT_USER, "'"), "SYSDATE()", sdm.SUB_DOM_ID.Value ); using (var command = MySqlDbConnection.Command(connection, _statement)) { command.ExecuteNonQuery(); } } }
internal void UpdateControlMaster(CONTROL_MASTER cm) { using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.UpdateControlMaster, string.IsNullOrWhiteSpace(cm.CONTROL_TYP) ? "CONTROL_TYP" : string.Concat("'", cm.CONTROL_TYP, "'"), string.IsNullOrWhiteSpace(cm.NAME) ? "NAME" : string.Concat("'", cm.NAME, "'"), string.IsNullOrWhiteSpace(cm.LABEL) ? "LABEL" : string.Concat("'", cm.LABEL, "'"), string.IsNullOrWhiteSpace(cm.SAMPLE_PIC) ? "SAMPLE_PIC" : string.Concat("'", cm.SAMPLE_PIC, "'"), string.IsNullOrWhiteSpace(cm.UPDT_USER) ? "UPDT_USER" : string.Concat("'", cm.UPDT_USER, "'"), "SYSDATE()", cm.CM_ID.Value ); using (var command = MySqlDbConnection.Command(connection, _statement)) { command.ExecuteNonQuery(); } } }
//internal question_category_list getquestioncategory(int subdomid) //{ // var questioncategorylist = new question_category_list(); // var questioncategory = new list<question_category>(); // using (var connection = mysqldbconnection.newconnection) // { // _statement = string.format(mysqlquery.getquestioncatbysubdomid , subdomid); // using (var command = mysqldbconnection.command(connection, _statement)) // { // using (var reader = command.executereader()) // { // if (reader.hasrows) // { // while (reader.read()) // { // var questcat = new question_category(); // questcat.qc_id = utilitydl.checknull<int>(reader["qc_id"]); // questcat.dom_id = utilitydl.checknull<int>(reader["dom_id"]); // questcat.sub_dom_id = utilitydl.checknull<int>(reader["sub_dom_id"]); // questcat.name = utilitydl.checknull<string>(reader["name"]); // questcat.description = utilitydl.checknull<string>(reader["description"]); // questcat.seq_no = utilitydl.checknull<int>(reader["seq_no"]); // questcat.orgl_stamp = utilitydl.checknull<datetime>(reader["orgl_stamp"]); // questcat.orgl_user = utilitydl.checknull<string>(reader["orgl_user"]); // questcat.updt_stamp = utilitydl.checknull<datetime>(reader["updt_stamp"]); // questcat.updt_user = utilitydl.checknull<string>(reader["updt_user"]); // questcat.del_flg = utilitydl.checknull<string>(reader["del_flg"]); // questioncategory.add(questcat); // } // } // } // } // } // questioncategorylist.questioncategory = questioncategory; // return questioncategorylist; // questioncategory; //} internal void InsertQuestionCategory(QUESTION_CATEGORY qc) { using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.InsertQuestionCategory, qc.DOM_ID.Value, qc.SUB_DOM_ID.Value, string.Concat("'", qc.NAME, "'"), string.Concat("'", qc.DESCRIPTION, "'"), qc.SEQ_NO.HasValue ? qc.SEQ_NO.Value : 0, string.Concat("'", string.IsNullOrWhiteSpace(qc.DEL_FLG) ? "N" : qc.DEL_FLG, "'"), //dm.DEL_FLG string.Concat("'", string.IsNullOrWhiteSpace(qc.ORGL_USER) ? "ADMIN" : qc.ORGL_USER, "'"), "SYSDATE()" ); using (var command = MySqlDbConnection.Command(connection, _statement)) { command.ExecuteNonQuery(); } } }
internal void UpdateQuestionCategory(QUESTION_CATEGORY qc) { using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.UpdateQuestionCategory, qc.DOM_ID.HasValue ? Convert.ToString(qc.DOM_ID.Value) : "DOM_ID", qc.SUB_DOM_ID.HasValue ? Convert.ToString(qc.SUB_DOM_ID.Value) : "SUB_DOM_ID", string.IsNullOrWhiteSpace(qc.NAME) ? "NAME" : string.Concat("'", qc.NAME, "'"), string.IsNullOrWhiteSpace(qc.DESCRIPTION) ? "DESCRIPTION" : string.Concat("'", qc.DESCRIPTION, "'"), qc.SEQ_NO.HasValue ? Convert.ToString(qc.SEQ_NO.Value) : "SEQ_NO", string.IsNullOrWhiteSpace(qc.UPDT_USER) ? "UPDT_USER" : string.Concat("'", qc.UPDT_USER, "'"), "SYSDATE()", qc.QC_ID.Value ); using (var command = MySqlDbConnection.Command(connection, _statement)) { command.ExecuteNonQuery(); } } }
internal void InsertQuestionItem(QUESTION_ITEM qi) { using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.InsertQuestionItem, qi.SQC_ID.Value, qi.QC_ID.Value, qi.DOM_ID.Value, qi.SUB_DOM_ID.Value, string.Concat("'", qi.NAME, "'"), string.Concat("'", qi.DESCRIPTION, "'"), qi.SEQ_NO, string.Concat("'", string.IsNullOrWhiteSpace(qi.DEL_FLG) ? "N" : qi.DEL_FLG, "'"), string.Concat("'", string.IsNullOrWhiteSpace(qi.ORGL_USER) ? "ADMIN" : qi.ORGL_USER, "'"), "SYSDATE()" ); using (var command = MySqlDbConnection.Command(connection, _statement)) { command.ExecuteNonQuery(); } } }
internal List <CONTROL_MASTER> GetAllControlMaster() { var ControlMaster = new List <CONTROL_MASTER>(); using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.GetControlMaster); using (var command = MySqlDbConnection.Command(connection, _statement)) { using (var reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { var controlMas = new CONTROL_MASTER(); controlMas.CM_ID = UtilityDL.CheckNull <int>(reader["CM_ID"]); controlMas.CONTROL_TYP = UtilityDL.CheckNull <string>(reader["CONTROL_TYP"]); controlMas.NAME = UtilityDL.CheckNull <string>(reader["NAME"]); controlMas.LABEL = UtilityDL.CheckNull <string>(reader["LABEL"]); controlMas.SAMPLE_PIC = UtilityDL.CheckNull <string>(reader["SAMPLE_PIC"]); controlMas.ORGL_STAMP = UtilityDL.CheckNull <DateTime>(reader["ORGL_STAMP"]); controlMas.ORGL_USER = UtilityDL.CheckNull <string>(reader["ORGL_USER"]); controlMas.UPDT_STAMP = UtilityDL.CheckNull <DateTime>(reader["UPDT_STAMP"]); controlMas.UPDT_USER = UtilityDL.CheckNull <string>(reader["UPDT_USER"]); controlMas.DEL_FLG = UtilityDL.CheckNull <string>(reader["DEL_FLG"]); ControlMaster.Add(controlMas); } } } } return(ControlMaster); } }
internal List <SUB_DOMAIN> GetSubDomain(int id) { var subDomains = new List <SUB_DOMAIN>(); using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.GetSubDomainByDomId, id); using (var command = MySqlDbConnection.Command(connection, _statement)) { using (var reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { var subDomain = new SUB_DOMAIN(); subDomain.SUB_DOM_ID = UtilityDL.CheckNull <int>(reader["SUB_DOM_ID"]); subDomain.DOM_ID = UtilityDL.CheckNull <int>(reader["DOM_ID"]); subDomain.NAME = UtilityDL.CheckNull <string>(reader["NAME"]); subDomain.DESCRIPTION = UtilityDL.CheckNull <string>(reader["DESCRIPTION"]); subDomain.ORGL_STAMP = UtilityDL.CheckNull <DateTime>(reader["ORGL_STAMP"]); subDomain.ORGL_USER = UtilityDL.CheckNull <string>(reader["ORGL_USER"]); subDomain.UPDT_STAMP = UtilityDL.CheckNull <DateTime>(reader["UPDT_STAMP"]); subDomain.UPDT_USER = UtilityDL.CheckNull <string>(reader["UPDT_USER"]); subDomain.DEL_FLG = UtilityDL.CheckNull <string>(reader["DEL_FLG"]); subDomains.Add(subDomain); } } } } } return(subDomains); }
internal List <QUESTION_CONTROL_AND_CONTROL_MASTER> GetQuestionControlAndMaster(int qiId) { var QuestionControlAndMaster = new List <QUESTION_CONTROL_AND_CONTROL_MASTER>(); using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.GetQuestionControlAndMaster, qiId > 0 ? Convert.ToString(qiId) : "QI_ID"); //qiId); using (var command = MySqlDbConnection.Command(connection, _statement)) { using (var reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { var questControlMaster = new QUESTION_CONTROL_AND_CONTROL_MASTER(); questControlMaster.QCT_ID = UtilityDL.CheckNull <int>(reader["QCT_ID"]); questControlMaster.QI_ID = UtilityDL.CheckNull <int>(reader["QI_ID"]); questControlMaster.SQC_ID = UtilityDL.CheckNull <int>(reader["SQC_ID"]); questControlMaster.QC_ID = UtilityDL.CheckNull <int>(reader["QC_ID"]); questControlMaster.DOM_ID = UtilityDL.CheckNull <int>(reader["DOM_ID"]); questControlMaster.SUB_DOM_ID = UtilityDL.CheckNull <int>(reader["SUB_DOM_ID"]); questControlMaster.NAME = UtilityDL.CheckNull <string>(reader["NAME"]); questControlMaster.LABEL = UtilityDL.CheckNull <string>(reader["LABEL"]); questControlMaster.HINT = UtilityDL.CheckNull <string>(reader["HINT"]); questControlMaster.OTHDESC = UtilityDL.CheckNull <string>(reader["OTHDESC"]); questControlMaster.LISTOFVAL = UtilityDL.CheckNull <string>(reader["LISTOFVAL"]); questControlMaster.CONTROL_ID = UtilityDL.CheckNull <int>(reader["CONTROL_ID"]); questControlMaster.SEQ_NO = UtilityDL.CheckNull <int>(reader["SEQ_NO"]); questControlMaster.CONTROL_TYP = UtilityDL.CheckNull <string>(reader["CONTROL_TYP"]); questControlMaster.CONTROL_NAME = UtilityDL.CheckNull <string>(reader["CONTROL_NAME"]); questControlMaster.CONTROL_LABEL = UtilityDL.CheckNull <string>(reader["CONTROL_LABEL"]); questControlMaster.SAMPLE_PIC = UtilityDL.CheckNull <string>(reader["SAMPLE_PIC"]); QuestionControlAndMaster.Add(questControlMaster); } } } } return(QuestionControlAndMaster); } }
internal List <QUESTION_CONTROL> GetQuestionControl(int qiId) { var QuestionControl = new List <QUESTION_CONTROL>(); using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.GetQuestionControl, qiId > 0 ? Convert.ToString(qiId) : "QI_ID"); //qiId); using (var command = MySqlDbConnection.Command(connection, _statement)) { using (var reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { var questControl = new QUESTION_CONTROL(); questControl.QCT_ID = UtilityDL.CheckNull <int>(reader["QCT_ID"]); questControl.QI_ID = UtilityDL.CheckNull <int>(reader["QI_ID"]); questControl.SQC_ID = UtilityDL.CheckNull <int>(reader["SQC_ID"]); questControl.QC_ID = UtilityDL.CheckNull <int>(reader["QC_ID"]); questControl.DOM_ID = UtilityDL.CheckNull <int>(reader["DOM_ID"]); questControl.SUB_DOM_ID = UtilityDL.CheckNull <int>(reader["SUB_DOM_ID"]); questControl.NAME = UtilityDL.CheckNull <string>(reader["NAME"]); questControl.LABEL = UtilityDL.CheckNull <string>(reader["LABEL"]); questControl.HINT = UtilityDL.CheckNull <string>(reader["HINT"]); questControl.OTHDESC = UtilityDL.CheckNull <string>(reader["OTHDESC"]); questControl.LISTOFVAL = UtilityDL.CheckNull <string>(reader["LISTOFVAL"]); questControl.CONTROL_ID = UtilityDL.CheckNull <int>(reader["CONTROL_ID"]); questControl.SEQ_NO = UtilityDL.CheckNull <int>(reader["SEQ_NO"]); questControl.DEL_FLG = UtilityDL.CheckNull <string>(reader["DEL_FLG"]); questControl.ORGL_USER = UtilityDL.CheckNull <string>(reader["ORGL_USER"]); questControl.ORGL_STAMP = UtilityDL.CheckNull <DateTime>(reader["ORGL_STAMP"]); questControl.UPDT_USER = UtilityDL.CheckNull <string>(reader["UPDT_USER"]); questControl.UPDT_STAMP = UtilityDL.CheckNull <DateTime>(reader["UPDT_STAMP"]); QuestionControl.Add(questControl); } } } } return(QuestionControl); } }