//Pongsarun 26/9/2015: use for config system public string insertOffice(OfficeData dataInsert) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Insert Into OFFICE(OFFICE_CODE, OFFICE_THAINAME, OFFICE_ENGNAME, OFFICE_SHORTNAME, CAMPUS_CODE, OFFICE_STATUS) Values('" + dataInsert.Office_Code + "','" + dataInsert.Office_Thai + "','" + dataInsert.Office_Eng + "','" + dataInsert.Office_ShortName + "','" + dataInsert.Office_CampusCode + "','" + dataInsert.Office_Status + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); } return(response); }
public void Add([FromForm] OfficeData info) { ArbolB <OfficeData> .IniciarArbol("Office", new StringToObject(OfficeData.StringToObject), new ObjectToString(OfficeData.ObjectToString)); SDES.obtainKey(); ArbolB <OfficeData> .InsertarArbol(new OfficeData { ID = ArbolB <OfficeData> .newID(), Name = info.Name, Address = info.Address }); }
public void Alter([FromForm] OfficeData info) { SDES.obtainKey(); ArbolB <OfficeData> .IniciarArbol("Office", new StringToObject(OfficeData.StringToObject), new ObjectToString(OfficeData.ObjectToString)); ArbolB <OfficeData> .Modificar(info, new string[2] { info.Name, info.Address }, new Modify(OfficeData.Alter)); }
// Wakamatsu private void editSender(PublishData pd, int stRow, int stCol) { OfficeData od = new OfficeData(); od = od.SelectOfficeData(pd.OfficeCode); if (od == null) { return; } oWSheet.Cell(stRow, stCol).Value = od.Address; //oWSheet.Cell( stRow+1, stCol ).Value = "フタバコンサルタント株式会社 " + pd.OfficeName + "支店"; oWSheet.Cell(stRow + 1, stCol).Value = "フタバコンサルタント株式会社 "; if (pd.PublishOffice == 0) { oWSheet.Cell(stRow + 1, stCol).Value += pd.OfficeName + "支店"; } oWSheet.Cell(stRow + 2, stCol).Value = od.Title + " " + od.MemberName; oWSheet.Cell(stRow + 3, stCol).Value = "TEL " + od.TelNo + "(代) FAX " + od.FaxNo; }
public OfficeData getOffice(String Office_Code) { OfficeData Office_data = new OfficeData(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = "Select * From OFFICE Where OFFICE_CODE='" + Office_Code + "'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { Office_data.Office_Code = rowData["OFFICE_CODE"].ToString(); Office_data.Office_Thai = rowData["OFFICE_THAINAME"].ToString(); Office_data.Office_Eng = rowData["OFFICE_ENGNAME"].ToString(); Office_data.Office_ShortName = rowData["OFFICE_SHORTNAME"].ToString(); Office_data.Office_CampusCode = rowData["CAMPUS_CODE"].ToString(); Office_data.Office_Status = rowData["OFFICE_STATUS"].ToString(); } return(Office_data); }
public string updateOffice(OfficeData updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "UPDATE OFFICE SET OFFICE_THAINAME = '" + updateData.Office_Thai + "', OFFICE_ENGNAME = '" + updateData.Office_Eng + "', OFFICE_SHORTNAME = '" + updateData.Office_ShortName + "', CAMPUS_CODE = '" + updateData.Office_CampusCode + "', OFFICE_STATUS = '" + updateData.Office_Status + "' WHERE OFFICE_CODE = '" + updateData.Office_Code + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString() + " "; } return(response); }
protected override void Seed(BeerTap.DataPersistance.BeerTapDbContext context) { OfficeData office1 = new OfficeData() { OfficeName = "Vancouver", OfficeInfos = new List <OfficeInfoData>() { new OfficeInfoData() { OfficeId = 1, Beertype = "Molson", Milliliter = 2365 }, new OfficeInfoData() { OfficeId = 1, Beertype = "Labatt", Milliliter = 2365 } } }; OfficeData office2 = new OfficeData() { OfficeName = "Regina", OfficeInfos = new List <OfficeInfoData>() { new OfficeInfoData() { OfficeId = 2, Beertype = "Sleeman", Milliliter = 2365 }, new OfficeInfoData() { OfficeId = 2, Beertype = "Moosehead", Milliliter = 2365 } } }; OfficeData office3 = new OfficeData() { OfficeName = "Winnipeg", OfficeInfos = new List <OfficeInfoData>() { new OfficeInfoData() { OfficeId = 3, Beertype = "Bud Light", Milliliter = 2365 }, new OfficeInfoData() { OfficeId = 3, Beertype = "Busch", Milliliter = 2365 } } }; OfficeData office4 = new OfficeData() { OfficeName = "Davidson (NC)", OfficeInfos = new List <OfficeInfoData>() { new OfficeInfoData() { OfficeId = 4, Beertype = "Bass", Milliliter = 2365 } } }; OfficeData office5 = new OfficeData() { OfficeName = "Manila Philippines", OfficeInfos = new List <OfficeInfoData>() { new OfficeInfoData() { OfficeId = 5, Beertype = "Red Horse", Milliliter = 2365 } } }; OfficeData office6 = new OfficeData() { OfficeName = "Sydney Australia", OfficeInfos = new List <OfficeInfoData>() { new OfficeInfoData() { OfficeId = 6, Beertype = "Heineken", Milliliter = 2365 } } }; context.Offices.Add(office1); context.Offices.Add(office2); context.Offices.Add(office3); context.Offices.Add(office4); context.Offices.Add(office5); context.Offices.Add(office6); base.Seed(context); }