public DataTable InvitehistorySelect(int inputUserId)
{
// ログインビジネスロジック用のDao（DataAccessObject)のインスタンス LoginDao を生成
ApplicationDao ApplicationDao = new ApplicationDao();
// Invite_history テーブルより入力したユーザーの招待履歴の数を取得
return(ApplicationDao.GetUserInviteHistory(inputUserId));
}
public void Changecoin(InviteHistoryEntity inviteEntity, int inviteusercoin)
{
// ログインビジネスロジック用のDao（DataAccessObject)のインスタンス LoginDao を生成
ApplicationDao ApplicationDao = new ApplicationDao();
// inviteEntityの値を元にコインの変更を行う
ApplicationDao.ChangeCoin(inviteEntity, inviteusercoin);
}
public DataTable Selects(int inviteid)
{
// ログインビジネスロジック用のDao（DataAccessObject)のインスタンス LoginDao を生成
ApplicationDao ApplicationDao = new ApplicationDao();
// LoginDao のログイン内容をデータベースに登録する処理 LoginInsertExecute へ loginEntity を渡し実行
return(ApplicationDao.GetUserTables(inviteid));
}
public DataTable LotterySelect(InviteHistoryEntity inviteEntity)
{
// ログインビジネスロジック用のDao（DataAccessObject)のインスタンス LoginDao を生成
ApplicationDao ApplicationDao = new ApplicationDao();
// LoginDao のログイン内容をデータベースに登録する処理 LoginInsertExecute へ loginEntity を渡し実行
return(ApplicationDao.GetLotteryHistory(inviteEntity));
}
public void LotteryRegistration(InviteHistoryEntity inviteEntity)
{
// 申し込みビジネスロジック用のDao（DataAccessObject)のインスタンス applicationDao を生成
ApplicationDao applicationDao = new ApplicationDao();
// applicationDao のアンケート結果をデータベースに登録する処理 ApplicationInsertExecute へ resultEntity を渡し実行
applicationDao.ApplicationInsertExecute(inviteEntity);
}
// 申し込み内容を登録するための処理を記述
public void LotteryRegistration(int id, int plize)
{
// 申し込みビジネスロジック用のDao（DataAccessObject)のインスタンス applicationDao を生成
ApplicationDao applicationDao = new ApplicationDao();
// applicationDao のアンケート結果をデータベースに登録する処理 ApplicationInsertExecute へ resultEntity を渡し実行
applicationDao.LotteryInsertExecute(id, plize);
}
public virtual void AppPrivilegeAdd(string appid, string appName, string appCode, string buaappid, string buaprivilege, string buaprivilegetext, string enablesync, string syncinterval)
{
if (buaprivilege == null)
{
buaprivilege = "";
}
AppPrivilegeDao dao = new AppPrivilegeDao(AppConfig.mainDbKey);
ApplicationDao appDao = new ApplicationDao(AppConfig.mainDbKey);
KeyValuePair <string, object> pk = new KeyValuePair <string, object>("name", appCode);
IList <KeyValuePair <string, object> > par = new List <KeyValuePair <string, object> >();
par.Add(pk);
Application application = appDao.Get(par);
int appPrivilegeid = application.PrivilegeID != null ? application.PrivilegeID.Value : 0;
AppPrivilege ap = null;
bool exists = dao.Exists(appPrivilegeid.ToString());
if (exists)
{
IList <KeyValuePair <string, object> > pars = new List <KeyValuePair <string, object> >();
KeyValuePair <string, object> p = new KeyValuePair <string, object>("id", appPrivilegeid);
pars.Add(p);
ap = dao.Get(pars);
ap.BuaAppCode = buaappid;
ap.BuaPrivilegeCode = buaprivilege;
ap.DisplayName = buaprivilegetext;
ap.EnableSync = enablesync == "ENABLE" ? true : false;
ap.SyncIntervalTime = String.IsNullOrEmpty(syncinterval) ? 0 : int.Parse(syncinterval);
dao.Update(ap);
}
else
{
ap = new AppPrivilege();
//ap.ID = int.Parse(appid);
ap.BuaAppCode = buaappid;
ap.BuaPrivilegeCode = buaprivilege;
ap.EnableSync = enablesync == "ENABLE" ? true : false;
ap.Name = appCode;
ap.DisplayName = buaprivilegetext;
ap.SyncIntervalTime = String.IsNullOrEmpty(syncinterval) ? 0 : int.Parse(syncinterval);
ap.SyncLastTime = DateTime.Now;
ap.SyncTime = DateTime.Now;
ap.CreateUid = "";
ap.CreateTime = DateTime.Now;
ap.UpdateTime = DateTime.Now;
ap.UpdateUid = "";
dao.Insert(ap);
}
if (application != null)
{
application.PrivilegeID = ap.ID;
appDao.Update(application);
}
}
public virtual void AppPrivilegeAdd(string appid, string appName, string appCode, string buaappid, string buaprivilege, string buaprivilegetext, string enablesync, string syncinterval)
{
if (buaprivilege == null)
buaprivilege = "";
AppPrivilegeDao dao = new AppPrivilegeDao(AppConfig.mainDbKey);
ApplicationDao appDao = new ApplicationDao(AppConfig.mainDbKey);
KeyValuePair<string, object> pk = new KeyValuePair<string, object>("name", appCode);
IList<KeyValuePair<string, object>> par = new List<KeyValuePair<string, object>>();
par.Add(pk);
Application application = appDao.Get(par);
int appPrivilegeid = application.PrivilegeID != null ? application.PrivilegeID.Value : 0;
AppPrivilege ap = null;
bool exists = dao.Exists(appPrivilegeid.ToString());
if (exists)
{
IList<KeyValuePair<string, object>> pars = new List<KeyValuePair<string, object>>();
KeyValuePair<string, object> p = new KeyValuePair<string, object>("id", appPrivilegeid);
pars.Add(p);
ap = dao.Get(pars);
ap.BuaAppCode = buaappid;
ap.BuaPrivilegeCode = buaprivilege;
ap.DisplayName = buaprivilegetext;
ap.EnableSync = enablesync == "ENABLE" ? true : false;
ap.SyncIntervalTime = String.IsNullOrEmpty(syncinterval) ? 0 : int.Parse(syncinterval);
dao.Update(ap);
}
else
{
ap = new AppPrivilege();
//ap.ID = int.Parse(appid);
ap.BuaAppCode = buaappid;
ap.BuaPrivilegeCode = buaprivilege;
ap.EnableSync = enablesync == "ENABLE" ? true : false;
ap.Name = appCode;
ap.DisplayName = buaprivilegetext;
ap.SyncIntervalTime = String.IsNullOrEmpty(syncinterval) ? 0 : int.Parse(syncinterval);
ap.SyncLastTime = DateTime.Now;
ap.SyncTime = DateTime.Now;
ap.CreateUid = "";
ap.CreateTime = DateTime.Now;
ap.UpdateTime = DateTime.Now;
ap.UpdateUid = "";
dao.Insert(ap);
}
if (application != null)
{
application.PrivilegeID = ap.ID;
appDao.Update(application);
}
}
private void _AddAction4Android(Package4AI package, SMC_PackageExt ext)
{
if (!String.IsNullOrEmpty(ext.pe_ApplicationCode))
{
string[] apps = ext.pe_ApplicationCode.Split(",".ToCharArray());
if (apps != null && apps.Length > 0)
{
ApplicationDao appDao = new ApplicationDao(AppConfig.mainDbKey);
App4AIDao app4AIDao = new App4AIDao(AppConfig.mainDbKey);
string TEMPPATH = Path.Combine(AppConfig.PackUploadFolder, "Temp");
int idx = 1;
Action4AndroidDao action4AndroidDao = new Action4AndroidDao(AppConfig.mainDbKey);
foreach (string appCode in apps)
{
if (String.IsNullOrEmpty(appCode))
{
continue;
}
List <KeyValuePair <string, object> > pars = new List <KeyValuePair <string, object> >();
pars.Add(new KeyValuePair <string, object>("[NAME]", appCode));
Application application = appDao.Get(pars);
//for (int activtyIndex = 0; activtyIndex < Convert.ToInt32(form["activityCount_" + appIndex.ToString()]); activtyIndex++)
//{
Action4Android action4Android = new Action4Android();
action4Android.Seq = idx; //Convert.ToInt32(form["ActivitySeq_" + appIndex.ToString() + "_" + activtyIndex.ToString()]);
action4Android.DisplayName = ""; //form["ActivityDisplayName_" + appIndex.ToString() + "_" + activtyIndex.ToString()];
action4Android.IsLaunch = true; //Convert.ToBoolean(form["ActivityLaunch_" + appIndex.ToString() + "_" + activtyIndex.ToString()]);
action4Android.IconUri = ""; //GetAndroidApplicationIcoUri(Path.Combine(TEMPPATH, package.DownloadUri), form["ActivityIco_" + appIndex.ToString() + "_" + activtyIndex.ToString()]);
action4Android.ShortName = ""; //form["ActivityShortName_" + appIndex.ToString() + "_" + activtyIndex.ToString()];
action4Android.Name = ""; //form["ActivityName_" + appIndex.ToString() + "_" + activtyIndex.ToString()];
action4Android.CreateTime = DateTime.Now;
action4Android.UpdateTime = DateTime.Now;
action4Android.CreateUid = ""; //CurrentUser.UserUId;
action4Android.UpdateUid = ""; //CurrentUser.UserUId;
action4AndroidDao.Insert(action4Android);
//}
++idx;
}
}
}
}
public virtual void UnAuthAppPrivilege(string id)
{
AppPrivilegeDao apdao = new AppPrivilegeDao(AppConfig.mainDbKey);
PrivilegeUserDao pudao = new PrivilegeUserDao(AppConfig.mainDbKey);
ApplicationDao appDao = new ApplicationDao(AppConfig.mainDbKey);
AppPrivilege appPrivilege = apdao.Get(id);
if (appPrivilege != null)
{
IList <Tuple <string, string, object> > _pars = new List <Tuple <string, string, object> >();
_pars.Add(new Tuple <string, string, object>("PrivilegeId", "=", appPrivilege.ID));
List <Application> applications = appDao.QueryList(_pars);
if (applications != null && applications.Count > 0)
{
foreach (Application app in applications)
{
app.PrivilegeID = null;
appDao.Update(app);
}
}
IList <Tuple <string, string, object> > pars = new List <Tuple <string, string, object> >();
pars.Add(new Tuple <string, string, object>("id", "=", appPrivilege.ID));
List <PrivilegeUser> privilegeUsers = pudao.QueryList(pars);
pudao.DeleteList(privilegeUsers);
apdao.Delete(appPrivilege);
//appPrivilege.BuaAppCode = "";
//appPrivilege.BuaPrivilegeCode = "";
//appPrivilege.DisplayName = "";
//appPrivilege.EnableSync = false;
//appPrivilege.SyncIntervalTime = 0;
//apdao.Update(appPrivilege);
}
}
/// <summary>
/// Initializes a new instance of the ApplicationSvc class by creating an instance of ApplicationDao class.
/// </summary>
public ApplicationSvc()
{
this.applicationDao = new ApplicationDao();
}
public virtual void UnAuthAppPrivilege(string id)
{
AppPrivilegeDao apdao = new AppPrivilegeDao(AppConfig.mainDbKey);
PrivilegeUserDao pudao = new PrivilegeUserDao(AppConfig.mainDbKey);
ApplicationDao appDao = new ApplicationDao(AppConfig.mainDbKey);
AppPrivilege appPrivilege = apdao.Get(id);
if (appPrivilege != null)
{
IList<Tuple<string, string, object>> _pars = new List<Tuple<string, string, object>>();
_pars.Add(new Tuple<string, string, object>("PrivilegeId", "=", appPrivilege.ID));
List<Application> applications = appDao.QueryList(_pars);
if (applications != null && applications.Count > 0)
{
foreach (Application app in applications)
{
app.PrivilegeID = null;
appDao.Update(app);
}
}
IList<Tuple<string, string, object>> pars = new List<Tuple<string, string, object>>();
pars.Add(new Tuple<string, string, object>("id", "=", appPrivilege.ID));
List<PrivilegeUser> privilegeUsers = pudao.QueryList(pars);
pudao.DeleteList(privilegeUsers);
apdao.Delete(appPrivilege);
//appPrivilege.BuaAppCode = "";
//appPrivilege.BuaPrivilegeCode = "";
//appPrivilege.DisplayName = "";
//appPrivilege.EnableSync = false;
//appPrivilege.SyncIntervalTime = 0;
//apdao.Update(appPrivilege);
}
}
private void _AddApp4AI(Package4AI package, SMC_PackageExt ext)
{
if (!String.IsNullOrEmpty(ext.pe_ApplicationCode))
{
string[] apps = ext.pe_ApplicationCode.Split(",".ToCharArray());
if (apps != null && apps.Length > 0)
{
ApplicationDao appDao = new ApplicationDao(AppConfig.mainDbKey);
App4AIDao app4AIDao = new App4AIDao(AppConfig.mainDbKey);
string TEMPPATH = Path.Combine(AppConfig.PackUploadFolder, "Temp");
int idx = 1;
Hashtable extendInfo = null;
JObject extObj = null;
if (!String.IsNullOrEmpty(ext.pe_ExtentInfo))
{
extendInfo = Newtonsoft.Json.JsonConvert.DeserializeObject <Hashtable>(ext.pe_ExtentInfo);
extObj = JObject.Parse(ext.pe_ExtentInfo);
}
Newtonsoft.Json.Linq.JArray appsHash = (Newtonsoft.Json.Linq.JArray)extendInfo["Applications"];
JArray appsJobj = (JArray)extObj["Applications"];
foreach (string appCode in apps)
{
if (String.IsNullOrEmpty(appCode))
{
continue;
}
if (extendInfo.Count > 0)
{
}
//appsHash.Select(e => { e.});
List <KeyValuePair <string, object> > pars = new List <KeyValuePair <string, object> >();
pars.Add(new KeyValuePair <string, object>("[NAME]", appCode));
Application application = appDao.Get(pars);
App4AI app4AI = new App4AI();
app4AI.AppID = application.ID;
//Newtonsoft.Json.Linq.JToken.EqualityComparer = new Newtonsoft.Json.Linq.JTokenEqualityComparer();
//ec.
string AppIconUri = "";
foreach (var j in appsJobj)
{
var i = (JObject)j;
string ApplicationID = (string)i["ApplicationID"];
if (ApplicationID == application.ID.ToString())
{
var oIcon = (JObject)i["ApplicationIcon"];
AppIconUri = (string)oIcon["AppIconUri"];
break;
}
}
//Hashtable appHash = appsHash.Find(e => e["ApplicationID"] == application.ID.ToString());
//Hashtable appIconHash = (Hashtable)appHash["ApplicationIcon"];
//string AppIconUri = (string)appIconHash["AppIconUri"];
app4AI.Package4AIID = package.ID;
//app4AI.PackageName = package.Name;
app4AI.AppCode = appCode;
app4AI.ClientType = package.ClientType; //form["AppCheckClentType_" + appIndex.ToString()];
//string appIco = "";//form["AppIco_" + appIndex.ToString()]
app4AI.IconUri = AppIconUri; // GetAndroidApplicationIcoUri(Path.Combine(TEMPPATH, package.DownloadUri), appIco);
app4AI.Seq = idx;
app4AI.CreateTime = DateTime.Now;
app4AI.UpdateTime = DateTime.Now;
app4AI.CreateUid = "";
app4AI.UpdateUid = "";
IList <KeyValuePair <string, object> > _pars = new List <KeyValuePair <string, object> >();
_pars.Add(new KeyValuePair <string, object>("Package4AIID", app4AI.Package4AIID));
_pars.Add(new KeyValuePair <string, object>("AppCode", app4AI.AppCode));
_pars.Add(new KeyValuePair <string, object>("ClientType", app4AI.ClientType));
App4AI _app4ai = app4AIDao.Get(_pars);
if (_app4ai == null)
{
//package.App4AIList.Add(app4AI);
app4AIDao.Insert(app4AI);
}
else
{
app4AIDao.Update(app4AI);
}
++idx;
}
}
}
}
private void _AddApp4AI(Package4AI package, SMC_PackageExt ext)
{
if (!String.IsNullOrEmpty(ext.pe_ApplicationCode))
{
string[] apps = ext.pe_ApplicationCode.Split(",".ToCharArray());
if (apps != null && apps.Length > 0)
{
ApplicationDao appDao = new ApplicationDao(AppConfig.mainDbKey);
App4AIDao app4AIDao = new App4AIDao(AppConfig.mainDbKey);
string TEMPPATH = Path.Combine(AppConfig.PackUploadFolder, "Temp");
int idx = 1;
Hashtable extendInfo = null;
JObject extObj = null;
if (!String.IsNullOrEmpty(ext.pe_ExtentInfo))
{
extendInfo = Newtonsoft.Json.JsonConvert.DeserializeObject<Hashtable>(ext.pe_ExtentInfo);
extObj = JObject.Parse(ext.pe_ExtentInfo);
}
Newtonsoft.Json.Linq.JArray appsHash = (Newtonsoft.Json.Linq.JArray)extendInfo["Applications"];
JArray appsJobj = (JArray)extObj["Applications"];
foreach (string appCode in apps)
{
if (String.IsNullOrEmpty(appCode))
continue;
if (extendInfo.Count > 0)
{
}
//appsHash.Select(e => { e.});
List<KeyValuePair<string, object>> pars = new List<KeyValuePair<string, object>>();
pars.Add(new KeyValuePair<string, object>("[NAME]", appCode));
Application application = appDao.Get(pars);
App4AI app4AI = new App4AI();
app4AI.AppID = application.ID;
//Newtonsoft.Json.Linq.JToken.EqualityComparer = new Newtonsoft.Json.Linq.JTokenEqualityComparer();
//ec.
string AppIconUri = "";
foreach (var j in appsJobj)
{
var i = (JObject)j;
string ApplicationID = (string)i["ApplicationID"];
if (ApplicationID == application.ID.ToString())
{
var oIcon = (JObject)i["ApplicationIcon"];
AppIconUri = (string)oIcon["AppIconUri"];
break;
}
}
//Hashtable appHash = appsHash.Find(e => e["ApplicationID"] == application.ID.ToString());
//Hashtable appIconHash = (Hashtable)appHash["ApplicationIcon"];
//string AppIconUri = (string)appIconHash["AppIconUri"];
app4AI.Package4AIID = package.ID;
//app4AI.PackageName = package.Name;
app4AI.AppCode = appCode;
app4AI.ClientType = package.ClientType;//form["AppCheckClentType_" + appIndex.ToString()];
//string appIco = "";//form["AppIco_" + appIndex.ToString()]
app4AI.IconUri = AppIconUri;// GetAndroidApplicationIcoUri(Path.Combine(TEMPPATH, package.DownloadUri), appIco);
app4AI.Seq = idx;
app4AI.CreateTime = DateTime.Now;
app4AI.UpdateTime = DateTime.Now;
app4AI.CreateUid = "";
app4AI.UpdateUid = "";
IList<KeyValuePair<string, object>> _pars = new List<KeyValuePair<string, object>>();
_pars.Add(new KeyValuePair<string, object>("Package4AIID", app4AI.Package4AIID));
_pars.Add(new KeyValuePair<string, object>("AppCode", app4AI.AppCode));
_pars.Add(new KeyValuePair<string, object>("ClientType", app4AI.ClientType));
App4AI _app4ai = app4AIDao.Get(_pars);
if (_app4ai == null)
{
//package.App4AIList.Add(app4AI);
app4AIDao.Insert(app4AI);
}
else
{
app4AIDao.Update(app4AI);
}
++idx;
}
}
}
}
private void _AddAction4Android(Package4AI package, SMC_PackageExt ext)
{
if (!String.IsNullOrEmpty(ext.pe_ApplicationCode))
{
string[] apps = ext.pe_ApplicationCode.Split(",".ToCharArray());
if (apps != null && apps.Length > 0)
{
ApplicationDao appDao = new ApplicationDao(AppConfig.mainDbKey);
App4AIDao app4AIDao = new App4AIDao(AppConfig.mainDbKey);
string TEMPPATH = Path.Combine(AppConfig.PackUploadFolder, "Temp");
int idx = 1;
Action4AndroidDao action4AndroidDao = new Action4AndroidDao(AppConfig.mainDbKey);
foreach (string appCode in apps)
{
if (String.IsNullOrEmpty(appCode))
continue;
List<KeyValuePair<string, object>> pars = new List<KeyValuePair<string, object>>();
pars.Add(new KeyValuePair<string, object>("[NAME]", appCode));
Application application = appDao.Get(pars);
//for (int activtyIndex = 0; activtyIndex < Convert.ToInt32(form["activityCount_" + appIndex.ToString()]); activtyIndex++)
//{
Action4Android action4Android = new Action4Android();
action4Android.Seq = idx;//Convert.ToInt32(form["ActivitySeq_" + appIndex.ToString() + "_" + activtyIndex.ToString()]);
action4Android.DisplayName = "";//form["ActivityDisplayName_" + appIndex.ToString() + "_" + activtyIndex.ToString()];
action4Android.IsLaunch = true;//Convert.ToBoolean(form["ActivityLaunch_" + appIndex.ToString() + "_" + activtyIndex.ToString()]);
action4Android.IconUri = "";//GetAndroidApplicationIcoUri(Path.Combine(TEMPPATH, package.DownloadUri), form["ActivityIco_" + appIndex.ToString() + "_" + activtyIndex.ToString()]);
action4Android.ShortName = "";//form["ActivityShortName_" + appIndex.ToString() + "_" + activtyIndex.ToString()];
action4Android.Name = "";//form["ActivityName_" + appIndex.ToString() + "_" + activtyIndex.ToString()];
action4Android.CreateTime = DateTime.Now;
action4Android.UpdateTime = DateTime.Now;
action4Android.CreateUid = "";//CurrentUser.UserUId;
action4Android.UpdateUid = "";//CurrentUser.UserUId;
action4AndroidDao.Insert(action4Android);
//}
++idx;
}
}
}
}
public virtual SelectPagnationExDictionary GetApplicationManageList(string app, string unitcode, string orderby, int pageSize, int pageIndex)
{
ApplicationDao dao = new ApplicationDao(AppConfig.mainDbKey);
return(dao.GetApplicationManageList(app, unitcode, orderby, pageSize, pageIndex));
}
public virtual SelectPagnationExDictionary GetPrivilegeManageList(string app, string unitcode, string orderby, int pageSize, int pageIndex)
{
ApplicationDao dao = new ApplicationDao(AppConfig.mainDbKey);
return dao.GetPrivilegeManageList(app, unitcode, orderby, pageSize, pageIndex);
}
