protected void Page_Load(object sender, EventArgs e) { this.Title = Resources.Common.MyIssues; GridView[] gvs = new GridView[] { gvMy, gvGroup }; db = new dbDataContext(); userName = Utils.UserName(); userIsRegistered = Users.Exists(db, userName); user me = Users.Get(db, userName); lblMyGroup.Text = me.sub_unit1.unit.unit_name + " - " + me.sub_unit1.sub_unit_name; txtSubmitter.Text = me.id.ToString(); txtGroup.Text = me.sub_unit.ToString(); urgency.Add(1, "transparent"); urgency.Add(2, "#ffe800;color:#666666;"); urgency.Add(3, "#ff7700"); urgency.Add(4, "#ff2f00"); myTickets = Tickets.MyTickets(db, me.id); groupTickets = Tickets.MyGroupsTickets(db, me); if (!IsPostBack) { System.Drawing.Color alt_color = System.Drawing.ColorTranslator.FromHtml(Themes.Current(db).alt_rows); foreach (GridView gv in gvs) { gv.HeaderStyle.BackColor = alt_color; gv.AlternatingRowStyle.BackColor = alt_color; } gvMy.DataSource = myTickets; gvMy.DataBind(); gvGroup.DataSource = groupTickets; gvGroup.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { this.Title = Resources.Common.NewTicket; db = new dbDataContext(); userName = Utils.UserName(); ddlUnit.Focus(); try{ accessLevel = Utils.AccessLevel().security_level1.id; } catch { } if (!IsPostBack) { foreach (priority p in Dbi.Priorities.List(db, 10)) ddlPriority.Items.Add(new ListItem(p.priority_name, p.id.ToString())); var units = Groups.List(db, accessLevel); if (units.Count() < 1) { // user has no privelege to post new tickets lblReport.report(false, GetLocalResourceObject("DontHaveAccess").ToString() + "<br /><br /><span class='smaller'>" + GetLocalResourceObject("ContactAdmin").ToString() + "</span>", null); pnlInput.Style.Add(HtmlTextWriterStyle.Display, "none"); pnlError.Visible = true; } else { foreach (unit u in units.OrderBy(p => p.unit_name)) ddlUnit.Items.Add(new ListItem(u.unit_name, u.id.ToString())); Utils.PopulateSubUnits(db, ddlUnit, ddlSubUnit, accessLevel); } } }
protected void Page_Load(object sender, EventArgs e) { var x = Int32.Parse("" + Session["role"]); if (x == 0) { user = Session["user"] as tb_mahasiswa; } else { user = Session["user"]; } /*for (int i = 0; i < Session.Count; i++) * { * string value = "Key: " + Session.Keys[i] + ", Value: " + Session[Session.Keys[i]].ToString(); * * Response.Write(value); * }*/ if (user == null) { Response.Redirect("default.aspx"); return; } using (dbDataContext db = new dbDataContext()) { s1.InnerText = db.tb_proposals.Count() + ""; s2.InnerText = db.tb_mahasiswas.Count() + ""; s3.InnerText = db.tb_dosens.Count() + ""; s4.InnerText = db.tb_kaprodis.Count() + ""; int tipe = Int32.Parse("" + Session["role"]); if (tipe == 0) { tb_mahasiswa user = Session["user"] as tb_mahasiswa; t1.Text = user.nim; t2.Text = user.nama; t3.Text = (from c in db.tb_fakultas where c.id_fakultas == user.id_fakultas select c.nama_fakultas).FirstOrDefault(); t4.Text = (from c in db.tb_jurusans where c.id_jurusan == user.id_jurusan select c.nama_jurusan).FirstOrDefault(); } else if (tipe == 2) { tb_dosen user = Session["user"] as tb_dosen; t1.Text = user.nid; t2.Text = user.nama; t3.Text = (from c in db.tb_fakultas where c.id_fakultas == user.id_fakultas select c.nama_fakultas).FirstOrDefault(); t4.Text = (from c in db.tb_jurusans where c.id_jurusan == user.id_jurusan select c.nama_jurusan).FirstOrDefault(); } else { tb_kaprodi user = Session["user"] as tb_kaprodi; t1.Text = user.username; t2.Text = user.nama; t3.Text = (from c in db.tb_fakultas where c.id_fakultas == user.id_fakultas select c.nama_fakultas).FirstOrDefault(); t4.Text = (from c in db.tb_jurusans where c.id_jurusan == user.id_jurusan select c.nama_jurusan).FirstOrDefault(); } } }
public Table <noticia> getTable() { dbDataContext db = getDataContext(); Table <noticia> tb = db.GetTable <noticia>(); return(tb); }
public static void Add(dbDataContext db, string domain) { allowed_email_domain aed = new allowed_email_domain(); aed.domain = domain; db.allowed_email_domains.InsertOnSubmit(aed); db.SubmitChanges(); }
public static string Import(Stream xmlFile) { string output = string.Empty; try { TextReader rdr = new StreamReader(xmlFile); XElement x = XElement.Load(rdr); var faqs = from p in x.Descendants("faq") select p; foreach (XElement xe in faqs) { dbDataContext db = new dbDataContext(); faq f = new faq(); f.title = xe.FirstAttribute.Value; f.body = xe.Value; db.faqs.InsertOnSubmit(f); try { db.SubmitChanges(); //inefficient to submit each time, *but* this will tell which faqs got inserted and which didn't output += "<div class='success'>-" + xe.FirstAttribute.Value + " " + Resources.Common.Updated + "</div>"; } catch// (Exception ex) { output += "<div class='error'>" + Resources.Common.Error + " " + xe.FirstAttribute.Value + "</div>"; } } } catch (Exception ex) { output = "<div class='error'>" + Resources.Common.Error + ": <div class='sub_error'>" + ex.Message + "</div></div>"; } return output; }
/// <summary> /// This function adds the widgets for a user /// </summary> /// <param name="widgets"></param> /// <returns></returns> public bool SetUserWidgets(List<DashboardWidget> widgets) { if (widgets != null && widgets.Count > 0) { var context = new dbDataContext(); var userId = widgets[0].UserId; //delete all the widgets for the user var foundWidgets = context.tbl_UserWidgets.Where(t => t.UserId == userId).Select(t => t).ToList(); context.tbl_UserWidgets.DeleteAllOnSubmit(foundWidgets); context.SubmitChanges(); //add widgets foreach (var wi in widgets) { if (string.IsNullOrEmpty(wi.WidgetName)) { continue; } var widget = new tbl_UserWidget { Ordering = wi.Ordering, UserId = wi.UserId, WidgetName = wi.WidgetName, WidgetTitle = wi.WidgetTitle, Width = wi.Width }; context.tbl_UserWidgets.InsertOnSubmit(widget); } context.SubmitChanges(); } return true; }
/// <summary> /// This function returns the application statuses /// </summary> /// <param name="filters"></param> /// <returns></returns> public IEnumerable<ApplicationStatus> GetApplicationStatuses(ApplicationStatusFilter filters) { var context = new dbDataContext(); //get default statuses var applicationStatuses = filters.JobId > 0 ? context.tbl_ApplicationStatus.Where(t => (t.IsDefault || t.JobId == filters.JobId)) : context.tbl_ApplicationStatus.Where(t => t.IsDefault); // return application statuses var appStatuses = applicationStatuses.Where(t => !t.Deleted).OrderBy(t => t.ViewOrder).Select(appStatus => new ApplicationStatus { ApplicationStatusId = appStatus.ApplicationStatusId, StatusName = appStatus.StatusName, IsDefault = appStatus.IsDefault, EmailTemplateId = appStatus.EmailTemplateId, InterviewType = appStatus.InterviewType, JobId = appStatus.JobId, ApplicationCount = (filters.NeedAppCount && filters.JobId > 0) ? (context.tbl_JobApplications.Count(t => t.JobId == filters.JobId && t.ApplicationStatusId == appStatus.ApplicationStatusId)) : 0 }).ToList(); // add view all if job id is passed if (filters.JobId > 0) appStatuses.Insert(0, new ApplicationStatus { ApplicationStatusId = 0, StatusName = "View All", ApplicationCount = (context.tbl_JobApplications.Count(t => t.JobId == filters.JobId)), IsDefault = true }); return appStatuses; }
/// <summary> /// This function returns the killer questions with answers for a given job id /// </summary> /// <param name="jobId"></param> /// <returns></returns> public IEnumerable<KillerQuestion> GetKillerQuestionsForJob(int jobId) { var context = new dbDataContext(); var questions = (from t in context.tbl_KillerQuestions where (t.JobId == jobId && !t.Deleted) select new KillerQuestion { Question = t.Question, KillerQuestionId = t.QuestionId, JobId = t.JobId, Published = t.Published, SingleChoice = t.SingleChoice, ExcludeFromScoring = t.ExcludeFromScoring }).ToList(); foreach (var ques in questions) { ques.Answers = (from k in context.tbl_KillerQuestionAnswers where k.QuestionId == ques.KillerQuestionId select new KillerQuestionAnswer { AnswerId = k.AnswerId, Answer = k.Answer, KillerQuestionId = k.QuestionId, Score = k.Score }).ToList(); } return questions; }
/// <summary> /// This function add/edit application status /// </summary> /// <param name="appStatusDetails"></param> /// <returns></returns> public int AddUpdateApplicationStatus(ApplicationStatus appStatusDetails) { var context = new dbDataContext(); var appStatus = context.tbl_ApplicationStatus.FirstOrDefault(t => t.ApplicationStatusId == appStatusDetails.ApplicationStatusId) ?? new tbl_ApplicationStatus(); appStatus.StatusName = appStatusDetails.StatusName; appStatus.IsDefault = appStatusDetails.IsDefault; appStatus.EmailTemplateId = appStatusDetails.EmailTemplateId; appStatus.InterviewType = appStatusDetails.InterviewType; appStatus.JobId = appStatusDetails.JobId; // try // { // Add/Update application status if (appStatus.ApplicationStatusId <= 0) { appStatus.ViewOrder = GetNextRecordId(); context.tbl_ApplicationStatus.InsertOnSubmit(appStatus); } context.SubmitChanges(); //change orders ChangeOrder(""); return appStatus.ApplicationStatusId; // } // catch (Exception) // { return -1; // } }
/// <summary> /// Get client user from the id /// </summary> /// <param name="id"></param> /// <returns></returns> public ClientUser GetClientUser(int id) { var context = new dbDataContext(); // Set up the query to retrieve client user var clientUser = context.tbl_ClientUsers.FirstOrDefault(t => t.ClientUserId == id); if (clientUser != null) { var cUser = new ClientUser { ClientId = clientUser.ClientId, ClientUserId = clientUser.ClientUserId, Email = clientUser.Email, Forename = clientUser.Forename, Surname = clientUser.Surname, Password = clientUser.Password, JobTitle = clientUser.JobTitle, Mobile = clientUser.Mobile, Telephone = clientUser.Telephone, IosApp = clientUser.IosApp, IsActive = clientUser.IsActive, CreatedDate = clientUser.CreatedDate, FooterTemplate = GetFooterTemplate(id) }; var docs = Documents.GetDocumentByDocType(new[] { 9 }, clientUser.ClientUserId).ToList(); if (docs.Count > 0) { cUser.ProfileImage = docs[0]; } return cUser; } return null; }
public static string getCategoryName(int?categoryID) { using (dbDataContext db = new dbDataContext()) { return(db.Post_Categories.Where(n => n.Id == categoryID).Select(n => n.Name).SingleOrDefault()); } }
public bool InserirAtualizar(tipo_registro a) { // função para cadastrar tipo_registro try { Table <tipo_registro> tb = getTable(); dbDataContext db = getDataContext(); if (a.id == 0) { tb.InsertOnSubmit(a); tb.Context.SubmitChanges(); } else { db.alteraTipoRegistro(a.id, a.descricao); tb.Context.SubmitChanges(); } return(true); } catch { return(false); } }
/// <summary> /// This function returns the killer question for a given id /// </summary> /// <param name="id"></param> /// <returns></returns> public KillerQuestion GetKillerQuestion(int id) { var context = new dbDataContext(); var ques = (from t in context.tbl_KillerQuestions join c in context.tbl_KillerQuestionAnswers on t.QuestionId equals c.QuestionId into j1 from j2 in j1.DefaultIfEmpty() where t.QuestionId == id group j2 by new { t } into grouped select new KillerQuestion { Question = grouped.Key.t.Question, KillerQuestionId = grouped.Key.t.QuestionId, JobId = grouped.Key.t.JobId, Published = grouped.Key.t.Published, SingleChoice = grouped.Key.t.SingleChoice, ExcludeFromScoring = grouped.Key.t.ExcludeFromScoring, }).FirstOrDefault(); if (ques != null) ques.Answers = (from k in context.tbl_KillerQuestionAnswers where k.QuestionId == ques.KillerQuestionId select new KillerQuestionAnswer { AnswerId = k.AnswerId, Answer = k.Answer, KillerQuestionId = k.QuestionId, Score = k.Score }).ToList(); return ques; }
public static string GetOne(int BalID) { using (dbDataContext db = new dbDataContext()) { var user = db.Users.Where(x => x.ID == int.Parse(Common.TCContext.Current.OnlineUserID)).FirstOrDefault(); var list = db.SmallBalance.Where(x => x.ID == BalID).Select(x => new { x.ID, x.AccessNumber, x.AccountID, x.AddTime, x.Balance, x.Broadband, x.Contacts, x.ContactTel, x.CustomerName, x.GroupID, x.GroupName, x.InstalledAddress, x.NetTime, x.Responsibility, x.State, x.WeekPrice, UserName = x.Users.Name, RemindTime = x.SmaBaRemind.OrderByDescending(y => y.AddTime).FirstOrDefault().AddTime, IsRead = x.SmaBaRead.Where(y => y.UserID == user.ID).FirstOrDefault() == null ? 0 : x.SmaBaRead.Where(y => y.UserID == user.ID).FirstOrDefault().IsRead }).FirstOrDefault(); return(JsonConvert.SerializeObject(new { data = list, msg = "请求成功", state = 1 })); } }
private void Delete_Click(object sender, RoutedEventArgs e) { if (posts.SelectedItem == null) { MessageBox.Show("Select one post", "Neutron", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } DialogResult d = MessageBox.Show("Do you want delete this post?", "Neutron", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); if (d == System.Windows.Forms.DialogResult.OK) { var temp = (int)posts.SelectedValue; using (var db = new dbDataContext()) { var post = (from a in db.Posts where a.ID == temp select a).FirstOrDefault(); if (post.User_ID == Properties.Settings.Default.userId) { db.Posts.DeleteOnSubmit(post); db.SubmitChanges(); Refresh(); } } } }
/// <summary> /// Save documents /// </summary> /// <param name="documentList"></param> /// <param name="saveToDb"></param> /// <returns></returns> public bool SaveDocuments(IEnumerable<Document> documentList, bool saveToDb = true) { var context = new dbDataContext(); foreach (var doc in documentList) { var docId = 0; var docTypeIds = context.tbl_DocumentTypes.Where(t => t.DeleteExisting).Select(t => t.DocTypeValue).ToList(); if (!string.IsNullOrEmpty(doc.UploadUrl)) { // Download and save document docId = DownloadAndSaveDocument(doc, docTypeIds.Contains(doc.DocumentTypeValue), saveToDb); } else if (!string.IsNullOrEmpty(doc.Base64String)) { // Create the file using base 64 string docId = CreateFileFromBase64String(doc, docTypeIds.Contains(doc.DocumentTypeValue), saveToDb); } else if (doc.PostedFile != null) { // Create the file using file uploader docId = CreateFileFromFileUploader(doc, docTypeIds.Contains(doc.DocumentTypeValue), saveToDb); } // Save Entry into the if (doc.DocumentTypeValue == 4 && docId > 0) { AddCvDatabaseIndexRecord(docId); } } return true; }
public List <v_mediador> ListarPorNome(string Nome, string alcance, bool SomenteAtivos) { try { message = ""; using (dbDataContext db = getDataContext()) { Nome = "%" + Nome + "%"; String sSql = "select m.*from v_mediadores m " + "join mediadores med on (med.id = m.id) " + "join locais l on (l.id = med.id_local) " + "where ((m.Nome like {0} ) or (m.RE like {0} )) "; if (SomenteAtivos) { sSql = sSql + " and ( m.Ativo = 1 )"; } // faz join com a tabela de locais(nucleos) para trazer somente os mediadores dos locais // que estão de acordo com o alcance no cabeçalho da função alcance = alcance + "%"; sSql = sSql + "and ( l.numero_opm like {1} ) "; var query = db.ExecuteQuery <v_mediador>(sSql, Nome, alcance); return(query.ToList()); } } catch (Exception e) { message = e.Message; return(null); } }
/// <summary> /// 查询固网业务 /// </summary> /// <param name="ID"></param> /// <returns></returns> public static string GetFixed(int ID) { using (dbDataContext db = new dbDataContext()) { var list = db.Business.Where(x => x.ID == ID && x.IsFixed == true).Select(x => new { x.FAlsAnlIncome, x.FBandWidth, x.FComputerNum, x.FIsDomain, x.FIsSatisfy, x.FIsServer, x.FOperator, x.FOtherWork, x.FOverTime, x.FPlatform, x.FPreAnlIncome, x.FPreInNetMouth, x.FPreWeekPrice, x.FPushWork, x.FScale, x.FUseBandWidth, x.FUseScale, x.FUseWork, x.FWeekPrice }).FirstOrDefault(); var result = JsonConvert.SerializeObject(list); return(result); } }
public void CheckTimeZone() { db = new dbDataContext(); try { var timezone = (from t in db.GetTable<timezones_t>() where t.timezone_start <= DateTime.Now.TimeOfDay where t.timezone_end > DateTime.Now.TimeOfDay select t.timezone_name).SingleOrDefault(); MessageBox.Show(timezone); } catch (Exception) { var timezone = (from t in db.GetTable<timezones_t>() where t.timezone_start <= DateTime.Now.TimeOfDay where t.timezone_end < DateTime.Now.TimeOfDay select t.timezone_name).Single(); MessageBox.Show(timezone); } //bool n = DateTime.Parse("1:00:00") < DateTime.Parse("7:00:00"); //bool n2 = DateTime.Parse("1:00:00") < DateTime.Parse("12:00:00"); //bool n = DateTime.Parse("1:00:00") < DateTime.Parse("12:00:00"); //bool n2 = DateTime.Parse("1:00:00") < DateTime.Parse("19:00:00"); //bool n = DateTime.Parse("1:00:00") < DateTime.Parse("19:00:00"); //bool n2 = DateTime.Parse("1:00:00") < DateTime.Parse("7:00:00"); //MessageBox.Show(n + " " + n2); }
/// <summary> /// This function get the users /// </summary> /// <param name="userTypeId"></param> /// <returns></returns> public IEnumerable<User> GetUsers(int userTypeId) { var context = new dbDataContext(); var users = context.tbl_Users.Where(t => !t.Deleted); //filter by type if passed if (userTypeId > 0) users = users.Where(t => t.UserType == userTypeId); return users.Select(user => new User { UserId = user.UserId, Forename = user.Forename, Surname = user.Surname, JobTitle = user.JobTitle, Email = user.Email, Password = user.Password, Telephone = user.Telephone, CreatedDate = user.CreatedDate, Fax = user.Fax, Mobile = user.Mobile, Deleted = user.Deleted, CalendarColor = user.CalendarColor, FullName = user.Forename + " " + user.Surname, UserType = GetUserType(user.UserType), IsActive = user.IsActive }); }
protected void Page_Load(object sender, EventArgs e) { Object user = Session["user"]; if (user == null) { Response.Redirect("default.aspx"); return; } if (!Page.IsPostBack) { DataTable dt = new DataTable(); using (dbDataContext db = new dbDataContext()) { GridView1.DataSource = (from c in db. orderby c.tgl_room descending select c).ToList(); GridView1.DataBind(); } dt.Columns.Add("semester", typeof(string)); dt.Columns.Add("jml_mhs", typeof(string)); dt.Rows.Add(new Object[] { "Ganjil 2019/2020", "100" }); dt.Rows.Add(new Object[] { "Genap 2019/2020", "75" }); } }
protected void Page_Load(object sender, EventArgs e) { fileUrl = Server.MapPath(".") + "\\patch_Data\\update.sql"; bool done = bool.Parse(Setup.Patch.Get("db_updated")); btnRunSQL.Enabled = !done; lblDBCreation.Visible = done; lnkNext.Visible = done; if (!done) { string templateUrl = Server.MapPath(".") + "\\patch_Data\\update_template.sql"; StreamReader sr = new StreamReader(templateUrl); StreamWriter sw = new StreamWriter(fileUrl, false); try { dbDataContext db = new dbDataContext(); int first_group = db.sub_units.First().id; while (!sr.EndOfStream) sw.WriteLine(sr.ReadLine().Replace("_REPLACE_", first_group.ToString())); } catch (Exception ex) { lblOutput.Text = "An error occured: " + ex.ToString(); lblOutput.CssClass = "error"; } finally { sr.Close(); sr.Dispose(); sw.Close(); sw.Dispose(); } } }
public String[] ComputeGuildsItemLevel(String dbAddress, String realmName) { GuildDictionary dataFromBase = new GuildDictionary(); List<String> list = new List<String>(); dbDataContext cont = new dbDataContext(dbAddress); var data = cont.CharInfos.Where(x => x.realm == realmName).ToList(); foreach (CharInfo ci in data) { dataFromBase.Add(ci.realm, ci.guild, ci.name, (int)ci.itemLevel, ci.role); } int result = 0; foreach(var guild in dataFromBase.Get()) { RaidCounter rc = new RaidCounter(); foreach(var character in guild.Value) { result += character.itemLevel; rc.AddCharacterRole(character.role); if (rc.isEnough()) break; } result /= rc.Count(); list.Add(guild.Key + " - " + result.ToString()); } return list.ToArray(); }
public static string GetInfo(int ID) { using (dbDataContext db = new dbDataContext()) { var list = db.Business.Where(x => x.ID == ID).Select(x => new { x.ID, x.Industry, x.IsFixed, x.IsMove, x.Areas, x.Levels, //等级 x.AddTime, x.LastTime, //最后更新时间 x.CompanyName, x.CustomerScale, x.CompanyAddress, x.IsHavePhoneList, x.Remark,//备注 Contacts = x.Contacts.Select(y => new { y.Name, y.Post, y.Tel }) }).FirstOrDefault(); var result = JsonConvert.SerializeObject(new { data = list, stste = 1, msg = "成功" }); return(result); } }
public Table <mediador> getTable() { dbDataContext db = getDataContext(); Table <mediador> tb = db.GetTable <mediador>(); return(tb); }
public bool InserirAtualizar(cidade a) { // função para cadastrar cidade try { Table <cidade> tb = getTable(); dbDataContext db = getDataContext(); if (a.id == 0) { tb.InsertOnSubmit(a); tb.Context.SubmitChanges(); } else { db.alteraCidade(a.id, a.nome, a.estado); tb.Context.SubmitChanges(); } return(true); } catch { return(false); } }
public bool InserirAtualizar(mediador a) { // função para cadastrar ou atualizar mediador try { Table <mediador> tb = getTable(); dbDataContext db = getDataContext(); if (a.alcance == "") { Local_Model local_m = new Local_Model(); // se o alcance vier em branco, então pega o numero_opm do local selecionado // permitindo que o mediador tenha controle somente daquele local a.alcance = local_m.Obter(a.id_local).numero_opm; } if (a.id == 0) { db.cadMediador(a.nome, a.patente, a.id_local, a.usuario, a.senha, a.ativo, a.nivel_permissao, a.alcance, a.RE); tb.Context.SubmitChanges(); } else { db.alteraMediador(a.id, a.nome, a.patente, a.id_local, a.usuario, a.senha, a.ativo, a.nivel_permissao, a.alcance, a.RE); tb.Context.SubmitChanges(); } return(true); } catch (Exception e) { message = e.Message; return(false); } }
private void Refresh() { using (var db = new dbDataContext()) { int userId = (from u in db.Users where u.Username == Properties.Settings.Default.userName select u.ID).FirstOrDefault(); Properties.Settings.Default.userId = userId; var myFollows = (from p in db.Friends where p.Follower == userId select p.Following).ToList(); ; var postitems = (from p in db.Posts where p.User.ID == userId || myFollows.Contains(p.User.ID) select new { p.ID, User_Name = p.User.Name, p.Type, p.Text, Location = p.Location1.Name + " In " + p.Location1.City1.Name, Attach = p.AttachAddress, Like = p.Likes.ToList().Count + " Like" }).ToList(); posts.ItemsSource = postitems; posts.SelectedValuePath = "ID"; } }
public List <mediador> Listar(string alcance) { message = ""; try { using (dbDataContext db = getDataContext()) { Table <mediador> tb = getTable(); // para buscar somente dos locais que começam com o alcance // ex: 255% terá como resultado todos que começam com 255 alcance = alcance + "%"; // faz a busca trazendo os ativos String sSql = "select m.* from mediadores m " + " join locais l on (l.id = m.id_local) " + " where (m.ativo = 1) and (l.numero_opm like {0} )"; var query = db.ExecuteQuery <mediador>(sSql, alcance); return(query.ToList()); } } catch (Exception e) { message = e.Message; return(null); } }
public IHttpActionResult CheckStoreName(string data, string secret) { try { using (dbDataContext db = new dbDataContext()) { //真实的参数 var parameters = Common.AesDecryp.GetAesDecryp(data, secret); var StoreName = parameters["StoreName"]; if (!string.IsNullOrEmpty(StoreName)) { var list = db.Store.Where(x => x.StoreName.Contains(StoreName)).Select(x => x.StoreName).ToList(); if (list.Count > 0) { return(Json(new { state = 0, msg = "门店名称重复" })); } return(Json(new { state = 1, msg = "门店名称可用" })); } return(Json(new { state = 0, msg = "门店名称为空" })); } } catch (Exception ex) { throw ex; } }
public static string Get(string Areas, string Post, string Search, string pageIndex) { using (dbDataContext db = new dbDataContext()) { int pageSize = 10; var list = db.Users.Where(x => x.Name != "admin").Select(x => new { x.ID, x.Areas, x.AddTime, x.Grids, x.Mobile, x.Name, x.Post, x.Pwd, x.Remark }); if (!string.IsNullOrEmpty(Search)) { list = list.Where(t => t.Name.Contains(Search) || t.Mobile.Contains(Search)); } if (!string.IsNullOrEmpty(Areas)) { list = list.Where(t => t.Areas == Areas); } if (!string.IsNullOrEmpty(Post)) { list = list.Where(t => t.Post == Post); } var list1 = list.Skip((int.Parse(pageIndex) - 1) * pageSize).Take(pageSize); var result = new { status = "1", data = list1, pagecount = list.Count().ToString(), pagesize = pageSize.ToString() }; string list2 = new JavaScriptSerializer().Serialize(result); return(list2); } }
public static string Get(string Areas, string Search, string pageIndex, string mouth) { using (dbDataContext db = new dbDataContext()) { int pageSize = 10; var list = db.Reports.Where(x => x.Month == mouth); if (!string.IsNullOrEmpty(Search)) { list = list.Where(t => t.Name.Contains(Search) || t.Grids.Contains(Search)); } //if (!string.IsNullOrEmpty(Month)) //{ // list = list.Where(x => x.Month == Month); //} if (!string.IsNullOrEmpty(Areas)) { var areaUserList = db.Users.Where(x => x.Areas == Areas).Select(x => x.Name).ToList();//区县内所有人 list = list.Where(x => areaUserList.Contains(x.Name)); } var resultList = list .OrderByDescending(x => x.Month) .ThenBy(x => x.Rank) .Skip((int.Parse(pageIndex) - 1) * pageSize).Take(pageSize).Select(x => new { x.ID, x.Grids, x.Month, x.Name, x.Rank, x.NewIncome, x.R0Aims, x.R0CompleteRate, x.R2Aims, x.R2CompleteRate, x.StockIncome, x.StockIncomeRate, x.TotalIncome, }).ToList() .Select(x => new { x.ID, x.Grids, x.Month, x.Name, x.Rank, NewIncome = Convert.ToDouble(x.NewIncome).ToString("0.00"), R0Aims = Convert.ToDouble(x.R0Aims).ToString("0.00"), R0CompleteRate = (Convert.ToDouble(x.R0CompleteRate) * 100).ToString("0.00"), R2Aims = Convert.ToDouble(x.R2Aims).ToString("0.00"), R2CompleteRate = (Convert.ToDouble(x.R2CompleteRate) * 100).ToString("0.00"), StockIncome = Convert.ToDouble(x.StockIncome).ToString("0.00"), StockIncomeRate = (Convert.ToDouble(x.StockIncomeRate) * 100).ToString("0.00"), TotalIncome = Convert.ToDouble(x.TotalIncome).ToString("0.00"), }); var result = new { status = "1", data = resultList, pagecount = list.Count().ToString(), pagesize = pageSize.ToString() }; string list2 = new JavaScriptSerializer().Serialize(result); return(list2); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { dbDataContext db1 = new dbDataContext(); var departmentInfo = db1.GetTable <S_Department_Info>(); var departmentid = from t in departmentInfo where t.DepartmentName == "培训部" select t.id; foreach (var i in departmentid) { // Response.Write(i); HiddenField1.Value = i.ToString(); } int lessonId = Convert.ToInt32(Request["Id"]); if (lessonId != -1) //projectedit页面定死的,"-1"为"新建"状态 { //HF_SupplierID.Value = context.train_lesson_basicInfo.SingleOrDefault(item => item.Id == lessonId).Id.ToString(); //InitControlValuesForEdit(lessonId); hide_lesson_id.Value = lessonId.ToString(); //编辑时允许上传文件 } else { InitControlValuesForNew(); //新建时不许上传文件 } } }
/// <summary> /// Validate client user /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> public ClientUser ValidateClientUser(string username, string password) { var context = new dbDataContext(); // Set up the query to retrieve client user var clientUser = context.tbl_ClientUsers.FirstOrDefault(t => t.IsActive && String.Compare(t.Email, username, StringComparison.OrdinalIgnoreCase) == 0 && String.Compare(t.Password, password, StringComparison.OrdinalIgnoreCase) == 0); if (clientUser != null) { var cUser = new ClientUser { ClientId = clientUser.ClientId, ClientUserId = clientUser.ClientUserId, Email = clientUser.Email, Forename = clientUser.Forename, Surname = clientUser.Surname, Password = clientUser.Password, Telephone = clientUser.Telephone, JobTitle = clientUser.JobTitle, Mobile = clientUser.Mobile, IosApp = clientUser.IosApp, Published = clientUser.IsActive, CreatedDate = clientUser.CreatedDate }; var docs = Documents.GetDocumentByDocType(new[] { 9 }, clientUser.ClientUserId).ToList(); if (docs.Count > 0) { cUser.ProfileImage = docs[0]; } return cUser; } return null; }
public IHttpActionResult Details(string data, string secret) { try { var parameters = Common.AesDecryp.GetAesDecryp(data, secret); int ID = Convert.ToInt32(parameters["ID"]); using (dbDataContext db = new dbDataContext()) { var list = db.Users.Where(x => x.ID == ID).Select(x => new { x.ID, x.Name, x.Mobile, x.Post, x.Pwd, x.Roles.RoleName, x.Remark, x.Areas }).FirstOrDefault(); return(Json(new { data = list, msg = "请求成功", state = 1 })); } } catch (Exception ex) { //return Json(new { state = 0, msg = "请求失败" }); throw ex; } }
public static string BatchDel(string ids) { using (dbDataContext db = new dbDataContext()) { // string msg = "删除失败"; //string[] strArray = ids.Split(','); //int[] intArray = Array.ConvertAll<string, int>(strArray, x => Convert.ToInt32(x)); //bool result = bll.Delete(x => intArray.Contains(x.ID)); //// var ss = bll.Modify(x => intArray.Contains(x.ID)); //if (result) //{ // state = "true"; // msg = "删除成功"; //} //return Json(new { state = state, msg = msg }); string result = ""; string[] strArray = ids.Split(','); int[] intArray = Array.ConvertAll <string, int>(strArray, x => Convert.ToInt32(x)); var item = db.Project.Where(x => intArray.Contains(x.ID)).ToList(); db.Project.DeleteAllOnSubmit(item); OperateLog opermodel = new OperateLog(); opermodel.Operator = Common.TCContext.Current.OnlineRealName.ToString(); //操作人 opermodel.OperTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //操作时间 opermodel.OperType = "批量删除"; //操作类型 opermodel.Operdescribe = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + Common.TCContext.Current.OnlineRealName + "进行了批量删除操作"; db.SubmitChanges(); result = JsonConvert.SerializeObject(new { msg = "删除成功", stste = 1 }); return(result); } }
public IHttpActionResult SendCode([FromBody] RequestModel req) { try { var parameters = Common.AesDecryp.GetAesDecryp(req.data, req.secret); var mobile = parameters["Mobile"]; using (dbDataContext db = new dbDataContext()) { var strCode = GetCode(); //验证码 var mailService = new Mafly.Mail.Mail(); //发送邮件 mailService.Send("sss1345156413" + "@qq.com", "衡水商机", "验证码", "<h2>" + strCode + "</h2>"); var code = new VCode(); code.Mobile = mobile; code.Code = strCode; code.AddTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); code.Flag = false; db.VCode.InsertOnSubmit(code); db.SubmitChanges(); return(Json(new { msg = "发送成功", state = 1 })); } } catch (Exception ex) { throw new Exception("发送失败,请稍后重试"); } }
public Table <tipo_registro> getTable() { dbDataContext db = getDataContext(); Table <tipo_registro> tb = db.GetTable <tipo_registro>(); return(tb); }
/// <summary> /// 已读 /// </summary> /// <param name="req"></param> /// <returns></returns> public IHttpActionResult Read([FromBody] Models.RequestModel req) { try { using (dbDataContext db = new dbDataContext()) { var parameters = Common.AesDecryp.GetAesDecryp(req.data, req.secret); var BusID = Convert.ToInt32(parameters["BusID"]);//商机提醒ID var bus = db.Business.Where(x => x.ID == BusID).FirstOrDefault(); if (bus != null) { bus.IsRead = 1;//已读 db.SubmitChanges(); return(Json(new { stata = 1, msg = "请求成功" })); } return(Json(new { stata = 0, msg = "商机不存在" })); } } catch (Exception ex) { //return Json(new { state = 0, msg = "请求失败" }); throw ex; } }
public static string GetVisit(int ID) { using (dbDataContext db = new dbDataContext()) { string[] imgNULL = { }; var list = db.Business.Where(x => x.ID == ID).Select(x => new { Visit = x.Visit.Select(y => new { y.IsAgain, y.IsLeader, y.IsNeed, y.Leader, y.NextTime, y.State, Img = y.Img != null ? y.Img.Split(';') : imgNULL, y.VisitTime, y.VisitContent, UserName = y.Users.Name, UserTel = y.Users.Mobile, RemindID = y.BusRemind.Where(t => t.Type == 3 && t.State == 0).OrderByDescending(t => t.ID).Select(t => new { RemindID = t.ID, t.AddTime, }).FirstOrDefault() != null ? y.BusRemind.Where(t => t.Type == 3 && t.State == 0).OrderByDescending(t => t.ID).Select(t => new { RemindID = t.ID, t.AddTime, }).FirstOrDefault().RemindID : 0,//走访提醒 }) }).FirstOrDefault(); var result = JsonConvert.SerializeObject(new { data = list, stste = 1, msg = "成功" }); return(result); } }
public Profile() { InitializeComponent(); using (var db = new dbDataContext()) { var user = (from u in db.Users where u.ID == UserId select u).FirstOrDefault(); name.Content = user.Name; bio.Content = user.Bio; var postitems = (from p in db.Posts where p.User.ID == user.ID select new { User_Name = p.User.Name, p.Type, p.Text }).ToList(); if (user.ProfilePhotoAddress != null && user.ProfilePhotoAddress.Length > 0) { photo.Source = new BitmapImage(new Uri(user.ProfilePhotoAddress)); } if (UserId == Properties.Settings.Default.userId) { follow.Visibility = Visibility.Hidden; } else { } Followed = Follow_Check(); posts.ItemsSource = postitems; } }
public Table <cidade> getTable() { dbDataContext db = getDataContext(); Table <cidade> tbCidade = db.GetTable <cidade>(); return(tbCidade); }
/// <summary> /// Thsis function returns the list of all the templates /// </summary> /// <param name="filters"></param> /// <returns></returns> public List<Template> GetTemplates(TemplateFilter filters) { var context = new dbDataContext(); var templateIds = string.IsNullOrEmpty(filters.TemplateIds) ? new List<string>() : filters.TemplateIds.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToList(); var templates = (from t in context.tbl_Templates where (t.Deleted == filters.Deleted && (filters.ClientId == 0 || t.ClientId == filters.ClientId) && (string.IsNullOrEmpty(filters.TemplateIds) || templateIds.Contains(t.TemplateId.ToString())) && (string.IsNullOrEmpty(filters.Title) || t.Title.ToLower().Equals(filters.Title.ToLower()))) select new Template { TemplateId = t.TemplateId, Title = t.Title, ApplicationStatusId = t.ApplicationStatusId, Deleted = t.Deleted, Published = t.Published, ClientId = t.ClientId, Subject = t.Subject, TemplateBody = t.Template, CreatedDate = t.CreatedDate, TemplateTypeId = t.TemplateTypeId, ApplicationStatus = new ApplicationStatuses().GetApplicationStatusName(t.ApplicationStatusId) }); return templates.ToList(); }
public Table <solicitacao> getTable() { dbDataContext db = getDataContext(); Table <solicitacao> tb = db.GetTable <solicitacao>(); return(tb); }
/// <summary> /// This function validates the user /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> public User ValidateUser(string username, string password) { var context = new dbDataContext(); // Set up the query to retrieve user var user = context.tbl_Users.FirstOrDefault(t => String.Compare(t.Email, username, StringComparison.OrdinalIgnoreCase) == 0 && String.Compare(t.Password, password, StringComparison.OrdinalIgnoreCase) == 0 && !t.Deleted && t.IsActive); if (user != null) { var cUser = new User { UserId = user.UserId, Forename = user.Forename, Surname = user.Surname, JobTitle = user.JobTitle, Email = user.Email, Password = user.Password, Telephone = user.Telephone, CreatedDate = user.CreatedDate, Fax = user.Fax, Mobile = user.Mobile, FullName = user.Forename + " " + user.Surname, Deleted = user.Deleted, IsActive = user.IsActive, CalendarColor = user.CalendarColor, UserType = GetUserType(user.UserType) }; var docs = Documents.GetDocumentByDocType(new[] { 10 }, cUser.UserId).ToList(); if (docs.Count > 0) { cUser.ProfileImage = docs[0]; } return cUser; } return null; }
/// <summary> /// 查询移动业务 /// </summary> /// <returns></returns> public static string GetMove(int ID) { using (dbDataContext db = new dbDataContext()) { var list = db.Business.Where(x => x.ID == ID && x.IsMove == true).Select(x => new { x.MAgeGroup, x.MCardUse, x.MFocus, x.MIncome, x.MIsSubsidy, x.MMonthFee, x.MOperator, x.MOtherWork, x.MOverTime, x.MPolicy, x.MPushWork, x.MQuota, x.MRange, x.MRatio }).FirstOrDefault(); var result = JsonConvert.SerializeObject(list); return(result); } }
public Table <depoimento> getTable() { dbDataContext db = getDataContext(); Table <depoimento> tb = db.GetTable <depoimento>(); return(tb); }
public static void Add(dbDataContext db, string unitName) { unit newUnit = new unit(); newUnit.unit_name = unitName; db.units.InsertOnSubmit(newUnit); db.SubmitChanges(); }
public static void Edit(dbDataContext db, int id, string q, string a) { faq f = Get(db, id); f.title = q; f.body = a; db.SubmitChanges(); }
public static IEnumerable<unit> List(dbDataContext db, int access_level) { return (from p in db.sub_units where p.access_level <= access_level orderby p.unit.unit_name select p.unit).Distinct(); }
void LoadWidgets() { dbDataContext objCtx = new dbDataContext(); var query = objCtx.tbl_UserWidgets.Where(x => x.UserId == LoginUser.GetLoggedInUserId()).OrderBy(x => x.Ordering).ToList(); rptWidget.DataSource = query; rptWidget.DataBind(); }
public static void AddGroup(dbDataContext db, string ad_group, int access_level) { user_group ug = new user_group(); ug.ad_group = ad_group; ug.security_level = access_level; db.user_groups.InsertOnSubmit(ug); db.SubmitChanges(); }
public static void Add(dbDataContext db, string q, string a) { faq f = new faq(); f.title = q; f.body = a; db.faqs.InsertOnSubmit(f); db.SubmitChanges(); }
public static IEnumerable<ticket> List(dbDataContext db, bool? active, bool ?open) { return from p in GetTickets(db, active) where (open == null ? true : ((bool)open ? p.closed == DateTime.Parse("1/1/2001") : p.closed != DateTime.Parse("1/1/2001"))) select p; }
protected void Page_Load(object sender, EventArgs e) { if (!Convert.ToBoolean(Utils.Settings.Get("installed"))) Response.Redirect("~/setup/"); side_bar.CssClass = Utils.Settings.Get("sidebar"); main_container.CssClass = Utils.Settings.Get("sidebar").Equals("left") ? "right" : "left"; if (Utils.Settings.Get("title").Length > 0) this.Page.Title = Utils.Settings.Get("title") + " :: " + this.Page.Title; else lblTitle.Visible = false; lblTitle.Text = Utils.Settings.Get("title"); imgTitle.ImageUrl = Utils.Settings.Get("image"); if (Utils.Settings.Get("image").Length < 1) imgTitle.Visible = false; db = new dbDataContext(); string userName = Utils.UserName(); userIsRegistered = Users.Exists(db, userName); lblUserName.Controls.Add(new LiteralControl(userName)); try { user thisUser = Users.Get(db, userName); lblUserName.Controls.Add(new LiteralControl("<div class='smaller' style='font-weight:normal;'>")); int myTickets = Tickets.MyTickets(db, thisUser.id).Count(); int groupTix = Tickets.MyGroupsTickets(db, thisUser).Count(); this.myIssues(lblTickets, myTickets, groupTix); lblUserName.Controls.Add( new LiteralControl("</div>")); if (thisUser.is_admin) isAdmin = true; lblEmail.Text = "<a href='mailto:" + thisUser.email + "'>" + Utils.TrimForSideBar(thisUser.email, 25) + "</a>"; lblPhone.Text = thisUser.phone; lblUnit.Controls.Add(new HyperLink() { Text = thisUser.sub_unit1.unit.unit_name, NavigateUrl = "~/search.aspx?group=" + thisUser.sub_unit1.unit_ref }); lblSubUnit.Controls.Add(new HyperLink() { Text = thisUser.sub_unit1.sub_unit_name, NavigateUrl = "~/search.aspx?group=" + thisUser.sub_unit1.unit_ref + "&subgroup=" + thisUser.sub_unit }); //this.myIssues(lblSubUnit, Tickets.MyGroupsTickets(db, thisUser).Count()); string accessName; int accessLevel; user_group ugAccessLevel = Utils.AccessLevel(); if (ugAccessLevel == null) { accessLevel = 0; accessName = Resources.Common.NoAccess; } else { accessLevel = ugAccessLevel.security_level; accessName = string.IsNullOrEmpty(ugAccessLevel.security_level1.security_level_name) ? "<i>" + Resources.Common.Undefined + "</i>" : ugAccessLevel.security_level1.security_level_name; } lblAccess.Text = accessLevel.ToString(); lblAccessName.Text = accessName; } catch { userIsRegistered = false; lblPhone.CssClass = Resources.Common.Error; lblPhone.Text = GetLocalResourceObject("PleaseUpdate").ToString(); } setMenu(); }
public static void Update(dbDataContext db, string name, string email, string phone, int _sub_unit) { user thisUser = db.users.First(u => u.userName.Equals(name)); thisUser.userName = name; thisUser.email = email; thisUser.phone = phone; thisUser.sub_unit = _sub_unit; db.SubmitChanges(); }
/// <summary> /// Delete client notes /// </summary> /// <param name="clientNoteId"></param> /// <returns></returns> public bool DeleteClientNote(int clientNoteId) { var context = new dbDataContext(); var clientNote = context.tbl_ClientNotes.FirstOrDefault(t => t.ClientNoteId == clientNoteId); if (clientNote == null) return false; context.tbl_ClientNotes.DeleteOnSubmit(clientNote); context.SubmitChanges(); return true; }
/// <summary> /// This function returns the salaries /// </summary> /// <returns></returns> public IEnumerable<Salary> GetSalaries() { var salaries = new dbDataContext().tbl_Salaries.ToList().Select(t => new Salary() { SalaryId = t.SalaryId, SalaryValue = t.Salary }); return salaries; }
protected void Page_Load(object sender, EventArgs e) { this.Title = Resources.Common.Admin + " - " + Resources.Common.Statistics; db = new dbDataContext(); if (!IsPostBack) { this.groups(); } }