public void GetTest()
{
Init();
var kaisha = ServiceKaisha.Get();
Assert.IsNull(kaisha);
kaisha = new ModelKaisha()
{
Kaishamei = "株式会社IOT",
Yuubin = "999-9999",
Juusho1 = "東京都北区○○町○○丁目-3-1",
JishaYoushasakiCd = "0001",
Kinyuukikanmei1 = "○○○○銀行",
Shitenmei1 = "○○○○支店",
YokinShumoku1 = "普通",
KouzaBangou1 = "9999999"
};
var registration = ServiceKaisha.Save(kaisha);
Assert.AreEqual(registration.AffectedRows, 1);
Assert.AreEqual(registration.ErrorMessage, string.Empty);
Assert.IsNull(registration.OccurredException);
var insertedKaisha = ServiceKaisha.Get();
Assert.IsNotNull(insertedKaisha);
Assert.AreEqual(insertedKaisha.Kaishamei, kaisha.Kaishamei);
Assert.AreEqual(insertedKaisha.Yuubin, kaisha.Yuubin);
Assert.AreEqual(insertedKaisha.Juusho1, kaisha.Juusho1);
Assert.AreEqual(insertedKaisha.Juusho2, kaisha.Juusho2);
Assert.AreEqual(insertedKaisha.Juusho3, kaisha.Juusho3);
Assert.AreEqual(insertedKaisha.Tel, kaisha.Tel);
Assert.AreEqual(insertedKaisha.Fax, kaisha.Fax);
Assert.AreEqual(insertedKaisha.JishaYoushasakiCd, kaisha.JishaYoushasakiCd);
Assert.AreEqual(insertedKaisha.Kinyuukikanmei1, kaisha.Kinyuukikanmei1);
Assert.AreEqual(insertedKaisha.Shitenmei1, kaisha.Shitenmei1);
Assert.AreEqual(insertedKaisha.YokinShumoku1, kaisha.YokinShumoku1);
Assert.AreEqual(insertedKaisha.KouzaBangou1, kaisha.KouzaBangou1);
}
/// <summary>
/// 会社基本情報を登録します。
/// </summary>
/// <param name="kaisha">会社基本情報</param>
/// <returns>登録処理の結果</returns>
public static RegistrationResult Save(ModelKaisha kaisha)
{
var registraion = new RegistrationResult();
using (var conn = Db.OpenConnection())
{
var tran = conn.BeginTransaction();
try
{
var beforeKaisha = Get();
if (beforeKaisha == null)
{
registraion.AffectedRows = conn.Execute(SqlInsertKaisha, kaisha, transaction: tran);
}
else
{
registraion.AffectedRows = conn.Execute(SqlUpdateKaisha, kaisha, transaction: tran);
}
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
registraion.SetError(ex.Message, ex);
}
}
return registraion;
}
