public string insertCashData(CashData insertData, string degree_char)
{
string response2 = "";
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Insert Into CASH_DATA(ACADEMIC_YEAR,SEMESTER,PAYMENT_ID,STUDENT_ID,NATION_ID,PASSPORT_ID,STUDENT_NAME,AMOUNT,DUE_DATE,PAYMENT_DATE,PAYMENT_TIME,RECEIVE_BY,STATUS) Values('" + insertData.AcademicYear + "','" + insertData.Semester + "','" + insertData.Payment_ID + "','" + insertData.Student_ID + "','" + insertData.Nation_ID + "','" + insertData.Passport_ID + "','" + insertData.Student_Name + "'," + insertData.Amount + ",'" + insertData.DueDate + "','" + insertData.Payment_Date + "','" + insertData.Payment_Time + "','" + insertData.Receive_by + "','" + insertData.Status + "')";
oracleObj.InsertCommand = sql;
try
{
if (oracleObj.Insert() == 1)
{
// อัพเดทสถานะใบ Payment
response2 = new Student_Payment().updatePayment(insertData.Payment_ID, insertData.Payment_Date, new Status_Variable().PaymentComplete, degree_char);
// ========
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
}
return(response);
}
public ActionResult DeleteConfirmed(int id)
{
Student_Payment student_Payment = db.Student_Payment.Find(id);
db.Student_Payment.Remove(student_Payment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Student_Id,Subject_Id,First_Installment,Second_Installment,Status")] Student_Payment student_Payment)
{
if (ModelState.IsValid)
{
db.Entry(student_Payment).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student_Payment));
}
public ActionResult Create([Bind(Include = "Id,Student_Id,Subject_Id,First_Installment,Second_Installment,Status")] Student_Payment student_Payment)
{
if (ModelState.IsValid)
{
db.Student_Payment.Add(student_Payment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student_Payment));
}
// GET: Student_Payment/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Student_Payment student_Payment = db.Student_Payment.Find(id);
if (student_Payment == null)
{
return(HttpNotFound());
}
return(View(student_Payment));
}
// V 1.0.0
public string[] insertQualifiedSTD_BankData(BankHead bank_head, List <BankData> bankData)
{
string TableName = "";
string[] response = new string[bankData.Count];
string comp_account = new string(bank_head.CompAccount);
string comp_name = new string(bank_head.CompName).Replace("'", "`");
string summary_date = bank_head.Bank_SummaryDate;
Status_Variable status_var = new Status_Variable();
SystemConfigData system_config = new SystemConfigData();
system_config = new SystemConfig().getConfig();
int i = 0;
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
foreach (BankData field in bankData)
{
TableName = getTableName(field.Degree_Char);
int bank_amount = Convert.ToInt32(new string(field.Amount));
bank_amount = bank_amount / 100;
string regis_type = new Student_Payment().getPayment(field.Paymenty_ID, field.Degree_Char).Reg_Type;
if (regis_type == "NW")
{
oracleObj.InsertCommand = "Insert Into " + TableName + " (PAYMENT_ID,PAYMENT_DATE,COMPANY_AC,COMPANY_NAME,BANK_CODE,BRANCH_CODE,TELLER_NO,NATION_PASSPORT_ID,STUDENT_NAME,ACADEMIC_YEAR,SEMESTER,AMOUNT,KIND_TRANSACTION,TRANSACTION_CODE,DUE_DATE,IMPORT_DATE,STATUS,PAYMENT_TIME,BANK_SUMDATE) Values('" + field.Paymenty_ID + "','" + field.Payment_Date + "','" + comp_account + "','" + comp_name + "','" + new string(field.BankCode) + "','" + new string(field.BranNo) + "','" + new string(field.TellerNo) + "','" + field.Student_ID + "','" + new string(field.CustomerName) + "','" + field.AcademicYear + "','" + field.Semester + "'," + Convert.ToSingle(bank_amount) + ",'" + new string(field.KindTranc) + "','" + new string(field.TrancCode) + "','" + field.DueDate + "','" + field.ImportDate + "','" + field.Status + "','" + new string(field.PayTime) + "','" + summary_date + "')";
}
else
{
oracleObj.InsertCommand = "Insert Into " + TableName + " (PAYMENT_ID,PAYMENT_DATE,COMPANY_AC,COMPANY_NAME,BANK_CODE,BRANCH_CODE,TELLER_NO,STUDENT_ID,STUDENT_NAME,ACADEMIC_YEAR,SEMESTER,AMOUNT,KIND_TRANSACTION,TRANSACTION_CODE,DUE_DATE,IMPORT_DATE,STATUS,PAYMENT_TIME,BANK_SUMDATE) Values('" + field.Paymenty_ID + "','" + field.Payment_Date + "','" + comp_account + "','" + comp_name + "','" + new string(field.BankCode) + "','" + new string(field.BranNo) + "','" + new string(field.TellerNo) + "','" + field.Student_ID + "','" + new string(field.CustomerName) + "','" + field.AcademicYear + "','" + field.Semester + "'," + Convert.ToSingle(bank_amount) + ",'" + new string(field.KindTranc) + "','" + new string(field.TrancCode) + "','" + field.DueDate + "','" + field.ImportDate + "','" + field.Status + "','" + new string(field.PayTime) + "','" + summary_date + "')";
}
try
{
if (oracleObj.Insert() == 1)
{
response[i] = "OK";
// อัพเดทตาราง Payment
if ((field.Status == status_var.BankData_Accurate) || (field.Status == status_var.BankData_Accurate_OverPaid))
{
//นักศึกษาใหม่
if (regis_type == "NW")
{
Qualified_Student_Payment std_payment = new Qualified_Student_Payment();
string res_update = std_payment.updatePayment(field.Paymenty_ID, field.Payment_Date, status_var.QualifiedStudent_PaymentComplete, field.Degree_Char);
// Generate Student_ID
if (res_update == "OK")
{
GenStudentID gen_student_id = new GenStudentID();
PaymentData payment_data = std_payment.getPayment(field.Paymenty_ID, field.Degree_Char);
// List<StudentIDConfigData> configData = new List<StudentIDConfigData>();
Qualified_Student student_data = new Qualified_Student().getQualifiedStudent(payment_data.Academic_Year, payment_data.Semester, payment_data.Nation_ID, payment_data.Passport_ID, payment_data.Curr_Code, payment_data.Round_Paid, field.Degree_Char);
if (payment_data.Reg_Type == "NW")
{
string academic_year = student_data.Year_Admission.Substring(2, 2);
string faculty_code = student_data.Faculty_Code;
string department_code = student_data.Department_Code_StudentID;
string major_code = student_data.Major_Code_StudentID;
string degree_code = student_data.Degree_Admission;
string admission_type = student_data.Admission_Type;
string project_code = student_data.Project_Code;
string new_student_id = gen_student_id.getStudentID(student_data);
if (new_student_id.Length == 13)
{
// Update Student ID ตารางนักศึกษาใหม่
string update_status = new Qualified_Student().updateQualifiedStudent_ID(student_data.Year_Admission, student_data.Semester_Admission, student_data.Nation_ID, student_data.Passport_ID, student_data.Curri_Code, student_data.Round_Paid, new_student_id, field.Degree_Char);
// Update ตารางลงทะเบียน
new Qualified_Student_Registration().updateRegistrationStudentID(system_config.AcademicYear, system_config.Semester, student_data.Nation_ID, student_data.Passport_ID, student_data.Curri_Code, student_data.Project_Code, new_student_id, field.Degree_Char);
// Update ตารางประวัติการลงทะเบียน
new HistoryUpdate().update_HisRegistrationStudentID(system_config.AcademicYear, system_config.Semester, student_data.Nation_ID, student_data.Passport_ID, new_student_id, field.Degree_Char);
// Update ตารางใบชำระเงิน
std_payment.updatePayment_StudentID(field.Paymenty_ID, new_student_id, field.Degree_Char);
}
}
}
}
// นักศึกษาปัจจุบันท์
else
{
Student_Payment std_payment = new Student_Payment();
string res_update = std_payment.updatePayment(field.Paymenty_ID, field.Payment_Date, status_var.PaymentComplete, field.Degree_Char);
}
}
}
}
catch (Exception e)
{
response[i] = e.Message.ToString();
}
i++;
} // end foreach
return(response);
}
