public DataTable sprPracticalSnapshot(string Flag, string Staffcode, string PlanID, string LicenseName,
int ItemID, int QuestionNo, int HearingJudge, TimeSpan ActualTime, int PracticalJudge, int Judge, string OPID)
{
mgrSQL_ObjCommand ObjRun = new mgrSQL_ObjCommand(_configuration);
SqlCommand SqlCMD = new SqlCommand();
SqlCMD = new SqlCommand();
SqlCMD.CommandType = CommandType.StoredProcedure;
SqlCMD.CommandText = "sprPracticalSnapshot";
SqlCMD.Parameters.Add("@Flag", SqlDbType.Char).Value = Flag;
SqlCMD.Parameters.Add("@Staffcode", SqlDbType.NVarChar).Value = Staffcode;
SqlCMD.Parameters.Add("@PlanID", SqlDbType.NVarChar).Value = PlanID;
SqlCMD.Parameters.Add("@LicenseName", SqlDbType.NVarChar).Value = LicenseName;
SqlCMD.Parameters.Add("@ItemID", SqlDbType.Int).Value = ItemID;
SqlCMD.Parameters.Add("@QuestionNo", SqlDbType.Int).Value = QuestionNo;
SqlCMD.Parameters.Add("@HearingJudge", SqlDbType.Bit).Value = HearingJudge;
SqlCMD.Parameters.Add("@ActualTime", SqlDbType.Time).Value = ActualTime;
SqlCMD.Parameters.Add("@PracticalJudge", SqlDbType.Bit).Value = PracticalJudge;
SqlCMD.Parameters.Add("@Judge", SqlDbType.Bit).Value = Judge;
SqlCMD.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = OPID;
dt = new DataTable();
dt = ObjRun.GetDataTable(SqlCMD);
return(dt);
}
public DataTable sprMakeDisplayPractical(string Staffcode, string PlanID, string ItemID, string LicenseName)
{
mgrSQL_ObjCommand ObjRun = new mgrSQL_ObjCommand(_configuration);
SqlCommand SqlCMD = new SqlCommand();
SqlCMD = new SqlCommand();
SqlCMD.CommandType = CommandType.StoredProcedure;
SqlCMD.CommandText = "sprMakeDisplayPractical";
SqlCMD.Parameters.Add("@Staffcode", SqlDbType.NVarChar).Value = Staffcode.Trim();
SqlCMD.Parameters.Add("@Plan_ID", SqlDbType.NVarChar).Value = PlanID.Trim();
SqlCMD.Parameters.Add("@ItemID", SqlDbType.NVarChar).Value = ItemID.Trim();
SqlCMD.Parameters.Add("@LicenseName", SqlDbType.NVarChar).Value = LicenseName.Trim();
dt = ObjRun.GetDataTable(SqlCMD);
return(dt);
}
public string Approved_Reject_Question(string Job, string valueStatus_Array, string seq_Array, string ValueCodeQuestion, int Rewrite_Master)
{
string ValueCodeAnswer = Get_ValueCodeAnswer(ValueCodeQuestion);
var ds = new DataSet();
SqlCommand objSqlCmd = new SqlCommand();
var OBJ = new mgrSQL_ObjCommand(_configuration);
objSqlCmd.CommandType = CommandType.StoredProcedure;
objSqlCmd.CommandText = "sprApproved_Reject_Question";
objSqlCmd.Parameters.Clear();
objSqlCmd.Parameters.Add("@Job", SqlDbType.VarChar).Value = Job;
objSqlCmd.Parameters.Add("@Status", SqlDbType.VarChar).Value = valueStatus_Array.ToString();
objSqlCmd.Parameters.Add("@Seq", SqlDbType.VarChar).Value = seq_Array.ToString();
objSqlCmd.Parameters.Add("@valueCodeQuestion", SqlDbType.VarChar).Value = ValueCodeQuestion.ToString();
objSqlCmd.Parameters.Add("@valueCodeAnswer", SqlDbType.VarChar).Value = ValueCodeAnswer;
objSqlCmd.Parameters.Add("@Rewrite", SqlDbType.Int).Value = Rewrite_Master;
dt = OBJ.GetDataTable(objSqlCmd);
return(dt.Rows[0][1].ToString());
}