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