protected override OpResult _Delete(ItemAddOn _obj)
{
if (Exists(_obj))
{
DbDeleteStatement clause = DbMgr.CreateDeleteClause();
clause.DeleteFrom("ItemAddOn").Criteria
.IsEqual("ItemAddOn", "ItemAddOnID", _obj.ItemAddOnID);
DbMgr.ExecuteNonQuery(clause);
return(OpResult.NotifyDeleteAction(OpResult.ResultStatus.ExistsAndDeleted, _obj));
}
return(OpResult.NotifyDeleteAction(OpResult.ResultStatus.NotExists, _obj, "ItemAddOn object does not exists"));
}
protected override OpResult _Store(ItemAddOn _obj)
{
if (_obj == null)
{
return(OpResult.NotifyStoreAction(OpResult.ResultStatus.ObjectIsNull, _obj, "ItemAddOn object cannot be created as it is null"));;
}
if (Exists(_obj))
{
ExecuteNonQuery(GetQuery_UpdateQuery(_obj));
return(OpResult.NotifyStoreAction(OpResult.ResultStatus.Updated, _obj));
}
ExecuteNonQuery(GetQuery_InsertQuery(_obj));
if (_obj.ItemAddOnID == null)
{
_obj.ItemAddOnID = DbMgr.GetLastInsertID();
}
_obj.FromDb = true;
return(OpResult.NotifyStoreAction(OpResult.ResultStatus.Created, _obj));
}
private void TriggerAccess_BackupToCloud()
{
Accountant curr_acc = mApplicationController.mAccountant;
if (chkBackupItemAddOn.Checked)
{
IList <ItemAddOn> CurrItemAddOns = curr_acc.ItemAddOnMgr.FindAllCollection();
int itemCount = CurrItemAddOns.Count;
StringBuilder sb = new StringBuilder();
sb.Append("backup=ItemAddOn");
sb.AppendFormat("&count={0}", itemCount);
string cloudUID = txtCloudUID.Text.Trim();
if (string.IsNullOrEmpty(cloudUID))
{
sb.AppendFormat("&uid={0}", NetUtil.UrlEncode(cloudUID));
}
string cloudPWD = txtCloudPWD.Text.Trim();
if (string.IsNullOrEmpty(cloudPWD))
{
sb.AppendFormat("&pwd={0}", NetUtil.UrlEncode(cloudPWD));
}
for (int i = 0; i < itemCount; ++i)
{
ItemAddOn _addon = CurrItemAddOns[i];
sb.AppendFormat("&brand[]={0}", NetUtil.UrlEncode(_addon.Brand));
sb.AppendFormat("&serial[]={0}", NetUtil.UrlEncode(_addon.SerialNumber));
sb.AppendFormat("&batch[]={0}", NetUtil.UrlEncode(_addon.BatchNumber));
sb.AppendFormat("&color[]={0}", NetUtil.UrlEncode(_addon.Color));
sb.AppendFormat("&expiry[]={0}", NetUtil.UrlEncode(_addon.ExpiryDate));
sb.AppendFormat("&gender[]={0}", NetUtil.UrlEncode(_addon.GenderID));
sb.AppendFormat("&itemsize[]={0}", NetUtil.UrlEncode(_addon.ItemSizeID));
}
string cloudUrl = txtCloudUrl.Text;
NetUtil.Instance.HttpPost(cloudUrl, sb.ToString());
}
}
public void RestoreItemAddOnFromCloud(Accountant curr_acc, string cloudUrl, string cloudUID, string cloudPWD)
{
IList <ItemAddOn> CurrItemAddOns = curr_acc.ItemAddOnMgr.FindAllCollection();
int itemCount = CurrItemAddOns.Count;
StringBuilder sb = new StringBuilder();
sb.Append("backup=ItemAddOn");
sb.AppendFormat("&count={0}", itemCount);
cloudUID = cloudUID.Trim();
if (string.IsNullOrEmpty(cloudUID))
{
sb.AppendFormat("&uid={0}", NetUtil.UrlEncode(cloudUID));
}
cloudPWD = cloudPWD.Trim();
if (string.IsNullOrEmpty(cloudPWD))
{
sb.AppendFormat("&pwd={0}", NetUtil.UrlEncode(cloudPWD));
}
for (int i = 0; i < itemCount; ++i)
{
ItemAddOn _addon = CurrItemAddOns[i];
sb.AppendFormat("&itemaddonid={0}", NetUtil.UrlEncode(_addon.ItemAddOnID));
sb.AppendFormat("&brand[]={0}", NetUtil.UrlEncode(_addon.Brand));
sb.AppendFormat("&serial[]={0}", NetUtil.UrlEncode(_addon.SerialNumber));
sb.AppendFormat("&batch[]={0}", NetUtil.UrlEncode(_addon.BatchNumber));
sb.AppendFormat("&color[]={0}", NetUtil.UrlEncode(_addon.Color));
sb.AppendFormat("&expiry[]={0}", NetUtil.UrlEncode(_addon.ExpiryDate));
sb.AppendFormat("&gender[]={0}", NetUtil.UrlEncode(_addon.GenderID));
sb.AppendFormat("&itemsizeid[]={0}", NetUtil.UrlEncode(_addon.ItemSizeID));
}
cloudUrl = cloudUrl.Trim();
NetUtil.Instance.HttpPost(cloudUrl, sb.ToString());
}
private DbUpdateStatement GetQuery_UpdateQuery(ItemAddOn _obj)
{
return(DbMgr.CreateUpdateClause("ItemAddOn", GetFields(_obj), "ItemAddOnID", _obj.ItemAddOnID));
}
private DbInsertStatement GetQuery_InsertQuery(ItemAddOn _obj)
{
Dictionary <string, DbFieldEntry> fields = GetFields(_obj);
return(DbMgr.CreateInsertClause("ItemAddOn", fields));
}
