protected void BindData()
{
string condition = "IsDel=0 And GoDate>'" + DateTime.Now.ToString() + "' And ID not in(Select GroupID from PromotionGroup Where PromotionID=" + MyPromotion.ID + ")";
DateTime dtBegin = GetUrlDateTime("bdate");
DateTime dtEnd = GetUrlDateTime("edate");
if (dtBegin != DateTime.MinValue && dtEnd != DateTime.MinValue && dtEnd > dtBegin)
{
condition = condition + " And GoDate>='" + dtBegin.ToStartString() + "' And GoDate<='" + dtEnd.ToEndString() + "'";
}
AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Fields = "*";
query.OrderBy = "ID desc";
query.PrimaryKey = "ID";
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = "V_Group_Line";
query.Condition = condition;
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
if (dtBegin != DateTime.MinValue && dtEnd != DateTime.MinValue)
{
tbBegin.Text = dtBegin.ToDateOnlyString();
tbEnd.Text = dtEnd.ToDateOnlyString();
}
}
protected void BindData()
{
string realName = GetUrlString("RealName");
AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Ascending = false;
if (!realName.IsNullOrEmpty())
{
query.Condition = "RealName like '%" + realName + "%'";
}
query.Fields = SiteUserBLL.AllFields;
query.OrderBy = "RoleIDs";
query.PrimaryKey = "Name";
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = "SiteUser";
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
tbName.Text = realName;
}
protected void BindData()
{
string condition = "IsDel=0";
string keyword = GetUrlString("keyword");
if (!keyword.IsNullOrEmpty())
{
condition = condition + " And Name like '%" + keyword + "%'";
}
AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Ascending = false;
query.Fields = TMS.PromotionInfo.AllFields;
query.OrderBy = "ID desc";
query.PrimaryKey = TMS.PromotionInfo.TablePrimaryKey;
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = TMS.PromotionInfo.TableOrViewName;
query.Condition = condition;
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
tbKeyWord.Text = keyword;
}
protected void Page_Load(object sender, EventArgs e)
{
LoginCheck.AdminManage();
AdminSetting.isPermissions("2", "5");
string Action = Request.QueryString["Action"];
int Id = StringDeal.ToInt(Request.QueryString["Id"]);
if (Action == "del")
{
AdminSetting.isPermissions("2", "3");
string Result = bC.ChannelDel(Id).ToString();
if (Result == "1")
{
StringDeal.Alter("此频道下存在子频道，请先删除子频道！");
}
}
else if (Action == "lock")
{
bC.ChannelLock(Id);
}
else if (Action == "down" || Action == "up")
{
bC.ChannelMove(Id, Action);
}
dsList = (DataSet)bC.ChannelList(-1);
}
protected void BindData()
{
string condition = "IsDel=0 And LineID=" + MyLine.ID;
DateTime dtBegin = GetUrlDateTime("bdate");
DateTime dtEnd = GetUrlDateTime("edate");
if (dtBegin != DateTime.MinValue && dtEnd != DateTime.MinValue && dtEnd > dtBegin)
{
condition = condition + " And GoDate>='" + dtBegin.ToStartString() + "' And GoDate<='" + dtEnd.ToEndString() + "'";
}
AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Fields = TravelGroupInfo.AllFields;
query.OrderBy = "ID";
query.PrimaryKey = TravelGroupInfo.TablePrimaryKey;
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = TravelGroupInfo.TableOrViewName;
query.Condition = condition;
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
if (dtBegin != DateTime.MinValue && dtEnd != DateTime.MinValue)
{
tbBegin.Text = dtBegin.ToDateOnlyString();
tbEnd.Text = dtEnd.ToDateOnlyString();
}
}
public async Task <IActionResult> PutAdminSetting(int id, AdminSetting adminSetting)
{
if (id != adminSetting.SettingId)
{
return(BadRequest());
}
_context.Entry(adminSetting).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AdminSettingExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult> PostAdminSetting(AdminSetting adminSetting)
{
try
{
if (ModelState.IsValid)
{
adminSetting.SettingId = 0;
adminSetting.CreatedDate = DateTime.Now;
//adminSetting.DailyEmailTime = TimeZoneInfo.ConvertTimeFromUtc(Convert.ToDateTime(adminSetting.DailyEmailTime), GenericMethods.Indian_Zone);
adminSetting.DailyEmailTime = TimeZone.CurrentTimeZone.ToLocalTime(Convert.ToDateTime(adminSetting.DailyEmailTime));
_context.AdminSetting.Add(adminSetting);
await _context.SaveChangesAsync();
//DailyEmailService.SetTimer();
DailyEmailService.RestartEmailService();
GenericMethods.Log(LogType.ActivityLog.ToString(), "PostAdminSetting: " + adminSetting.CreatedBy + "-Setting created successfully");
return(Ok("Settings saved successfully!"));
}
else
{
return(BadRequest("Failed to create settings!"));
}
}
catch (Exception ex)
{
GenericMethods.Log(LogType.ErrorLog.ToString(), "PostAdminSetting: " + ex.ToString());
return(StatusCode(StatusCodes.Status500InternalServerError, ex));
}
}
public ActionResult AdminEmail(String CompanyURL, AdminSetting Model)
{
PopulateModel(Model);
if (!ModelState.IsValid)
{
return(View(Model));
}
var Email = Context.Emails.Where(e => e.CompanyId == Model.CompanyId && e.EmailName == Model.Key).FirstOrDefault();
if (Email == null)
{
Email = new Data.Email();
Email.CompanyId = Model.CompanyId;
Email.EmailName = Model.Caption;
Email.EmailText = Model.Value;
Context.Entry(Email).State = System.Data.Entity.EntityState.Added;
}
else
{
Email.EmailText = Model.Value;
Context.Entry(Email).State = System.Data.Entity.EntityState.Modified;
}
Context.SaveChanges();
return(View(Model));
}
protected void BindData()
{
string condition = "CostType='" + CostType.JoinGroup + "' And UserName='******'";
DateTime dtBegin = GetUrlDateTime("bdate");
DateTime dtEnd = GetUrlDateTime("edate");
if (dtBegin != DateTime.MinValue && dtEnd != DateTime.MinValue && dtBegin <= dtEnd)
{
condition = condition + " And AddTime>='" + dtBegin.ToStartString() + "' And AddTime<='" + dtEnd.ToEndString() + "'";
}
AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Fields = "*";
query.OrderBy = "ID desc";
query.PrimaryKey = "ID";
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = "V_CostHistory";
query.Condition = condition;
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
tbBegin.Text = dtBegin == DateTime.MinValue ? "" : dtBegin.ToDateOnlyString();
tbEnd.Text = dtEnd == DateTime.MinValue ? "" : dtEnd.ToDateOnlyString();
}
public ActionResult DeleteConfirmed(int id)
{
AdminSetting adminSetting = db.AdminSettings.Find(id);
db.AdminSettings.Remove(adminSetting);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,Name,Lastname,Email,Password,Image,Status")] AdminSetting adminSetting)
{
if (ModelState.IsValid)
{
db.Entry(adminSetting).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adminSetting));
}
public static bool SetAdminSettings(List <AdminSettingsViewModel> saveModel)
{
using (var dbContext = new AARPDbContext())
{
var settings = dbContext.AdminSettings.ToList();
var techSettings1 = settings.Where(x => x.Id == 1).FirstOrDefault();
if (techSettings1 != null)
{
techSettings1.EmailTimer = saveModel[0].EmailTimer;
techSettings1.FeedbackMessage = saveModel[0].FeedbackMessage;
techSettings1.ReminderID = saveModel[0].EnableReminder;
techSettings1.ReminderMessage = saveModel[0].ReminderMessage;
dbContext.SaveChanges();
}
else
{
techSettings1 = new AdminSetting()
{
Id = 1,
EmailTimer = saveModel[0].EmailTimer,
FeedbackMessage = saveModel[0].FeedbackMessage,
ReminderID = saveModel[0].EnableReminder,
ReminderMessage = saveModel[0].ReminderMessage
};
dbContext.AdminSettings.Add(techSettings1);
dbContext.SaveChanges();
}
var techSettings2 = settings.Where(x => x.Id == 2).FirstOrDefault();
if (techSettings2 != null)
{
techSettings2.EmailTimer = saveModel[1].EmailTimer;
techSettings2.FeedbackMessage = saveModel[1].FeedbackMessage;
techSettings2.ReminderID = saveModel[1].EnableReminder;
techSettings2.ReminderMessage = saveModel[1].ReminderMessage;
dbContext.SaveChanges();
}
else
{
techSettings2 = new AdminSetting()
{
Id = 2,
EmailTimer = saveModel[1].EmailTimer,
FeedbackMessage = saveModel[1].FeedbackMessage,
ReminderID = saveModel[1].EnableReminder,
ReminderMessage = saveModel[1].ReminderMessage
};
dbContext.AdminSettings.Add(techSettings2);
dbContext.SaveChanges();
}
}
return(true);
}
public ActionResult Create([Bind(Include = "id,Name,Lastname,Email,Password,Image,Status")] AdminSetting adminSetting)
{
if (ModelState.IsValid)
{
db.AdminSettings.Add(adminSetting);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adminSetting));
}
public ActionResult Delete(string id, AdminSetting model)
{
try
{
var repo = new Repository<AdminSetting>(DbCollection.AdminSetting);
repo.Delete(new ObjectId(id));
return RedirectToAction("Index");
}
catch
{
return View();
}
}
// GET: Admin/AdminSettings/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AdminSetting adminSetting = db.AdminSettings.Find(id);
if (adminSetting == null)
{
return(HttpNotFound());
}
return(View(adminSetting));
}
public ActionResult Index(string Email, string Pass)
{
AdminSetting curAdmin = db.AdminSettings.FirstOrDefault(a => a.Email == Email && a.Password == Pass);
if (curAdmin != null)
{
Session["LoggedAdmin"] = curAdmin;
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.Error = "Email or Password is NOT correct";
return(View());
}
}
private void btnOk_Click(object sender, EventArgs e)
{
string password = txtLoginPassword.Text;
AdminSetting adminSetting = _context.AdminSettings.First();
if (adminSetting.LoginPassword == password)
{
Dashboard dashboard = new Dashboard();
dashboard.ShowDialog();
}
else
{
MessageBox.Show("Parol səhvdir", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
txtLoginPassword.Text = "";
}
public ActionResult Login(AdminSetting entrySetting)
{
AdminSetting adminSetting = _db.AdminSettings.First();
if (entrySetting.Username == adminSetting.Username //&&
//Crypto.VerifyHashedPassword(adminSetting.Password, entrySetting.Password)//
)
{
Session["adminLogged"] = true;
Session["adminUser"] = adminSetting;
return(RedirectToAction("Index", "Dashboard"));
}
ViewBag.LoginError = "Username or password is wrong.";
return(View());
}
protected void BindData()
{
string condition = "IsDel=0";
string keyword = GetUrlString("keyword");
int catID = GetUrlInt("CatID");
if (!keyword.IsNullOrEmpty())
{
condition = condition + " And Name like '%" + keyword + "%'";
}
if (catID > 0)
{
LineCatInfo cat = allCats.Find(s => s.ID == catID);
if (cat != null)
{
if (cat.ParentID == 0)
{
condition = condition + " And FirstCatID=" + catID;
}
else
{
condition = condition + " And SecondCatID=" + catID;
}
}
}
AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Fields = LineInfo.AllFields;
query.OrderBy = "ID desc";
query.PrimaryKey = LineInfo.TablePrimaryKey;
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = LineInfo.TableOrViewName;
query.Condition = condition;
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
tbKeyWord.Text = keyword;
ddlCat.SelectedValue = catID.ToString();
}
protected void BindData()
{
AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Ascending = false;
query.Fields = GoodsBLL.GoodsCatFields;
query.OrderBy = "SortOrder";
query.PrimaryKey = "ID";
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = "GoodsCat";
query.Condition = "IsDel=0";
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
}
protected void BindData()
{
string condition = "1=1";
string status = GetUrlString("status");
if (!status.IsNullOrEmpty())
{
condition = condition + " And ExchangeStatus='" + status + "'";
}
DateTime dtBegin = GetUrlDateTime("bdate");
DateTime dtEnd = GetUrlDateTime("edate");
if (dtBegin != DateTime.MinValue && dtEnd != DateTime.MinValue && dtBegin <= dtEnd)
{
condition = condition + " And AddTime>='" + dtBegin.ToStartString() + "' And AddTime<='" + dtEnd.ToEndString() + "'";
}
AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Fields = "*";
query.OrderBy = "ID desc";
query.PrimaryKey = "ID";
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = "V_ExchangeHistory";
query.Condition = condition;
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
tbBegin.Text = dtBegin == DateTime.MinValue ? "" : dtBegin.ToDateOnlyString();
tbEnd.Text = dtEnd == DateTime.MinValue ? "" : dtEnd.ToDateOnlyString();
ddlStatus.SelectedValue = status;
}
public ActionResult Create(AdminSetting model)
{
try
{
var repo = new Repository<AdminSetting>(DbCollection.AdminSetting);
var item = repo.Gets().FirstOrDefault(m => m.Title.Equals(model.Title));
if (item == null)
{
model.Enable = true;
repo.Insert(model);
return RedirectToAction("Index");
}
else
{
return Json(new { result = MyConstants.Duplicate });
}
}
catch
{
return View();
}
}
public ActionResult AdminEmail(String CompanyURL, string EmailName)
{
var Model = new AdminSetting();
Model.Caption = EmailName == null ? "Timesheet Notification Email" : EmailName;
Model.Key = EmailName == null ? "TimesheetSubmissionEmail" : EmailName;
PopulateModel(Model);
if (!ModelState.IsValid)
{
return(View(Model));
}
var Email = Context.Emails.Where(e => e.CompanyId == Model.CompanyId && e.EmailName == Model.Caption).FirstOrDefault();
if (Email != null)
{
Model.Value = Email.EmailText;
}
return(View(Model));
}
protected void BindData()
{
string condition = "1=1";
string keyword = GetUrlString("keyword");
int catID = GetUrlInt("CatID");
if (!keyword.IsNullOrEmpty())
{
condition = condition + " And Name like '%" + keyword + "%'";
}
if (catID > 0)
{
condition = condition + " And CatID=" + catID;
}
AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Ascending = false;
query.Fields = "*";
query.OrderBy = "ID desc,IsOut asc";
query.PrimaryKey = "ID";
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = "V_Goods";
query.Condition = condition;
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
tbKeyWord.Text = keyword;
ddlCat.SelectedValue = catID.ToString();
}
protected void BindData()
{
string condition = "1=1";
string keyword = GetUrlString("keyword");
string cat = GetUrlString("cat");
if (!keyword.IsNullOrEmpty())
{
condition = condition + " And QATitle like '%" + keyword + "%'";
}
if (!cat.IsNullOrEmpty() && cat != "所有")
{
condition = condition + " And CatName='" + cat + "'";
}
AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
WebQuery query = new WebQuery();
query.Fields = QAInfo.AllFields;
query.OrderBy = "ID desc";
query.PrimaryKey = QAInfo.TablePrimaryKey;
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = QAInfo.TableOrViewName;
query.Condition = condition;
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
tbKeyWord.Text = keyword;
ddlCat.SelectedValue = cat;
}
protected void Page_Load(object sender, EventArgs e)
{
LoginCheck.AdminManage();
mC.Id = StringDeal.ToInt(Request.QueryString["Id"]);
if (mC.Id == 0)
{
AdminSetting.isPermissions("2", "1");
}
else
{
AdminSetting.isPermissions("2", "2");
}
mM.Id = 0;
mM.ParentId = 0;
mM.Temp = "Menu_Field";
if (!IsPostBack)
{
menuListDataSet = (DataSet)bM.MenuList(); //说明
dsReader = bM.MenuReader(mM); //说明
BindMenuParent(0, "┣"); //说明
bSetType bST = new bSetType(); //说明
mSetType mST = new mSetType(); //说明
dsList = (DataSet)bC.ChannelList(-1); //说明
BindClass(0, "┣");
mST.ParentId = 1;
Setting.DataSource = bST.GetSetTypeList(mST).Tables[0];
Setting.DataTextField = "Title";
Setting.DataValueField = "Value";
Setting.DataBind();
ChannelRead();
}
else
{
//ChannelSave();
}
}
protected void BindData()
{
string condition = "LineID=" + MyLine.ID;
WebPager pager = AdminSetting.CreateWebPagerForGridView(gvData, ArrowControlPageIndex);
//不分页
pager.PageSize = 1000;
WebQuery query = new WebQuery();
query.Ascending = false;
query.Fields = LineDetailInfo.AllFields;
query.OrderBy = "SortOrder asc";
query.PrimaryKey = LineDetailInfo.TablePrimaryKey;
query.SqlCreateType = ControlSqlCreateType.RowNum;
query.TableName = LineDetailInfo.TableOrViewName;
query.Condition = condition;
gvData.Db = TMS.Db.Helper;
gvData.Query = query;
gvData.CreateDataSource();
gvData.DataBind();
}
public ActionResult Edit(string id, AdminSetting model)
{
try
{
var repo = new Repository<AdminSetting>(DbCollection.AdminSetting);
model.Id = new ObjectId(id);
model.Enable = true;
repo.Update(model);
return RedirectToAction("Index");
}
catch
{
return View();
}
}
