protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.admin_university) || autro_obj.CheckGroupUser(login_data, group_var.admin_faculty))
{
/*=============================*/
code = Request.QueryString["token"];
if (!Page.IsPostBack)
{
data = obj.getDegreeAdmission(code);
txtDEGREE_CODE.Text = data.Degree_Code;
txtDEGREE_THAI.Text = data.Degree_Thai;
txtDEGREE_ENG.Text = data.Degree_Eng;
txtDEGREE_CHAR.Text = data.Degree_Char;
}
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
// V 1.0.0
public DegreeData getDegreeAdmission(string Degree_Code)
{
DegreeData Degree_data = new DegreeData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string response = "";
try
{
oracleObj.SelectCommand = "Select * From DEGREE_ADMISSION Where DEGREE_CODE='" + Degree_Code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
Degree_data.Degree_Code = rowData["DEGREE_CODE"].ToString();
Degree_data.Degree_Thai = rowData["DEGREE_THAI"].ToString();
Degree_data.Degree_Eng = rowData["DEGREE_ENG"].ToString();
Degree_data.Degree_Char = rowData["DEGREE_CHAR"].ToString();
}
}
catch (Exception e)
{
response = e.Message.ToString();
HttpContext.Current.Session["response"] = "Unit Test:System Config: " + response;
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(Degree_data);
}
public string updateDegreeAdmission(DegreeData updateData)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Update DEGREE_ADMISSION Set DEGREE_THAI = '" + updateData.Degree_Thai + "', DEGREE_ENG='" + updateData.Degree_Eng + "', DEGREE_CHAR='" + updateData.Degree_Char + "' Where DEGREE_CODE='" + updateData.Degree_Code + "'";
oracleObj.UpdateCommand = sql;
try
{
if (oracleObj.Update() == 1)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
HttpContext.Current.Session["response"] = "Unit Test:System Config: " + response;
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
public string insertDegreeAdmission(DegreeData dataInsert)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Insert Into DEGREE_ADMISSION(DEGREE_CODE, DEGREE_THAI, DEGREE_ENG, DEGREE_CHAR) Values('" + dataInsert.Degree_Code + "','" + dataInsert.Degree_Thai + "','" + dataInsert.Degree_Eng + "','" + dataInsert.Degree_Char + "')";
oracleObj.InsertCommand = sql;
try
{
if (oracleObj.Insert() == 1)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
HttpContext.Current.Session["response"] = "Unit Test:System Config: " + response;
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
// V 1.0.0
public List <DegreeData> getStudentDegreeAdmission(string degree_char)
{
List <DegreeData> degreeAdmissionData = new List <DegreeData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string response = "";
try
{
string sql = "Select * From DEGREE_ADMISSION Where DEGREE_CHAR='" + degree_char + "' Order By DEGREE_CODE";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
DegreeData Degree = new DegreeData();
Degree.Degree_Code = rowData["DEGREE_CODE"].ToString();
Degree.Degree_Thai = rowData["DEGREE_THAI"].ToString();
Degree.Degree_Eng = rowData["DEGREE_ENG"].ToString();
Degree.Degree_Char = rowData["DEGREE_CHAR"].ToString();
degreeAdmissionData.Add(Degree);
}
}
catch (Exception e)
{
response = e.Message.ToString();
HttpContext.Current.Session["response"] = "Unit Test:System Config: " + response;
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(degreeAdmissionData);
}
protected void btnSAVE_Click(object sender, EventArgs e)
{
DegreeData data = new DegreeData();
data.Degree_Code = txtDEGREE_CODE.Text;
data.Degree_Thai = txtDEGREE_THAI.Text;
data.Degree_Eng = txtDEGREE_ENG.Text;
data.Degree_Char = txtDEGREE_CHAR.Text;
string result = "";
try
{
result = new DegreeAdmission().updateDegreeAdmission(data);
if (result == "OK")
{
Response.Redirect("list_Degree_Admission.aspx");
}
else
{
Response.Redirect("list_Degree_Admission.aspx");
}
}
catch (Exception E)
{
//string response = E.Message.ToString();
//HttpContext.Current.Session["response"] = "Unit Test: " + response;
//HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
public IHttpActionResult Create([FromBody] DegreeModel degree)
{
u = credenciales.getUsuario();
c = credenciales.getUsuario();
var consulta = DegreeData.Crear(degree.Nombre, u);
return(Ok(consulta));
}
public IHttpActionResult Update([FromBody] DegreeModel degree)
{
u = credenciales.getUsuario();
var consulta = DegreeData.Actualizar(degree.DegreeId, degree.Nombre, u);
return(Ok(consulta));
}
public IHttpActionResult Show()
{
u = credenciales.getUsuario();
var consulta = DegreeData.Mostrar(u);
return(Ok(consulta));
}
public static bool cb(CSVReader csv_reader, DegreeData data, ref uint key)
{
data.id = key;
csv_reader.Pop(ref data.name);
csv_reader.PopEnum(ref data.type, DEGREE_TYPE.NONE);
csv_reader.PopEnum(ref data.requirementType, DEGREE_REQUIREMENT_TYPE.COMMON);
csv_reader.Pop(ref data.requirementText);
csv_reader.Pop(ref data.lockNameId);
csv_reader.Pop(ref data.lockTextId);
return(true);
}
public BankData getErrBankData(string payment_id, string payment_date, string payment_time, string degree_char)
{
Status_Variable status_var = new Status_Variable();
BankData bank_data = new BankData();
string TableName = getTableName(degree_char);
string sql = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
sql = "Select * From " + TableName + " Where PAYMENT_ID = '" + payment_id + "' And PAYMENT_DATE='" + payment_date + "' And PAYMENT_TIME = '" + payment_time + "'";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
DegreeData degree_data = new DegreeData();
bank_data.Amount = rowData["AMOUNT"].ToString().ToCharArray();
bank_data.BankCode = rowData["BANK_CODE"].ToString().ToCharArray();
bankcode_data = bankcodeObj.getBankCode(new string(bank_data.BankCode));
bank_data.Bank_ShortName = bankcode_data.Bank_ShortName;
bank_data.Bank_ThaiName = bankcode_data.Bank_ThaiName;
bank_data.TrancCode = rowData["TRANSACTION_CODE"].ToString().ToCharArray();
bank_data.Student_Name = rowData["STUDENT_NAME"].ToString();
bank_data.Student_ID = rowData["STUDENT_ID"].ToString();
bank_data.Nation_Passport_ID = rowData["NATION_PASSPORT_ID"].ToString();
bank_data.AcademicYear = rowData["ACADEMIC_YEAR"].ToString();
bank_data.Semester = rowData["SEMESTER"].ToString();
bank_data.Paymenty_ID = rowData["PAYMENT_ID"].ToString();
bank_data.Payment_Date = rowData["PAYMENT_DATE"].ToString();
bank_data.Payment_Time = rowData["PAYMENT_TIME"].ToString();
bank_data.ThaiPayment_Date = new utility().getThaiBirthDay(bank_data.Payment_Date);
bank_data.Degree_Level = bank_data.Paymenty_ID.Substring(0, 1);
degree_data = new DegreeAdmission().getDegreeAdmission(bank_data.Degree_Level);
bank_data.Degree_Char = degree_data.Degree_Char;
bank_data.Degree_ThaiName = degree_data.Degree_Thai;
bank_data.DueDate = rowData["DUE_DATE"].ToString();
bank_data.ThaiDueDate = new utility().getThaiBirthDay(bank_data.DueDate);
bank_data.SumDate = rowData["BANK_SUMDATE"].ToString();
bank_data.ThaiSumDate = new utility().getThaiBirthDay(bank_data.SumDate);
bank_data.Status = rowData["STATUS"].ToString();
}
return(bank_data);
}
public DegreeData GetData(uint id)
{
if (dataTable == null)
{
return(null);
}
DegreeData degreeData = dataTable.Get(id);
if (degreeData == null)
{
Log.TableError(this, id);
degreeData = new DegreeData();
degreeData.name = Log.NON_DATA_NAME;
}
return(degreeData);
}
protected void btnSAVE_Click(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.admin_university) || autro_obj.CheckGroupUser(login_data, group_var.admin_faculty))
{
/*=============================*/
string sql = "Select * From DEGREE_ADMISSION Where DEGREE_CODE='" + txtDEGREE_CODE.Text + "'";
List <DegreeData> chkDup = new DegreeAdmission().getDegreeAdmissionManual(sql);
if (chkDup.Count > 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowBox", "alert('รหัสระดับการศึกษาซ้ำ!');", true);
}
else
{
DegreeData data = new DegreeData();
data.Degree_Code = txtDEGREE_CODE.Text;
data.Degree_Thai = txtDEGREE_THAI.Text;
data.Degree_Eng = txtDEGREE_ENG.Text;
data.Degree_Char = txtDEGREE_CHAR.Text;
string result = "";
result = new DegreeAdmission().insertDegreeAdmission(data);
if (result == "OK")
{
Response.Redirect("list_Degree_Admission.aspx");
}
}
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
public DegreeData getDegreeChar(string Degree_Char)
{
DegreeData Degree_data = new DegreeData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From DEGREE_CHAR Where DEGREE_CHAR_CODE='" + Degree_Char + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
Degree_data.Degree_Thai = rowData["DEGREE_THAI"].ToString();
Degree_data.Degree_Eng = rowData["DEGREE_ENG"].ToString();
Degree_data.Degree_Char = rowData["DEGREE_CHAR_CODE"].ToString();
}
return(Degree_data);
}
public List <DegreeData> getDegreeChar()
{
List <DegreeData> Degree_data = new List <DegreeData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From DEGREE_CHAR Order By ORDER_FIELD";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
DegreeData Degree = new DegreeData();
Degree.Degree_Thai = rowData["DEGREE_THAI"].ToString();
Degree.Degree_Eng = rowData["DEGREE_ENG"].ToString();
Degree.Degree_Char = rowData["DEGREE_CHAR_CODE"].ToString();
Degree_data.Add(Degree);
}
return(Degree_data);
}
//Pongsarun 26/2/2016: use for config system
public List <DegreeData> getDegreeAdmissionManual(string sql)
{
List <DegreeData> Degree_data = new List <DegreeData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
DegreeData Degree = new DegreeData();
Degree.Degree_Code = rowData["DEGREE_CODE"].ToString();
Degree.Degree_Thai = rowData["DEGREE_THAI"].ToString();
Degree.Degree_Eng = rowData["DEGREE_ENG"].ToString();
Degree.Degree_Char = rowData["DEGREE_CHAR"].ToString();
Degree_data.Add(Degree);
}
return(Degree_data);
}
// V 1.0.0
public List <BankData> getBankData_AllDegree(string selected_date)
{
List <BankData> bankData = new List <BankData>();
string sql = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
sql = "Select * From BANK_DATA Where BANK_SUMDATE = '" + selected_date + "' ";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
BankData bank_data = new BankData();
DegreeData degree_data = new DegreeData();
bank_data.Amount = rowData["AMOUNT"].ToString().ToCharArray();
bank_data.BankCode = rowData["BANK_CODE"].ToString().ToCharArray();
bankcode_data = bankcodeObj.getBankCode(new string(bank_data.BankCode));
bank_data.Bank_ShortName = bankcode_data.Bank_ShortName;
bank_data.Bank_ThaiName = bankcode_data.Bank_ThaiName;
bank_data.TrancCode = rowData["TRANSACTION_CODE"].ToString().ToCharArray();
bank_data.Student_Name = rowData["STUDENT_NAME"].ToString();
bank_data.Student_ID = rowData["STUDENT_ID"].ToString();
bank_data.Nation_Passport_ID = rowData["NATION_PASSPORT_ID"].ToString();
bank_data.AcademicYear = rowData["ACADEMIC_YEAR"].ToString();
bank_data.Semester = rowData["SEMESTER"].ToString();
bank_data.Paymenty_ID = rowData["PAYMENT_ID"].ToString();
bank_data.Payment_Date = rowData["PAYMENT_DATE"].ToString();
bank_data.Payment_Time = rowData["PAYMENT_TIME"].ToString();
bank_data.ThaiPayment_Date = new utility().getThaiBirthDay(bank_data.Payment_Date);
bank_data.Degree_Level = bank_data.Paymenty_ID.Substring(0, 1);
degree_data = new DegreeAdmission().getDegreeAdmission(bank_data.Degree_Level);
bank_data.Degree_Char = degree_data.Degree_Char;
bank_data.Degree_ThaiName = degree_data.Degree_Thai;
bank_data.DueDate = rowData["DUE_DATE"].ToString();
bank_data.ThaiDueDate = new utility().getThaiBirthDay(bank_data.DueDate);
bank_data.SumDate = rowData["BANK_SUMDATE"].ToString();
bank_data.ThaiSumDate = new utility().getThaiBirthDay(bank_data.SumDate);
bank_data.Status = rowData["STATUS"].ToString();
bankData.Add(bank_data);
}
sql = "Select * From GRAD_BANK_DATA Where BANK_SUMDATE = '" + selected_date + "' ";
oracleObj.SelectCommand = sql;
DataView allData2 = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData2)
{
BankData bank_data = new BankData();
DegreeData degree_data = new DegreeData();
bank_data.Amount = rowData["AMOUNT"].ToString().ToCharArray();
bank_data.BankCode = rowData["BANK_CODE"].ToString().ToCharArray();
bankcode_data = bankcodeObj.getBankCode(new string(bank_data.BankCode));
bank_data.Bank_ShortName = bankcode_data.Bank_ShortName;
bank_data.Bank_ThaiName = bankcode_data.Bank_ThaiName;
bank_data.TrancCode = rowData["TRANSACTION_CODE"].ToString().ToCharArray();
bank_data.Student_Name = rowData["STUDENT_NAME"].ToString();
bank_data.Student_ID = rowData["STUDENT_ID"].ToString();
bank_data.Nation_Passport_ID = rowData["NATION_PASSPORT_ID"].ToString();
bank_data.AcademicYear = rowData["ACADEMIC_YEAR"].ToString();
bank_data.Semester = rowData["SEMESTER"].ToString();
bank_data.Paymenty_ID = rowData["PAYMENT_ID"].ToString();
bank_data.Payment_Date = rowData["PAYMENT_DATE"].ToString();
bank_data.ThaiPayment_Date = new utility().getThaiBirthDay(bank_data.Payment_Date);
bank_data.Degree_Level = bank_data.Paymenty_ID.Substring(0, 1);
degree_data = new DegreeAdmission().getDegreeAdmission(bank_data.Degree_Level);
bank_data.Degree_Char = degree_data.Degree_Char;
bank_data.Degree_ThaiName = degree_data.Degree_Thai;
bank_data.DueDate = rowData["DUE_DATE"].ToString();
bank_data.ThaiDueDate = new utility().getThaiBirthDay(bank_data.DueDate);
bank_data.SumDate = rowData["BANK_SUMDATE"].ToString();
bank_data.ThaiSumDate = new utility().getThaiBirthDay(bank_data.SumDate);
bank_data.Status = rowData["STATUS"].ToString();
bankData.Add(bank_data);
}
return(bankData);
}
// V 1.0.0
private void setBankData()
{
int start = 0;
int dataLength = charData.Length;
if (charData[start] == 'H')
{
Array.Copy(charData, start + 0, head_data.RecType, 0, 1);
Array.Copy(charData, start + 1, head_data.SeqNo, 0, 6);
Array.Copy(charData, start + 7, head_data.BankCode, 0, 3);
Array.Copy(charData, start + 10, head_data.CompAccount, 0, 10);
Array.Copy(charData, start + 20, head_data.CompName, 0, 40);
Array.Copy(charData, start + 60, head_data.EffDate, 0, 8);
Array.Copy(charData, start + 68, head_data.ServiceCode, 0, 8);
bankcode_data = bankcodeObj.getBankCode(new string(head_data.BankCode));
head_data.Bank_ShortName = bankcode_data.Bank_ShortName;
head_data.Bank_ThaiName = bankcode_data.Bank_ThaiName;
head_data.Bank_SummaryDate = convertPaymentdate(head_data.EffDate);
DegreeData degree_data = new DegreeData();
DegreeAdmission degreeObj = new DegreeAdmission();
start += 258;
if (charData[start] == 'D')
{
for (int offset = start; offset < dataLength; offset = offset + 258)
{
if (charData[offset] == 'D')
{
BankData bank_data = new BankData();
numOfData++;
Array.Copy(charData, offset + 0, bank_data.RecType, 0, 1);
Array.Copy(charData, offset + 1, bank_data.SeqNo, 0, 6);
Array.Copy(charData, offset + 7, bank_data.BankCode, 0, 3);
Array.Copy(charData, offset + 10, bank_data.CompAccount, 0, 10);
Array.Copy(charData, offset + 20, bank_data.PayDate, 0, 8);
Array.Copy(charData, offset + 28, bank_data.PayTime, 0, 6);
Array.Copy(charData, offset + 34, bank_data.CustomerName, 0, 50);
Array.Copy(charData, offset + 84, bank_data.Ref1, 0, 20);
Array.Copy(charData, offset + 104, bank_data.Ref2, 0, 20);
Array.Copy(charData, offset + 124, bank_data.Ref3, 0, 20);
Array.Copy(charData, offset + 144, bank_data.BranNo, 0, 4);
Array.Copy(charData, offset + 148, bank_data.TellerNo, 0, 4);
Array.Copy(charData, offset + 152, bank_data.KindTranc, 0, 1);
Array.Copy(charData, offset + 153, bank_data.TrancCode, 0, 3);
Array.Copy(charData, offset + 156, bank_data.CheqNo, 0, 7);
Array.Copy(charData, offset + 163, bank_data.Amount, 0, 13);
Array.Copy(charData, offset + 176, bank_data.CheqCode, 0, 3);
bankcode_data = bankcodeObj.getBankCode(new string(bank_data.BankCode));
bank_data.Bank_ShortName = bankcode_data.Bank_ShortName;
bank_data.Bank_ThaiName = bankcode_data.Bank_ThaiName;
bank_data.Student_ID = new string(bank_data.Ref1, 0, 13);
//bank_data.Nation_ID = new string(bank_data.Ref1,0,13);
//bank_data.Passport_ID = new string(bank_data.Ref1,0, 13);
bank_data.AcademicYear = "25" + new string(bank_data.Ref1, 13, 2);
bank_data.Semester = new string(bank_data.Ref1, 15, 1);
bank_data.Degree_Level = new string(bank_data.Ref2, 0, 1);
bank_data.Paymenty_ID = new string(bank_data.Ref2, 0, 10);
bank_data.Payment_Date = convertPaymentdate(bank_data.PayDate);
bank_data.Payment_Time = new string(bank_data.PayTime);
bank_data.ThaiPayment_Date = thaipaymentdate(bank_data.PayDate);
bank_data.Money = new string(bank_data.Amount).TrimStart('0');
bank_data.Money = String.Format("{0:#,###,###.00}", Convert.ToDecimal(bank_data.Money) / 100);
degree_data = degreeObj.getDegreeAdmission(bank_data.Degree_Level);
bank_data.Degree_Char = degree_data.Degree_Char;
bank_data.Degree_ThaiName = degree_data.Degree_Thai;
char[] tmpduedate = new char[6];
Array.Copy(bank_data.Ref2, 10, tmpduedate, 0, 6);
bank_data.DueDate = convertDuedate(tmpduedate);
bank_data.ThaiDueDate = thaiduedate(tmpduedate);
bankData.Add(bank_data);
}
}
}
else
{
ErrorResponse = "No Data Section";
}
}
else
{
ErrorResponse = "No Head Section";
}
}
public IHttpActionResult Delete(DegreeModel degree)
{
var consulta = DegreeData.Eliminar(degree.DegreeId);
return(Ok(consulta));
}
public IHttpActionResult ShowUpdate([FromBody] DegreeModel degree)
{
var consulta = DegreeData.MostrarUpdate(degree.DegreeId);
return(Ok(consulta));
}