internal void InsertQuestionControl(QUESTION_CONTROL qc) { using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.InsertQuestionControl, qc.QI_ID.Value, qc.SQC_ID.Value, qc.QC_ID.Value, qc.DOM_ID.Value, qc.SUB_DOM_ID.Value, string.Concat("'", qc.NAME, "'"), string.Concat("'", qc.LABEL, "'"), string.Concat("'", qc.HINT, "'"), string.Concat("'", qc.OTHDESC, "'"), string.Concat("'", qc.LISTOFVAL, "'"), qc.CONTROL_ID.Value, qc.SEQ_NO.Value, string.Concat("'", string.IsNullOrWhiteSpace(qc.DEL_FLG) ? "N" : qc.DEL_FLG, "'"), string.Concat("'", string.IsNullOrWhiteSpace(qc.ORGL_USER) ? "ADMIN" : qc.ORGL_USER, "'"), "SYSDATE()" ); //INSERT INTO QUESTION_CONTROL(QI_ID, SQC_ID, QC_ID, DOM_ID, SUB_DOM_ID, NAME, LABEL, HINT, OTHDESC, LISTOFVAL, CONTROL_ID, SEQ_NO, DEL_FLG, ORGL_USER, ORGL_STAMP) VALUES( { 0} , { 1} , { 2}, { 3} , { 4} , { 5}, { 6}, { 7}, { 8} , { 9} ,{ 10} , { 11} ,{ 12}, { 13}, { 14}) using (var command = MySqlDbConnection.Command(connection, _statement)) { command.ExecuteNonQuery(); } } }
internal void UpdateQuestionControl(QUESTION_CONTROL qc) { using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.UpdateQuestionControl, qc.QI_ID.HasValue ? Convert.ToString(qc.QI_ID.Value) : "QI_ID", qc.SQC_ID.HasValue ? Convert.ToString(qc.SQC_ID.Value) : "SQC_ID", qc.QC_ID.HasValue ? Convert.ToString(qc.QC_ID.Value) : "QC_ID", 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.LABEL) ? "LABEL" : string.Concat("'", qc.LABEL, "'"), string.IsNullOrWhiteSpace(qc.HINT) ? "HINT" : string.Concat("'", qc.HINT, "'"), string.IsNullOrWhiteSpace(qc.OTHDESC) ? "OTHDESC" : string.Concat("'", qc.OTHDESC, "'"), string.IsNullOrWhiteSpace(qc.LISTOFVAL) ? "LISTOFVAL" : string.Concat("'", qc.LISTOFVAL, "'"), qc.CONTROL_ID.HasValue ? Convert.ToString(qc.CONTROL_ID.Value) : "CONTROL_ID", 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.QCT_ID.Value ); using (var command = MySqlDbConnection.Command(connection, _statement)) { command.ExecuteNonQuery(); } } }
// POST: api/QuestionControl /// <summary> /// It takes the parameter QUESTION_CONTROL model type. /// If QUESTION_CONTROL.QCT_ID = 0 or NULL then it performs INSERT /// If QUESTION_CONTROL.QCT_ID > 0 and QUESTION_CONTROL.DEL_FLG=N then it performs UPDATE /// If QUESTION_CONTROL.DEL_FLG=Y then it performs DELETE /// </summary> /// <param name="qct"></param> public void Post([FromBody] QUESTION_CONTROL qct) { if ((qct.QCT_ID.HasValue ? qct.QCT_ID.Value : 0) == 0) { _logicLayer.InsertQuestionControl(qct); } else if (qct.QCT_ID.Value > 0 && (string.IsNullOrWhiteSpace(qct.DEL_FLG) ? "N" : qct.DEL_FLG) == "N") { _logicLayer.UpdateQuestionControl(qct); } else { _logicLayer.DeleteQuestionControl(qct.QCT_ID.Value); } }
// PUT: api/Domain/5 public void Put([FromBody] QUESTION_CONTROL qc) { _logicLayer.UpdateQuestionControl(qc); }
internal void UpdateQuestionControl(QUESTION_CONTROL qc) { }
internal void InsertQuestionControl(QUESTION_CONTROL qc) { }
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); } }