//public string Approved_Reject_Question(string Job,int seq, string ValueCodeQuestion, string ValueCodeAnswer, string ValueStatus,int Rewrite_Master) //{ // string MS = ""; // var ObjRun = new mgrSQLConnect(_configuration); // strSQL = "[dbo].[srpApproved_Reject_Question] '"+ Job + "','"+ ValueStatus + "','"+ seq.ToString() + "','"+ ValueCodeQuestion + "','"+ ValueCodeAnswer + "','"+ Rewrite_Master.ToString() + "'"; // dt = ObjRun.GetDatatables(strSQL); // MS = dt.Rows[0][1].ToString(); // return MS; //} public string Approved_Reject_Question_(string Job, string valueStatus_Array, string seq_Array, string ValueCodeQuestion, int Rewrite_Master) { var ObjRun = new mgrSQLConnect(_configuration); int Intpro = 0; string StrSql = ""; string MS = ""; string ValueCodeAnswer = Get_ValueCodeAnswer(ValueCodeQuestion); if (Job == "APP") { if (Rewrite_Master > 0) { //------------------ Back up The last Exam ------- StrSql = @"insert into [SPTOSystem].[dbo].[ValueList] ([ValueCode],[DisplayOrder],[Value_HTML],[Value_TEXT],[Answer],[Need] ,[ValueStatus],[Rewrite],[AddDate],[UpdDate],[UserName],[ComputerName]) select [ValueCode],[DisplayOrder],[Value_HTML],[Value_TEXT],[Answer],[Need] ,'OLD',[Rewrite],[AddDate],[UpdDate],[UserName],[ComputerName] from [SPTOSystem].[dbo].[ValueList] where(ValueCode = '" + ValueCodeQuestion + "' or ValueCode = '" + ValueCodeAnswer + "') and [ValueStatus] != 'NEW' and Rewrite = '" + Rewrite_Master.ToString() + "' "; Intpro = ObjRun.ExecProc(StrSql); if (Intpro < 0) { return("False"); } } //--------------- Update ----------------- StrSql = strSQL = "[dbo].[sprApproved_Reject_Question] '" + Job + "','" + valueStatus_Array + "','" + seq_Array + "','" + ValueCodeQuestion + "','" + ValueCodeAnswer + "','" + Rewrite_Master.ToString() + "'"; dt = ObjRun.GetDatatables(strSQL); MS = dt.Rows[0][1].ToString(); if (MS != "OK") { StrSql = @"delete [SPTOSystem].[dbo].[ValueList] where (ValueCode = '" + ValueCodeQuestion + "' or ValueCode = '" + ValueCodeAnswer + "') and ValueStatus ='OLD' and Rewrite = '" + Rewrite_Master.ToString() + "' "; Intpro = ObjRun.ExecProc(StrSql); return("False"); } else { Rewrite_Master = Rewrite_Master + 1; StrSql = @" update [SPTOSystem].[dbo].[InputItem] set [Rewrite] = '" + Rewrite_Master.ToString() + "' , [UpdDate] = getdate() where [ValueCodeQuestion]='" + ValueCodeQuestion + "' and [ValueCodeAnswer] = '" + ValueCodeAnswer + "' "; Intpro = ObjRun.ExecProc(StrSql); } } else { //--------------- Update ----------------- strSQL = "[dbo].[sprApproved_Reject_Question] '" + Job + "','" + valueStatus_Array + "','" + seq_Array + "','" + ValueCodeQuestion + "','" + ValueCodeAnswer + "','" + Rewrite_Master.ToString() + "'"; dt = ObjRun.GetDatatables(strSQL); MS = dt.Rows[0][1].ToString(); } return(MS); }