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);
}
}
