// POST: api/QuestionCategory
/// <summary>
/// It takes the parameter QUESTION_CATEGORY model type
/// If QUESTION_CATEGORY.QC_ID = 0 or NULL then performs INSERT.
/// If QUESTION_CATEGORY.QC_ID > 0 and QUESTION_CATEGORY.DEL_FLG=N then performs UPDATE.
/// If QUESTION_CATEGORY.DEL_FLG=Y then performs DELETE.
/// </summary>
/// <param name="qc"></param>
public void Post([FromBody] QUESTION_CATEGORY qc) //insert
{
if ((qc.QC_ID.HasValue ? qc.QC_ID.Value : 0) == 0)
{
_logicLayer.InsertQuestionCategory(qc);
}
else
if (qc.QC_ID.Value > 0 && (string.IsNullOrWhiteSpace(qc.DEL_FLG) ? "N" : qc.DEL_FLG) == "N")
{
_logicLayer.UpdateQuestionCategory(qc);
}
else
{
_logicLayer.DeleteQuestionCategory(qc.QC_ID.Value);
}
}
internal List <QUESTION_CATEGORY> GetQuestionCategory(int subDomId)
{
var questionCategory = new List <QUESTION_CATEGORY>();
using (var connection = MySqlDbConnection.NewConnection)
{
_statement = string.Format(MySQLquery.GetQuestionCat,
subDomId > 0 ? Convert.ToString(subDomId) : "SUB_DOM_ID");
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);
}
}
}
}
}
return(questionCategory);
}
//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 UpdateQuestionCategory(QUESTION_CATEGORY qc)
{
_dac.UpdateQuestionCategory(qc);
}
//internal QUESTION_CATEGORY_LIST GetQuestionCategory(int subDomId)
//{
// return _dac.GetQuestionCategory(subDomId);
//}
internal void InsertQuestionCategory(QUESTION_CATEGORY qc)
{
_dac.InsertQuestionCategory(qc);
}
// PUT: api/Domain/5
public void Put([FromBody] QUESTION_CATEGORY qc) //update
{
_logicLayer.UpdateQuestionCategory(qc);
}
