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); }