public ActionResult Create([Bind(Include = "SiteDetailID,SiteID,EmployeeNo,HouseLotNo,AreaID,ClusterID,RegionID,CityID,BarangayID,Longitude,Lattitude,SiteStatusID,SiteTypeID,SiteClassificationID,AssetOwnershipID,CSMPClassID,TransportCatID,ServiceCatID,LocationTypeID,TerrainID,AccessibilityID,SASID,ACMID,SunID,SubBase,TXTypeID,AccessIssue,TimeOfIssue,RiskCategory,TravelTime,AccessPassTime,MonthlyRevenue,ForCSMPPMR,Remarks")] SiteDetail siteDetail)
{
if (ModelState.IsValid)
{
db.SiteDetails.Add(siteDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
var sid = (int)Session["siteid"];
ViewBag.AccessibilityID = new SelectList(db.Accessibilities, "AccessibilityID", "AccessibilityName", siteDetail.AccessibilityID);
ViewBag.ACMID = new SelectList(db.ACMainSources, "ACMID", "ACMName", siteDetail.ACMID);
ViewBag.AreaID = new SelectList(db.Areas, "AreaID", "AreaName", siteDetail.AreaID);
ViewBag.AssetOwnershipID = new SelectList(db.AssetOwnershipTypes, "AssetOwnershipID", "AssetOwnership", siteDetail.AssetOwnershipID);
ViewBag.BarangayID = new SelectList(db.Baranggays, "BarangayID", "AreaClusterCityBrgy", siteDetail.BarangayID);
ViewBag.CityID = new SelectList(db.Cities, "CityID", "AreaClusterCities", siteDetail.CityID);
ViewBag.ClusterID = new SelectList(db.Clusters, "ClusterID", "AreaClusters", siteDetail.ClusterID);
ViewBag.CSMPClassID = new SelectList(db.CSMPClassifications, "CSMPClassID", "CSMPClass", siteDetail.CSMPClassID);
ViewBag.EmployeeNo = new SelectList(db.Employees, "EmployeeNo", "FullName", siteDetail.EmployeeNo);
ViewBag.LocationTypeID = new SelectList(db.LocationTypes, "LocationTypeID", "LocationTypeDescription", siteDetail.LocationTypeID);
ViewBag.RegionID = new SelectList(db.Regions, "RegionID", "RegionName", siteDetail.RegionID);
ViewBag.SASID = new SelectList(db.SecurityAndSafetys, "SASID", "SASName", siteDetail.SASID);
ViewBag.ServiceCatID = new SelectList(db.ServiceCategories, "ServiceCatID", "ServiceCat", siteDetail.ServiceCatID);
ViewBag.SiteClassificationID = new SelectList(db.SiteClassifications, "SiteClassificationID", "SiteClassificationName", siteDetail.SiteClassificationID);
ViewBag.SiteID = new SelectList(db.Sites.Where(s => s.SiteID == sid), "SiteID", "SiteFullName", siteDetail.SiteID);
ViewBag.SiteStatusID = new SelectList(db.SiteStatus, "SiteStatusID", "SiteStatusName", siteDetail.SiteStatusID);
ViewBag.SiteTypeID = new SelectList(db.SiteTypes, "SiteTypeID", "SiteTypeName", siteDetail.SiteTypeID);
ViewBag.TerrainID = new SelectList(db.Terrains, "TerrainID", "TerrainName", siteDetail.TerrainID);
ViewBag.TransportCatID = new SelectList(db.TransportCategories, "TransportCatID", "TransportCat", siteDetail.TransportCatID);
ViewBag.TXTypeID = new SelectList(db.TXTypes, "TXTypeID", "TXTypeName", siteDetail.TXTypeID);
return(View(siteDetail));
}
/// <summary>
/// 保存资料
/// </summary>
public bool SaveDetail(SiteDetail detail)
{
if (!string.IsNullOrEmpty(detail.Mobile) && !WebAgent.IsMobile(detail.Mobile))
{
return(this.FaildMessage("手机号码错误"));
}
if (!string.IsNullOrEmpty(detail.Email) && !WebAgent.IsEMail(detail.Email))
{
return(this.FaildMessage("邮箱错误"));
}
//存在就修改，否则就插入
using (DbExecutor db = NewExecutor(IsolationLevel.ReadUncommitted))
{
if (detail.Exists(db))
{
detail.Update(db, t => t.Mobile, t => t.Email);
}
else
{
detail.Add(db);
}
db.Commit();
}
return(this.AccountInfo.Log(SystemAdminLog.LogType.Site, $"修改商户资料"));
}
public HttpResponseMessage ModuleDetails(string moduleList)
{
var siteDetails = new SiteDetail
{
SiteName = PortalSettings.PortalName,
DnnVersion = _dnnVersion,
IsHost = UserInfo.IsSuperUser,
IsAdmin = UserInfo.IsInRole("Administrators")
};
foreach (var moduleName in moduleList.Split(','))
{
foreach (
var tabmodule in
GetTabModules(moduleName)
.Where(tabmodule => TabPermissionController.CanViewPage(tabmodule.TabInfo) &&
ModulePermissionController.CanViewModule(tabmodule.ModuleInfo)))
{
var moduleDetail = new ModuleDetail {
ModuleName = moduleName
};
moduleDetail.ModuleVersion = tabmodule.ModuleVersion;
moduleDetail.ModuleInstances.Add(new ModuleInstance
{
TabId = tabmodule.TabInfo.TabID,
ModuleId = tabmodule.ModuleInfo.ModuleID,
PageName = tabmodule.TabInfo.TabName,
PagePath = tabmodule.TabInfo.TabPath
});
siteDetails.Modules.Add(moduleDetail);
}
}
return(Request.CreateResponse(HttpStatusCode.OK, siteDetails));
}
public ActionResult DeleteConfirmed(int id)
{
SiteDetail siteDetail = db.SiteDetails.Find(id);
db.SiteDetails.Remove(siteDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public PartialViewResult Edit(SiteDetail r)
{
if (ModelState.IsValid)
{
r = Repo.Update(r);
return(PartialView("View", r));
}
return(PartialView("Edit", r));
}
public void Execute(MovieContents myMovieContents, string myPlayerName, MovieGroup myGroup)
{
string path = myMovieContents.GetExistPath(myGroup);
if (path == null)
return;
string executePathname = "";
// 複数ファイルのためPlayerに対応したリストを作成する
if (myMovieContents.ExistMovie != null && myMovieContents.ExistMovie.Length > 1)
{
string[] arrTargetExt = null;
arrTargetExt = new string[1];
arrTargetExt[0] = myMovieContents.Name + "*" + myMovieContents.Extension;
// プレイリストは一時ディレクトリに書き込むのでパスを取得
//string tempPath = Path.GetTempPath();
if (myPlayerName.Equals("GOM"))
executePathname = PlayList.MakeAsxFile(myMovieContents.Label, arrTargetExt, Path.GetTempPath(), myMovieContents.Name);
else if (myPlayerName.Equals("WMP"))
executePathname = PlayList.MakeWplFile(myMovieContents.Label, arrTargetExt, Path.GetTempPath(), myMovieContents.Name);
}
else if (myMovieContents.ExistMovie != null && myMovieContents.ExistMovie.Length == 1)
{
executePathname = myMovieContents.ExistMovie[0];
}
else
{
SiteDetail ColViewSiteDetail = new SiteDetail(path);
if (ColViewSiteDetail.ListCount >= 1)
{
List<common.FileContents> list = ColViewSiteDetail.GetList();
// Playerリストが存在する場合はPlayerの選択を無視して再生実行
if (list.Count >= 1)
{
executePathname = list[0].FileInfo.FullName;
Process.Start(@executePathname);
return;
}
}
}
var targets = from player in listPlayer
where player.Name.ToUpper() == myPlayerName.ToUpper()
select player;
foreach(PlayerInfo info in targets)
{
// 起動するファイル名の前後を""でくくる 例) test.mp4 --> "test.mp4"
Process.Start(info.ExecuteName, "\"" + @executePathname + "\"");
break;
}
}
public Task SaveSiteDetail([FromForm] int id, [FromForm] string mobile, [FromForm] string email)
{
SiteDetail sitedetail = new SiteDetail()
{
SiteID = id,
Mobile = mobile,
Email = email
};
return(this.GetResult(SiteAgent.Instance().SaveDetail(sitedetail)));
}
public PartialViewResult Edit(SiteDetail e)
{
var id = e.ID;
if (ModelState.IsValid)
{
var r = Repo.Update(id, UpdateModel);
return(PartialView("View", r));
}
return(PartialView("Edit", Repo.Get(id)));
}
public Task GetWhiteIP([FromForm] int id)
{
SiteDetail detail = SiteAgent.Instance().GetDetailInfo(id) ?? new SiteDetail()
{
SiteID = id
};
return(this.GetResult(new
{
detail.SiteID,
detail.WhiteIP
}));
}
public Task GetAdminUrl([FromForm] int id)
{
SiteDetail detail = SiteAgent.Instance().GetDetailInfo(id) ?? new SiteDetail()
{
SiteID = id
};
return(this.GetResult(new
{
detail.SiteID,
detail.AdminURL,
Domain = (SettingAgent.Instance().GetSetting(SettingType.AdminDomain) ?? string.Empty).Split(',')
}));
}
// GET: SiteDetails/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SiteDetail siteDetail = db.SiteDetails.Find(id);
if (siteDetail == null)
{
return(HttpNotFound());
}
return(View(siteDetail));
}
// GET: SiteDetails/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SiteDetail siteDetail = db.SiteDetails.Find(id);
if (siteDetail == null)
{
return(HttpNotFound());
}
var sid = (int)Session["siteid"];
ViewBag.AccessibilityID = new SelectList(db.Accessibilities, "AccessibilityID", "AccessibilityName", siteDetail.AccessibilityID);
ViewBag.ACMID = new SelectList(db.ACMainSources, "ACMID", "ACMName", siteDetail.ACMID);
ViewBag.AreaID = new SelectList(db.Areas, "AreaID", "AreaName", siteDetail.AreaID);
ViewBag.AssetOwnershipID = new SelectList(db.AssetOwnershipTypes, "AssetOwnershipID", "AssetOwnership", siteDetail.AssetOwnershipID);
ViewBag.BarangayID = new SelectList(db.Baranggays, "BarangayID", "AreaClusterCityBrgy", siteDetail.BarangayID);
ViewBag.CityID = new SelectList(db.Cities, "CityID", "AreaClusterCities", siteDetail.CityID);
ViewBag.ClusterID = new SelectList(db.Clusters, "ClusterID", "AreaClusters", siteDetail.ClusterID);
ViewBag.CSMPClassID = new SelectList(db.CSMPClassifications, "CSMPClassID", "CSMPClass", siteDetail.CSMPClassID);
ViewBag.EmployeeNo = new SelectList(db.Employees, "EmployeeNo", "FullName", siteDetail.EmployeeNo);
ViewBag.LocationTypeID = new SelectList(db.LocationTypes, "LocationTypeID", "LocationTypeDescription", siteDetail.LocationTypeID);
ViewBag.RegionID = new SelectList(db.Regions, "RegionID", "RegionName", siteDetail.RegionID);
ViewBag.SASID = new SelectList(db.SecurityAndSafetys, "SASID", "SASName", siteDetail.SASID);
ViewBag.ServiceCatID = new SelectList(db.ServiceCategories, "ServiceCatID", "ServiceCat", siteDetail.ServiceCatID);
ViewBag.SiteClassificationID = new SelectList(db.SiteClassifications, "SiteClassificationID", "SiteClassificationName", siteDetail.SiteClassificationID);
ViewBag.SiteID = new SelectList(db.Sites.Where(s => s.SiteID == sid), "SiteID", "SiteFullName", siteDetail.SiteID);
ViewBag.SiteStatusID = new SelectList(db.SiteStatus, "SiteStatusID", "SiteStatusName", siteDetail.SiteStatusID);
ViewBag.SiteTypeID = new SelectList(db.SiteTypes, "SiteTypeID", "SiteTypeName", siteDetail.SiteTypeID);
ViewBag.TerrainID = new SelectList(db.Terrains, "TerrainID", "TerrainName", siteDetail.TerrainID);
ViewBag.TransportCatID = new SelectList(db.TransportCategories, "TransportCatID", "TransportCat", siteDetail.TransportCatID);
ViewBag.TXTypeID = new SelectList(db.TXTypes, "TXTypeID", "TXTypeName", siteDetail.TXTypeID);
return(View(siteDetail));
}
public ActionResult PRDetail(int siteid, int customerid)
{
var dtlinfo = Helper.SelectSiteDtlsforMasterLookup <SelectSiteDtlsforMasterLookup_Result>(siteid, customerid);
var inspinfo = Helper.SelectSiteDtlsforMasterLookupInsp <SelectSiteDtlsforMasterLookupInsp_Result>(siteid, customerid);
var rmrinfo = Helper.SelectSiteDtlsforMasterLookupRMR <SelectSiteDtlsforMasterLookupRMR_Result>(siteid, customerid);
var cntinfo = Helper.SelectSiteDtlsforMasterLookupContact <SelectSiteDtlsforMasterLookupContact_Result>(siteid, customerid);
var sitedtl = new SiteDetail();
sitedtl.dtls = dtlinfo;
sitedtl.insps = inspinfo;
sitedtl.rmrs = rmrinfo;
sitedtl.contacts = cntinfo;
ViewData.Model = sitedtl;
var account = System.Web.HttpContext.Current.Session["sessionLoginName"].ToString();
var updlog = Leads.Models.Helper.UpdatePRListLog <UpdatePRListLog_Result>(account, siteid, customerid);
// var ytdByDept = Leads.Models.Helper.GetYTDLeadsByDept<GetYTDLeadsByDept_Result>();
// List<GetYTDLeadsByDept_Result> lytd = ytdByDept.ToList();
return(View());
}
public ActionResult DeleteConfirmed(int rid)
{
Rectifier rectifier = db.Rectifiers.Find(rid);
Session["Serial"] = rectifier.Serial;
Site site = db.Sites.Find(rectifier.SiteID);
Session["SiteID"] = site.SiteCode;
Session["SiteName"] = site.SiteName;
SiteDetail siteDetail = db.SiteDetails.Find(rectifier.SiteID);
Session["Cluster"] = siteDetail.ClusterID;
Session["Address"] = siteDetail.HouseLotNo;
Employee employee = db.Employees.Find(siteDetail.EmployeeNo);
db.Rectifiers.Remove(rectifier);
db.SaveChanges();
return(RedirectToAction("Create", "ArdaItems", new { id = rectifier.UnitID }));
}
public ActionResult DeleteConfirmed(int bid)
{
Battery battery = db.Batteries.Find(bid);
Session["UnitID"] = battery.UnitID;
Site site = db.Sites.Find(battery.SiteID);
Session["SiteID"] = site.SiteCode;
Session["SiteName"] = site.SiteName;
SiteDetail siteDetail = db.SiteDetails.Find(battery.SiteID);
Session["Cluster"] = siteDetail.ClusterID;
Session["Address"] = siteDetail.HouseLotNo;
Employee employee = db.Employees.Find(siteDetail.EmployeeNo);
db.Batteries.Remove(battery);
db.SaveChanges();
return(RedirectToAction("Create", "ArdaItems", new { id = battery.UnitID }));
}
private SiteDetail GetSiteDetails(string moduleList)
{
var siteDetails = new SiteDetail
{
SiteName = PortalSettings.PortalName,
DnnVersion = _dnnVersion,
IsHost = UserInfo.IsSuperUser,
IsAdmin = UserInfo.IsInRole("Administrators")
};
foreach (var moduleName in (moduleList ?? "").Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries))
{
var modulesCollection = GetTabModules((moduleName ?? "").Trim())
.Where(tabmodule => TabPermissionController.CanViewPage(tabmodule.TabInfo) &&
ModulePermissionController.CanViewModule(tabmodule.ModuleInfo));
foreach (var tabmodule in modulesCollection)
{
var moduleDetail = new ModuleDetail
{
ModuleName = moduleName,
ModuleVersion = tabmodule.ModuleVersion
};
moduleDetail.ModuleInstances.Add(new ModuleInstance
{
TabId = tabmodule.TabInfo.TabID,
ModuleId = tabmodule.ModuleInfo.ModuleID,
PageName = tabmodule.TabInfo.TabName,
PagePath = tabmodule.TabInfo.TabPath
});
siteDetails.Modules.Add(moduleDetail);
}
}
return(siteDetails);
}
async Task OnCreateButtonClicked()
{
//content = this.Content;
string themeid = "";
Settings.AmethystThemeID = "325e047a-a773-d021-bd63-53c7005d028d";
Color backgroundColorforCreateSite = Settings.BackgroundColor;
Color textColorForCreateSite = Settings.TextColor;
//Checking which is selected
if (Settings.selectedTheme == "Bedford")
{
themeid = Settings.BedfordThemeID;
backgroundColorforCreateSite = Settings.BedfordSiteBackgroundColor;
textColorForCreateSite = Settings.BedfordSiteTextColor;
Settings.isAvalanche = false;
}
else if (Settings.selectedTheme == "Avalanche")
{
themeid = Settings.AvalancheThemeID;
backgroundColorforCreateSite = Settings.AvalancheSiteBackgroundColor;
textColorForCreateSite = Settings.AvalancheSiteTextColor;
}
else if (Settings.selectedTheme == "Amethyst")
{
themeid = Settings.AmethystThemeID;
backgroundColorforCreateSite = Settings.AmythystSiteBackgroundColor;
textColorForCreateSite = Settings.AmythystSiteTextColor;
Settings.isAvalanche = false;
}
string sitename = companyname.EntryText;
CreateSitePayload site = new CreateSitePayload();
site.site_collection_id = Settings.SiteCollectionID;
site.site_theme_id = themeid;
site.name = sitename;
SiteDetail siteDetail = new SiteDetail();
siteDetail = await App.BusinessLogic.CreateSite(site);
//here this must not going to interact directly to database
if (siteDetail != null)
{
Settings.BackgroundColor = backgroundColorforCreateSite;
Settings.ThemeID = themeid;
Settings.TextColor = textColorForCreateSite;
App.BusinessLogic.SaveSiteDetail(siteDetail);
//saving site details
//changing themeid
Settings.AppTitle = siteDetail.name;
Settings.SiteID = siteDetail.id;
Console.WriteLine("Before Task !");
//take it to 60
Device.BeginInvokeOnMainThread(() => {
indicator.Text = "Creating your Mobile Website";
});
try {
//await Task.Run (() => {
Console.WriteLine("Task Started !");
if (siteDetail.site_theme_id == Settings.BedfordThemeID)
{
App.BusinessLogic.InitializeForBedford();
}
else if (siteDetail.site_theme_id == Settings.AvalancheThemeID)
{
App.BusinessLogic.InitializeForAvalache();
}
else if (siteDetail.site_theme_id == Settings.AmethystThemeID)
{
App.BusinessLogic.InitializeForAmethyst();
}
Settings.isFirstEverTime = false;
App.BusinessLogic.UpdateAppkitSettings();
} catch (Exception ex) {
Console.WriteLine("After loading !");
UtilityFunctions.CustomToast(ToastNotificationType.Error, "Error", "Connection Error.");
Console.WriteLine(ex.Message);
}
}
else
{
Console.WriteLine("After loading !");
UtilityFunctions.CustomToast(ToastNotificationType.Error, "Error", "Connect to Internet.");
}
}
async Task <bool> UpdateSite(T_ORDER dbOrder)
{
try
{
List <SiteDetail> sd = null;
List <MQuerySite> lQuerySite = new List <MQuerySite>();
MQuerySite site = null;
site = new MQuerySite();
site.orderid = dbOrder.ORDER_NO + "-send";
site.address = dbOrder.SENDER_PROVINCE + dbOrder.SENDER_CITY + dbOrder.SENDER_COUNTY + dbOrder.SENDER_ADDRESS;
site.operSource = "OMS";
if (!lQuerySite.Contains(site))
{
lQuerySite.Add(site);
}
site = new MQuerySite();
site.orderid = dbOrder.ORDER_NO + "-rec";
site.address = dbOrder.RECEIVER_PROVINCE + dbOrder.RECEIVER_CITY + dbOrder.RECEIVER_COUNTY + dbOrder.RECEIVER_ADDRESS;
site.operSource = "OMS";
if (!lQuerySite.Contains(site))
{
lQuerySite.Add(site);
}
sd = AliHandler.GetSite(lQuerySite);
SiteDetail resultsite = null;
T_NAVIGATE_DISTANCE distance;
bool bdistance = false;//是否插入距离表，如果2端距离都没有则不插入
if (sd != null && sd.Count > 0)
{
distance = new T_NAVIGATE_DISTANCE();
distance.MAIL_NO = dbOrder.BILL_NO;
distance.ORDER_NO = dbOrder.ORDER_NO;
//distance.PICKUP_DISTANCE = "0";
//distance.SEND_DISTANCE = "0";
resultsite = sd.FirstOrDefault(p => p.orderid == dbOrder.ORDER_NO + "-send");
if (resultsite != null)
{
distance.PICKUP_DISTANCE = resultsite.distance;
//distance.PICKUP_DISTANCE = resultsite.distance == null ? "0" : resultsite.distance;
if (!string.IsNullOrEmpty(resultsite.bizAreaValue))
{
if (dbOrder.PICKUP_SITE != resultsite.bizAreaValue && !string.IsNullOrEmpty(distance.PICKUP_DISTANCE))//如果是修改订单，网点可能没做修改
{
bdistance = true;
}
dbOrder.PICKUP_SITE = resultsite.bizAreaValue; //取件网点编号
string sitename = await AppService.QuerySiteName(resultsite.bizAreaValue); //dbHelper.mapper.QueryForObject<string>("T_SITE_INFO.GetName", resultsite.bizAreaValue);
if (!string.IsNullOrEmpty(sitename))
{
if (dbOrder.ORDER_STATUS == 10)
{
dbOrder.ORDER_STATUS = 20;
}
dbOrder.PICKUP_SITECODE = sitename; //名称
dbOrder.ASSIGNED_SITE_CODE = sitename; //名称
dbOrder.PUSH_OUTSYS_STATUS = 1;
dbOrder.PUSH_OUTSYS_FAIL_NUM = 0;
dbOrder.ASSIGNSITE_TYPE = 0;
}
}
}
resultsite = sd.FirstOrDefault(p => p.orderid == dbOrder.ORDER_NO + "-rec");
if (resultsite != null)
{
distance.SEND_DISTANCE = resultsite.distance;
if (!string.IsNullOrEmpty(resultsite.bizAreaValue))
{
if (dbOrder.SENDTO_SITE != resultsite.bizAreaValue && !string.IsNullOrEmpty(distance.SEND_DISTANCE))//如果是修改订单，网点可能没做修改
{
bdistance = true;
}
dbOrder.SENDTO_SITE = resultsite.bizAreaValue;
string sitename = await AppService.QuerySiteName(resultsite.bizAreaValue);//dbHelper.mapper.QueryForObject<string>("T_SITE_INFO.GetName", resultsite.bizAreaValue);
if (!string.IsNullOrEmpty(sitename))
{
dbOrder.SENDTO_SITECODE = sitename;//名称
}
}
}
int i = await AppService.UpdateSite(dbOrder);//dbHelper.mapper.Update("T_ORDER.UpdateSite", dbOrder);
if (bdistance)
{
await AppService.Add(distance); //dbHelper.mapper.Insert("T_NAVIGATE_DISTANCE.Insert", distance);
}
}
}
catch (Exception e)
{
return(false);
}
return(true);
}
