protected void btnSAVE_Click(object sender, EventArgs e)
{
string sql = "Select * From CAMPUS Where CAMPUS_CODE='" + txtCAMPUS_CODE.Text + "'";
List <CampusData> chkDup = new Campus().getCampusManual(sql);
if (chkDup.Count > 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowBox", "alert('รหัสวิทยาเขตซ้ำ!');", true);
}
else
{
CampusData data = new CampusData();
data.Campus_Code = txtCAMPUS_CODE.Text;
data.Campus_Thai = txtCAMPUS_THAINAME.Text;
data.Campus_Eng = txtCAMPUS_ENGNAME.Text;
data.Campus_Status = ddlCAMPUS_STATUS.SelectedValue;
string result = "";
result = new Campus().insertCampus(data);
if (result == "OK")
{
Response.Redirect("list_Campus.aspx");
}
}
}
public CampusData getCampus(String Campus_Code)
{
string response = "";
CampusData Campus_data = new CampusData();
ConnectDB db = new ConnectDB();
try
{
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From CAMPUS Where CAMPUS_CODE='" + Campus_Code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
Campus_data.Campus_Code = rowData["CAMPUS_CODE"].ToString();
Campus_data.Campus_Thai = rowData["CAMPUS_THAINAME"].ToString();
Campus_data.Campus_Eng = rowData["CAMPUS_ENGNAME"].ToString();
Campus_data.Campus_Status = rowData["CAMPUS_STATUS"].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(Campus_data);
}
public string insertCampus(CampusData dataInsert)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Insert Into CAMPUS(CAMPUS_CODE, CAMPUS_THAINAME, CAMPUS_ENGNAME, CAMPUS_STATUS) Values('" + dataInsert.Campus_Code + "','" + dataInsert.Campus_Thai + "','" + dataInsert.Campus_Eng + "','" + dataInsert.Campus_Status + "')";
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:Insert Campus" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
public string updateCampus(CampusData updateData)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Update CAMPUS Set CAMPUS_THAINAME = '" + updateData.Campus_Thai + "', CAMPUS_ENGNAME='" + updateData.Campus_Eng + "', CAMPUS_STATUS='" + updateData.Campus_Status + "' Where CAMPUS_CODE='" + updateData.Campus_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:Update Campus" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
private void Load(CampusData c)
{
Init();
if (c != null)
{
CampusService campusService = new CampusService(new Rock.Data.RockContext());
Rock.Model.Campus RockCampus = campusService.Get(c.campus_id);
Id = RockCampus.Id;
CreatedDateTime = RockCampus.CreatedDateTime;
ModifiedDateTime = RockCampus.ModifiedDateTime;
CreatedByPersonAliasId = RockCampus.CreatedByPersonAliasId;
ModifiedByPersonAliasId = RockCampus.ModifiedByPersonAliasId;
Guid = RockCampus.Guid;
Name = RockCampus.Name;
LeaderPersonAliasId = RockCampus.LeaderPersonAliasId;
LocationId = RockCampus.LocationId;
CompanyID = c.campus_company_id;
FundID = c.campus_fund_id;
XrefDateCreated = c.date_created;
XrefCreatedBy = c.created_by;
XrefDateModified = c.date_modified;
XrefModifiedBy = c.modified_by;
XrefActive = c.active;
}
}
public void Delete(int campusID, string userName)
{
try
{
if (campusID <= 0)
{
throw new ArgumentNullException("CampusID", "CampusID is required.");
}
if (String.IsNullOrEmpty(userName))
{
throw new ArgumentNullException("User Name", "User Name is required");
}
Campus OriginalCampus = new Campus(this.Id);
using (PurchasingContext context = ContextHelper.GetDBContext())
{
CampusData d = context.CampusDatas.Where(c => c.campus_id == this.Id).FirstOrDefault();
context.CampusDatas.DeleteOnSubmit(d);
context.SubmitChanges();
}
SaveHistory(null, HistoryType.DELETE, userName);
}
catch (Exception ex)
{
throw new CampusException("An error has occurred while deleting Purchasing Campus", ex);
}
}
protected void btnSAVE_Click(object sender, EventArgs e)
{
CampusData saveData = new CampusData();
saveData.Campus_Code = txtCAMPUS_CODE.Text;
saveData.Campus_Thai = txtCAMPUS_THAINAME.Text;
saveData.Campus_Eng = txtCAMPUS_ENGNAME.Text;
saveData.Campus_Status = ddlCAMPUS_STATUS.SelectedValue;
string result = "";
try
{
result = new Campus().updateCampus(saveData);
if (result == "OK")
{
Response.Redirect("list_Campus.aspx");
}
else
{
Response.Redirect("list_Campus.aspx");
}
}
catch (Exception E)
{
//string response = E.Message.ToString();
//HttpContext.Current.Session["response"] = "Unit Test: " + response;
//HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
public void Save(string userName)
{
try
{
Dictionary <string, string> ValErrors = Validate();
if (ValErrors.Count > 0)
{
throw new CampusNotValidException("Campus is not valid", ValErrors);
}
using (PurchasingContext context = ContextHelper.GetDBContext())
{
CampusData Data;
if (XrefDateCreated > DateTime.MinValue)
{
Data = context.CampusDatas.Where(x => x.campus_id == Id).FirstOrDefault();
Data.campus_company_id = CompanyID;
Data.campus_fund_id = FundID;
Data.date_modified = DateTime.Now;
Data.modified_by = userName;
Data.active = XrefActive;
context.CampusDatas.InsertOnSubmit(Data);
}
else
{
Data = new CampusData();
Data.campus_id = Id;
Data.campus_company_id = CompanyID;
Data.campus_fund_id = FundID;
Data.date_created = DateTime.Now;
Data.created_by = userName;
Data.date_modified = DateTime.Now;
Data.modified_by = userName;
Data.active = XrefActive;
}
context.SubmitChanges();
Load(Data.campus_id);
}
}
catch (Exception ex)
{
throw new CampusException("An error has occurred while saving campus.", ex);
}
}
//Pongsarun 26/2/2016: use for config system
public List <CampusData> getCampusManual(string sql)
{
List <CampusData> Campus_data = new List <CampusData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
CampusData Campus = new CampusData();
Campus.Campus_Code = rowData["CAMPUS_CODE"].ToString();
Campus.Campus_Thai = rowData["CAMPUS_THAINAME"].ToString();
Campus.Campus_Eng = rowData["CAMPUS_ENGNAME"].ToString();
Campus.Campus_Status = rowData["CAMPUS_STATUS"].ToString();
Campus_data.Add(Campus);
}
return(Campus_data);
}
public Campus(CampusData c)
{
Load(c);
}
