public ReturnType RemoveJournalAccount(string journalaccountCode)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*List<JournalAccount> list = alading.JournalAccount.Where(p => p.JournalAccountID == journalaccountID).ToList();*/
List <JournalAccount> list = alading.JournalAccount.Where(p => p.JournalAccountCode == journalaccountCode).ToList();
if (list.Count == 0)
{
return(ReturnType.NotExisted);
}
else
{
JournalAccount sy = list.First();
alading.DeleteObject(sy);
alading.SaveChanges();
return(ReturnType.Success);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType AddJournalAccount(JournalAccount journalaccount)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
alading.AddToJournalAccount(journalaccount);
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.PropertyExisted);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType UpdateJournalAccount(JournalAccount journalaccount)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*JournalAccount result = alading.JournalAccount.Where(p => p.JournalAccountID == journalaccount.JournalAccountID).FirstOrDefault();*/
JournalAccount result = alading.JournalAccount.Where(p => p.JournalAccountCode == journalaccount.JournalAccountCode).FirstOrDefault();
if (result == null)
{
return(ReturnType.NotExisted);
}
#region Using Attach() Function Update,Default USE;
alading.Attach(result);
alading.ApplyPropertyChanges("JournalAccount", journalaccount);
#endregion
#region Using All Items Replace To Update ,Default UnUse
/*
*
* result.time = journalaccount.time;
*
* result.money = journalaccount.money;
*
* result.type = journalaccount.type;
*
* result.person = journalaccount.person;
*
* result.memo = journalaccount.memo;
*
*/
#endregion
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
return(ReturnType.OthersError);
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType UpdateJournalAccount(string journalaccountCode, JournalAccount journalaccount)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*var result = alading.JournalAccount.Where(p => p.JournalAccountID == journalaccountID).ToList();*/
var result = alading.JournalAccount.Where(p => p.JournalAccountCode == journalaccountCode).ToList();
if (result.Count == 0)
{
return(ReturnType.NotExisted);
}
JournalAccount ob = result.First();
ob.time = journalaccount.time;
ob.money = journalaccount.money;
ob.type = journalaccount.type;
ob.person = journalaccount.person;
ob.memo = journalaccount.memo;
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.OthersError);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
public static ReturnType UpdateJournalAccount(string journalaccountCode, JournalAccount journalaccount)
{
return(DataProviderClass.Instance().UpdateJournalAccount(journalaccountCode, journalaccount));
}
public static ReturnType AddJournalAccount(JournalAccount journalaccount)
{
return(DataProviderClass.Instance().AddJournalAccount(journalaccount));
}
