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();
}
}
