public string[] createExternalTeacherWorkDataBase(ExternalWorkData SearchTeacher)
{
string[] returnValue = new string[2]; ;
DataBase Base = new DataBase();
StaffDataBase sDB = new StaffDataBase();
List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
Sqlconn.Open();
string sql = "INSERT INTO ExternalTeacherWorkRecordData (ExternalID, WorkDate1, WorkDate2, CourseName, WorkReward, CreateFileBy, CreateFileDate, UpFileBy, UpFileDate) " +
"VALUES (@ExternalID, @WorkDate1, @WorkDate2, @CourseName, @WorkReward, @CreateFileBy, getDate(), @UpFileBy, getDate())";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@ExternalID", SqlDbType.BigInt).Value = Chk.CheckStringtoIntFunction(SearchTeacher.ExternalID);
cmd.Parameters.Add("@WorkDate1", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(SearchTeacher.CourseDate1);
cmd.Parameters.Add("@WorkDate2", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(SearchTeacher.CourseDate2);
cmd.Parameters.Add("@CourseName", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(SearchTeacher.Course);
cmd.Parameters.Add("@WorkReward", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(SearchTeacher.CoursePrice);
cmd.Parameters.Add("@CreateFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
returnValue[0] = cmd.ExecuteNonQuery().ToString();
Sqlconn.Close();
}
catch (Exception e)
{
string item = e.Message.ToString();
returnValue[0] = "-1";
returnValue[1] = item;
}
}
return returnValue;
}
public string[] createExternalTeacherWorkDataBase(ExternalWorkData SearchTeacher)
{
SalaryManagement smDB = new SalaryManagement();
if (int.Parse(smDB._StaffhaveRoles[2]) == 1)
{
return smDB.createExternalTeacherWorkDataBase(SearchTeacher);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
private List<ExternalWorkData> GetExternalTeacherWorkData(string staffID)
{
List<ExternalWorkData> returnValue = new List<ExternalWorkData>();
DataBase Base = new DataBase();
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
Sqlconn.Open();
string sql = "SELECT * FROM ExternalTeacherWorkRecordData WHERE isDeleted=0 AND ExternalID=@ExternalID ";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@ExternalID", SqlDbType.BigInt).Value = Chk.CheckStringtoIntFunction(staffID);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ExternalWorkData addValue = new ExternalWorkData();
addValue.ID = dr["WorkID"].ToString();
addValue.CourseDate1 = DateTime.Parse(dr["WorkDate1"].ToString()).ToString("yyyy-MM-dd");
addValue.CourseDate2 = DateTime.Parse(dr["WorkDate2"].ToString()).ToString("yyyy-MM-dd");
addValue.Course = dr["CourseName"].ToString();
addValue.CoursePrice = dr["WorkReward"].ToString();
returnValue.Add(addValue);
}
dr.Close();
Sqlconn.Close();
}
catch (Exception e)
{
ExternalWorkData addValue = new ExternalWorkData();
addValue.ID = "-1";
addValue.Course = e.Message.ToString();
returnValue.Add(addValue);
}
}
return returnValue;
}