public ActualTask GetTask()
{
#region DB functions
string query = "select at.id, at.title, at.description, at.end_date, at.assign_to, e.first_name from actual_tasks at inner join employees e on at.assign_to = e.id where at.id =" + Id + "";
ActualTask task = new ActualTask();
DbServices db = new DbServices();
DataSet ds = db.GetDataSetByQuery(query);
foreach (DataRow dr in ds.Tables[0].Rows)
{
try
{
Employee emp = new Employee();
task.Id = (int)dr["id"];
task.Title = dr["title"].ToString();
task.Description = dr["description"].ToString();
task.End_date = (DateTime)dr["end_date"];
emp.First_name = dr["first_name"].ToString();
emp.Id = (int)dr["assign_to"];
task.Assign_to = emp;
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
throw ex;
}
}
#endregion
return(task);
}
public string Inventory()
{
List <Inventory> list = DbServices.GetIventory();
string output = new JavaScriptSerializer().Serialize(list);
return(output);
}
public List <Project> GetProjectsList(int id)
{
DbServices dbs = new DbServices();
Employee emp = new Employee();
DataTable employeesTable = emp.getEmployeesTable();
DataTable projectsTable = dbs.getFullTable("projects");
var results = (from p
in projectsTable.AsEnumerable()
join pm in employeesTable.AsEnumerable()
on p.Field <int>("project_manager") equals pm.Field <int>("id")
join cb in employeesTable.AsEnumerable()
on p.Field <int>("created_by") equals cb.Field <int>("id")
where p.Field <int>("id") == id
select new Project
{
Title = p["title"].ToString(),
Start_date = (DateTime)p["start_date"],
Contact_name = p["contact_name"].ToString(),
Description = p["description"].ToString(),
End_date = (DateTime)p["end_date"],
Id = Convert.ToInt32(p["id"]),
Priority_key = p["priority_key"].ToString(),
Contact_phone = Convert.ToInt32(p["contact_phone"]),
Created_by = emp.GetEmployee(cb),
Project_manager = emp.GetEmployee(pm)
});
return(results.ToList());;
}
public override async void ReceiveMessageAsync(EventArgs e)
{
string userInput = (e as CallbackQueryEventArgs).CallbackQuery.Data;
Chat chat = (e as CallbackQueryEventArgs).CallbackQuery.Message.Chat;
if (!Validator.CheckNumber(userInput))
{
await ServicesMessageController.SendMessageAsync(chat, Validator.BadNumber);
return;
}
long roomTypeId = int.Parse(userInput);
HotelRoomType roomType = ServicesHotelRoomType.GetHotelRoomTypeById(roomTypeId);
List <string> photos = DbServices.GetHotelRoomTypeImagesUrl(roomTypeId);
if (roomType == null)
{
await ServicesMessageController.SendMessageAsync(
chat, "Такого типу номеру не існує", Keyboards.ReturnMainMenu);
return;
}
string message = ViewRoomType.GetTextAboutRoomType(roomType);
await ServicesMessageController.SendPhotosAsync(chat.Id, photos);
await ServicesMessageController.SendMessageAsync(chat, message, Keyboards.ReturnMainMenu);
responder.SetState(new HotelRoom_0());
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
if (filterContext.ActionDescriptor.IsDefined(typeof(ExemptionInjectionAttribute), false) || filterContext.ActionDescriptor.ControllerDescriptor.IsDefined(typeof(ExemptionInjectionAttribute), false))
{
return;
}
var viewModel = new SysSetVM();
if (!CacheManager.Contains(Keys.SysSetCacheKey))
{
using (var services = new DbServices())
{
services.Command((db) =>
{
Mapper.Initialize(c => c.CreateMap <SysSet, SysSetVM>());
viewModel = Mapper.Map <SysSetVM>(db.Queryable <SysSet>().FirstOrDefault());
});
}
CacheManager.Set(Keys.SysSetCacheKey, viewModel);
}
else
{
viewModel = CacheManager.Get <SysSetVM>(Keys.SysSetCacheKey);
}
if (filterContext.RouteData.DataTokens[Keys.SysSetInfoInjectionKey] == null)
{
filterContext.RouteData.DataTokens.Add(Keys.SysSetInfoInjectionKey, viewModel);
}
}
public string GetCart(int userid)
{
List <Item> list = DbServices.GetCart(userid);
string output = new JavaScriptSerializer().Serialize(list);
return(output);
}
Wiki.Page Save()
{
// Get the slashes correct and trim it
txtPath.Text = txtPath.Text.Replace('\\', '/').Trim();
// Ensure they start with a slash
if (!txtPath.Text.StartsWith("/"))
{
txtPath.Text = "/" + txtPath.Text;
}
// Ensure its a unique name
String path = txtPath.Text;
string newurlpath = Wiki.Page.PathToUrlPath(path);
// Are they renaming it? If so, check for dupes
if (urlpath.ToLower() != newurlpath.ToLower())
{
int uniqCount = 2;
while (DbServices.PageExistsWithUrlpath(newurlpath))
{
path = txtPath.Text + " " + uniqCount.ToString();
newurlpath = Wiki.Page.PathToUrlPath(path);
uniqCount++;
}
}
Wiki.Page page = DbServices.FindPageByUrlpath(urlpath);
page.path = path;
page.contents = txtRichEditor.Text.Trim();
page.author = Auth.UserName;
page.Save();
return(page);
}
public string ISdiscount()
{
List <Item> list = DbServices.ISdiscount();
string output = new JavaScriptSerializer().Serialize(list);
return(output);
}
public List <Employee> GetAssignToList()
{
#region DB functions
string query = "select e.id emp_id, e.first_name from employees as e";
List <Employee> AssignToList = new List <Employee>();
DbServices db = new DbServices();
DataSet ds = db.GetDataSetByQuery(query);
foreach (DataRow dr in ds.Tables[0].Rows)
{
try
{
Employee assign_to = new Employee();
assign_to.Id = (int)dr["emp_id"];
assign_to.First_name = dr["first_name"].ToString();
AssignToList.Add(assign_to);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
throw ex;
}
}
#endregion
return(AssignToList);
}
public string Favorites(int userid)
{
List <Inventory> list = DbServices.Favorites(userid);
string output = new JavaScriptSerializer().Serialize(list);
return(output);
}
public DataTable getEmployeesTable()
{
DbServices dbs = new DbServices();
DataTable employeesTable = dbs.getFullTable("employees");
return(employeesTable);
}
public override async void ReceiveMessageAsync(EventArgs e)
{
string userInput = (e as CallbackQueryEventArgs).CallbackQuery.Data;
Chat chat = (e as CallbackQueryEventArgs).CallbackQuery.Message.Chat;
if (!Validator.CheckNumber(userInput))
{
await ServicesMessageController.SendMessageAsync(chat, Validator.BadNumber);
return;
}
long id = long.Parse(userInput);
var listRoomTypes = DbServices.GetAviableRoomTypes(arrival, departure, int.Parse(adults), int.Parse(children));
if (ServicesHotelRoomType.GetHotelRoomTypeById(id) == null ||
!listRoomTypes.Exists(t => t.Id == id))
{
await ServicesMessageController.SendMessageAsync(
chat, "Оберіть тип номеру", Keyboards.ReturnMainMenu);
return;
}
;
responder.userTempData["HotelRoomTypeId"] = userInput;
responder.SetState(new BookRoom_05());
}
public Request GetRequest()
{
#region DB functions
string query = "select r.id, r.title, r.description, r.contact_name, r.contact_phone, r.assign_to, e.first_name from requests r inner join employees e on r.assign_to = e.id where r.id =" + Id + "";
Request req = new Request();
DbServices db = new DbServices();
DataSet ds = db.GetDataSetByQuery(query);
foreach (DataRow dr in ds.Tables[0].Rows)
{
try
{
Employee emp = new Employee();
req.Id = (int)dr["id"];
req.Title = dr["title"].ToString();
req.Description = dr["description"].ToString();
req.Contact_name = dr["contact_name"].ToString();
req.Contact_phone = (int)dr["contact_phone"];
emp.First_name = dr["first_name"].ToString();
emp.Id = (int)dr["assign_to"];
req.Assign_to = emp;
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
throw ex;
}
}
#endregion
return(req);
}
protected void bnSave_Click(object sender, EventArgs e)
{
// Get the slashes correct and trim it
txtPath.Text = txtPath.Text.Replace('\\', '/').Trim();
// Ensure they start with a slash
if (!txtPath.Text.StartsWith("/"))
{
txtPath.Text = "/" + txtPath.Text;
}
// Ensure its a unique name
String path = txtPath.Text;
string urlpath = Wiki.Page.PathToUrlPath(path);
int uniqCount = 2;
while (DbServices.PageExistsWithUrlpath(urlpath))
{
path = txtPath.Text + " " + uniqCount.ToString();
urlpath = Wiki.Page.PathToUrlPath(path);
uniqCount++;
}
// Save it
Wiki.Page page = new Wiki.Page();
page.path = path;
page.contents = txtRichEditor.Text.Trim();
page.author = Auth.UserName;
page.Save();
Response.Redirect("./?" + page.urlpath);
}
public void StartLog(ErrorLog logger)
{
using (var services = new DbServices())
{
services.Command((db) =>
{
db.Insert <ErrorLog>(logger);
});
}
MailHelper.SendTextEmail("百签软件有限公司 技术支持", "*****@*****.**", "百小僧", "*****@*****.**", "应用程序异常通知",
@"<p>引起异常会员ID：" + logger.LogMemberID + @"</p>
<p>引起异常会员账号：" + logger.Account + @"</p>
<p>当前异常应用程序：" + logger.Source + @"</p>
<p>引起异常链接地址：" + logger.ErrorUrl + @"</p>
<p>异常消息：" + logger.Message + @"</p>
<p>引起异常的方法：" + logger.TargetSite + @"</p>
<p>异常堆栈信息：<pre>" + logger.StackTrace + @"</pre></p>
<p>异常编码数字：" + logger.HResult + @"</p>
<p>异常帮助文档：" + logger.HelpLink + @"</p>
<p>异常记录时间：" + logger.LogTime + @"</p>
<p style='text-align:right;'><br /><br />来至：<a title='百签软件（中山）有限公司' href='http://www.baisoft.org/'>百签软件（中山）有限公司</a> 异常监控
<br />" + DateTime.Now + @"</p>");
}
public string Login(string userName, int pass)
{
User user = DbServices.Login(userName, pass);
string output = new JavaScriptSerializer().Serialize(user);
return(output);
}
public override async void OnStateChange(Chat chat)
{
DateTime firstDate = DateTime.Now.AddDays(1);
DateTime secondDate = firstDate.AddDays(6);
List <string> dates = DbServices.GetIntermediateDates(firstDate, secondDate);
await ServicesMessageController.SendMessageAsync(
chat, "Введіть дату прибуття", Keyboards.NextDates(dates));
}
public override async void OnStateChange(Chat chat)
{
responder.userTempData.TryGetValue("DateOfArrival", out string firstDateString);
DateTime firstDate = DateTime.Parse(firstDateString).AddDays(1);
DateTime secondDate = firstDate.AddDays(6);
List <string> dates = DbServices.GetIntermediateDates(firstDate, secondDate);
await ServicesMessageController.SendMessageAsync(
chat, "Введіть дату відбуття", Keyboards.NextDates(dates));
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Details(Nullable <int> product)
{
if (product == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LoanVwViewModel loanVwViewModel = new LoanVwViewModel();
Db db = new Db(DbServices.ConnectionString);
// loanVwViewModel.Instance = LoanVwServices.Get(product.Value, db);
loanVwViewModel.Instance = LoanVwServices.GetChildren(product.Value, db);
if (loanVwViewModel.Instance == null)
{
return(HttpNotFound());
}
@ViewBag.IncomingLoanVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "IncomingLoan", "ModuleName");
if (loanVwViewModel.Instance.IncomingLoanVw != null)
{
loanVwViewModel.IncomingLoanVwViewModel.List.Add(loanVwViewModel.Instance.IncomingLoanVw);
}
// loanVwViewModel.IncomingLoanVwViewModel.Instance = loanVwViewModel.Instance.IncomingLoanVw;
@ViewBag.LoanChangeVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "LoanChange", "ModuleName");
if (loanVwViewModel.Instance.LoanChangeVw != null)
{
loanVwViewModel.LoanChangeVwViewModel.List.Add(loanVwViewModel.Instance.LoanChangeVw);
}
// loanVwViewModel.LoanChangeVwViewModel.Instance = loanVwViewModel.Instance.LoanChangeVw;
@ViewBag.FromLoanChangeVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "LoanChange", "ModuleNamePlural");
// loanVwViewModel.FromLoanChangeVwViewModel.List = LoanChangeVwServices.GetByLoanId(product.Value, db);
loanVwViewModel.FromLoanChangeVwViewModel.List = loanVwViewModel.Instance.FromLoanChangeVwList;
@ViewBag.OutgoingLoanVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "OutgoingLoan", "ModuleName");
if (loanVwViewModel.Instance.OutgoingLoanVw != null)
{
loanVwViewModel.OutgoingLoanVwViewModel.List.Add(loanVwViewModel.Instance.OutgoingLoanVw);
}
// loanVwViewModel.OutgoingLoanVwViewModel.Instance = loanVwViewModel.Instance.OutgoingLoanVw;
//loanVwViewModel.Instance.ProductVw = ProductVwServices.Get(loanVwViewModel.Instance.ProductId);
//loanVwViewModel.Instance.ProductVw.RefundableProductVw = RefundableProductVwServices.GetChildren(loanVwViewModel.Instance.ProductId);
@ViewBag.InstallmentVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "Installment", "ModuleNamePlural");
// refundableProductVwViewModel.InstallmentVwViewModel.List = InstallmentVwServices.GetByRefundableProductId(product.Value, db);
//loanVwViewModel.Instance.ProductVw.RefundableProductVw.InstallmentVwList = loanVwViewModel.Instance.ProductVw.RefundableProductVw.InstallmentVwList;//InstallmentVwServices.GetByRefundableProductProductId(loanVwViewModel.Instance.ProductId);
loanVwViewModel.InstallmentsResultList = DbServices.GetInstallments(loanVwViewModel.Instance.ProductId);
return(View(loanVwViewModel));
}
} // Log
static void UpdateDbStatus(int status)
{
using (var cmd = new SqlCeCommand())
{
cmd.CommandText = "INSERT INTO [Status] ([Status], [Timestamp]) VALUES (?, ?)";
cmd.Parameters.Add("@Status", System.Data.SqlDbType.Int).Value = status;
cmd.Parameters.Add("@Timestamp", System.Data.SqlDbType.DateTime).Value = DateTime.UtcNow;
DbServices.Execute(DbFile, cmd);
} // using cmd
} // UpdateDbStatus
protected void bnDelete_Click(object sender, EventArgs e)
{
string confirm = "Really delete!";
if (bnDelete.Text == confirm)
{
DbServices.DeletePageByUrlpath(urlpath);
Response.Redirect("./");
}
bnDelete.Text = confirm;
}
public void TestInsertInitialData()
{
var srv = new DbServices();
srv.InsertInitialData();
using (var ctx = new BankDbContext())
{
var card = ctx.Cards.Single(c => c.CardId == "5111111111111111");
}
}
public DataTable getFullTable(string table)
{
#region DB functions
StringBuilder sb = new StringBuilder();
string query = sb.AppendFormat("select * from {0} p;", table).ToString();
DbServices db = new DbServices();
DataSet ds = db.GetDataSetByQuery(query);
return(ds.Tables[0]);
#endregion
}
public bool InsertCalculatedExpression(string clientIP, string expression)
{
try
{
DbServices.ExecuteInsertStoredProcedure("sp_InsertCalculatedExpressionByIP", new string[] { clientIP, expression });
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool DeleteCalculatedExpression(string Id)
{
try
{
DbServices.ExecuteDeleteStoredProcedure("sp_DeleteCalculatedExpression", new string[] { Id });
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult PrintReportEmployeeLoansBetweenTwoDates(ReportEmployeeLoansBetweenTwoDatesFilter model)
{
try
{
ViewBag.Title = "Report";
List <ReportEmployeeLoansBetweenTwoDatesResult> result = DbServices.ReportEmployeeLoansBetweenTwoDates(model, db);
return(PartialView(result));
}
catch (CfException exc)
{
return(View());
}
}
public ActionResult ReportSubscriptions(ReportSubscriptionsBetweenTwoDatesFilter filter)
{
try
{
List <ReportSubscriptionsBetweenTwoDatesResult> result = DbServices.ReportSubscriptionsBetweenTwoDates(filter, db);
return(PartialView("ReportSubscriptionsResult", result));
}
catch (CfException exc)
{
ViewBag.ReportSubscriptions = reportSubscriptions;
return(View());
}
}
public List <CalculationsHistory> GetCalculationsHistoryByIPandCurrentDate(string clientIP)
{
DataSet ds = new DataSet();
List <CalculationsHistory> calHistoryList = new List <CalculationsHistory>();
DbServices.ExecuteStoreProcedure("sp_GetCalculationsHistoryByIPandCurrentDate", new string[] { clientIP }, "CalculationsHistory", ds);
if (ds.Tables["CalculationsHistory"] != null && ds.Tables["CalculationsHistory"].Rows.Count > 0)
{
DataTable dt = ds.Tables["CalculationsHistory"];
calHistoryList = dt.CreateListFromTable <CalculationsHistory>();
}
return(calHistoryList);
}
public T GetLastInsertedRow <T>(string tableName, string id = null) where T : new()
{
T item = new T();
try
{
item = DbServices.GetLastInsertedDataFromTable <T>(tableName, id);
return(item);
}
catch (Exception ex)
{
return(item);
}
}
public ActionResult PrintReportBalance(ReportMonthlyBalanceSumFilter model)
{
try
{
ViewBag.Title = "Report";
List <ReportMonthlyBalanceSumResult> result = DbServices.ReportMonthlyBalanceSum(model, db);
return(PartialView(result));
}
catch (CfException exc)
{
return(View());
}
}
