internal void UpdateQuestionItem(QUESTION_ITEM qi) { using (var connection = MySqlDbConnection.NewConnection) { _statement = string.Format(MySQLquery.UpdateQuestionItem, qi.SQC_ID.HasValue ? Convert.ToString(qi.SQC_ID.Value) : "SQC_ID", qi.QC_ID.HasValue ? Convert.ToString(qi.QC_ID.Value) : "QC_ID", qi.DOM_ID.HasValue ? Convert.ToString(qi.DOM_ID.Value) : "DOM_ID", qi.SUB_DOM_ID.HasValue ? Convert.ToString(qi.SUB_DOM_ID.Value) : "SUB_DOM_ID", string.IsNullOrWhiteSpace(qi.NAME) ? "NAME" : string.Concat("'", qi.NAME, "'"), string.IsNullOrWhiteSpace(qi.DESCRIPTION) ? "DESCRIPTION" : string.Concat("'", qi.DESCRIPTION, "'"), qi.SEQ_NO.HasValue ? Convert.ToString(qi.SEQ_NO.Value) : "SEQ_NO", string.IsNullOrWhiteSpace(qi.UPDT_USER) ? "UPDT_USER" : string.Concat("'", qi.UPDT_USER, "'"), "SYSDATE()", qi.QI_ID.Value ); // UPDATE QUESTION_ITEM SET SQC_ID = { 0 }, QC_ID = { 1 }, DOM_ID = { 2 }, SUB_DOM_ID = { 3 }, NAME = { 4 }, DESCRIPTION = { 5 }, SEQ_NO = { 6 }, UPDT_USER = { 7 }, UPDT_STAMP = { 8 } WHERE QI_ID = { 9 } using (var command = MySqlDbConnection.Command(connection, _statement)) { command.ExecuteNonQuery(); } } }
// POST: api/QuestionItem /// <summary> /// It takes the parameter QUESTION_ITEM model type. /// If QUESTION_ITEM.QI_ID = 0 or NULL then it performs INSERT. /// If QUESTION_ITEM.QI_ID > 0 and QUESTION_ITEM.DEL_FLG=N then it performs UPDATE. /// If QUESTION_ITEM.DEL_FLG=Y then it performs DELETE. /// </summary> /// <param name="qi"></param> public void Post([FromBody] QUESTION_ITEM qi) { if ((qi.QI_ID.HasValue ? qi.QI_ID.Value : 0) == 0) { _logicLayer.InsertQuestionItem(qi); } else if (qi.QI_ID.Value > 0 && (string.IsNullOrWhiteSpace(qi.DEL_FLG) ? "N" : qi.DEL_FLG) == "N") { _logicLayer.UpdateQuestionItem(qi); } else { _logicLayer.DeleteQuestionItem(qi.QI_ID.Value); } }
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 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(); } } }
// PUT: api/QuestionItemBySubDomain/5 /// <summary> /// Not Defined /// </summary> /// <param name="qi"></param> public void Put([FromBody] QUESTION_ITEM qi) { }
internal void UpdateQuestionItem(QUESTION_ITEM qi) { _dac.UpdateQuestionItem(qi); }
internal void InsertQuestionItem(QUESTION_ITEM qi) { _dac.InsertQuestionItem(qi); }
// PUT: api/Domain/5 public void Put([FromBody] QUESTION_ITEM qi) { _logicLayer.UpdateQuestionItem(qi); }