public bool PlaceOrder(PlaceOrders p)
{
using (Entities5 c = new Entities5())
{
Place_Order reg = new Place_Order
{
rupya = p.rupya,
ph = p.ph,
paisa = p.paisa,
firstname = p.firstname,
lastname = p.lastname,
email = p.email,
countrycode = p.countrycode,
country = p.country,
buyerfname = p.buyerfname,
buyerlname = p.buyerlname,
address = p.address,
state = p.state,
pin = p.pin
};
c.Place_Order.Add(reg);
c.SaveChanges();
}
return(true);
}
public object ViewOrders(string username)
{
using (Entities5 c = new Entities5())
{
var items = c.Place_Order.Where(x => x.buyerfname == username)
.Select(x => new
{
rupya = x.rupya,
address = x.address,
buyerfname = x.rupya,
firstname = x.firstname,
//paisa = p.paisa,
//firstname = p.firstname,
//lastname = p.lastname,
//email = p.email,
//countrycode = p.countrycode,
//country = p.country,
//buyerfname = p.buyerfname,
//buyerlname = p.buyerlname,
//address = p.address,
//state = p.state,
//pin = p.pin
//username = x.Username,
//password = x.Email
});
var JSONA = JsonConvert.SerializeObject(items);
return(JSONA);
}
return(false);
}
public string addMessage(string str, string textOfMess)
{
string toWhom = str;
string fromWhom = User.Identity.Name.ToString();
string write_messages = "";
StreamWriter w = new StreamWriter(@"E:\logWebSite5.txt");
w.WriteLine(write_messages);
w.Close();
Mesage message = new Mesage();
message.towhom = toWhom;
message.fromwhom = fromWhom;
message.read = 0;
message.message = textOfMess;
message.date = DateTime.Now;
using (var db = new Entities5())
{
if (0 < db.Mesages.Count())
{
message.Id = db.Mesages.Select(m => m.Id).ToList().Max() + 1;
}
else
{
message.Id = 0;
}
db.Mesages.Add(message);
db.SaveChanges();
refreshChat(toWhom);
return(write_messages);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
AspNetUser changedUser;
StreamWriter wr = new StreamWriter(@"E:\logWebSite5.txt", true);
wr.WriteLine("btnDelete_Click()");
wr.WriteLine(CheckBoxList2.Items.ToString());
foreach (ListItem item in CheckBoxList2.Items)
{
if (item.Selected)
{
using (var db = new Entities5())
{
changedUser = db.AspNetUsers.Where(m => m.Id == item.Value).First();
changedUser.ManagerRights = false;
db.SaveChanges();
wr.WriteLine("item value " + item.Value.ToString());
wr.WriteLine("changedUser " + changedUser.UserName.ToString());
}
}
}
wr.Close();
Response.Redirect("/MyFiles/Managers.aspx");
}
public IHttpActionResult getsummary(string id)
{
List <distr_summary_Result> x = new List <distr_summary_Result>();
var test = new Entities5();
var reslist = test.distr_summary(id).ToList();
foreach (var pen in reslist.ToList())
{
x.Add(
new distr_summary_Result
{
DISTR_ID = pen.DISTR_ID,
NAME = pen.NAME,
sponser_id = pen.sponser_id,
sponser_name = pen.sponser_name,
area = pen.area,
count = pen.count,
PER_BP = pen.PER_BP,
RATIO = pen.RATIO,
//Group_bp = pen.Group_bp,
SUM = pen.SUM
});
}
return(Ok(x));
}
protected void Page_Load(object sender, EventArgs e)
{
if (User.Identity.Name.ToString() == "")
{
Response.Redirect("/Default.aspx");
}
AspNetUser currentUser = new AspNetUser();
car currentCar = new car();
List <car> listAvto = new List <car>();
List <AspNetUser> listUsers = new List <AspNetUser>();
List <order> listOrder = new List <order>();
using (var db = new Entities5())
{
listUsers = db.AspNetUsers.ToList();
foreach (AspNetUser m in listUsers)
{
if (m.UserName == User.Identity.Name.ToString())
{
currentUser = m;
}
}
}
using (var db = new workshopEntities())
{
if (db.cars.Where(m => (m.client.email == currentUser.Email)).Count() > 0)
{
listAvto = db.cars.Where(m => (m.client.email == currentUser.Email)).ToList();
currentCar = listAvto[0];
listOrder = db.orders.Where(m => (m.Car_idCar == currentCar.idCar)).ToList();
}
}
DropDownList1.DataSource = listAvto;
DropDownList1.DataTextField = "registrNumber";
DropDownList1.DataValueField = "idCar";
DropDownList2.DataSource = listOrder;
DropDownList2.DataTextField = "dateTime";
DropDownList2.DataValueField = "idOrder";
if (!IsPostBack)
{
DropDownList1.DataBind();
DropDownList2.DataBind();
}
fillTable();
//fillTable();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox3.Text != "")
{
string toWhom = "all";
string fromWhom = "";
if (TextBox2.Text == "")
{
fromWhom = "Гість";
}
else
{
fromWhom = TextBox2.Text;
}
Mesage message = new Mesage();
String write_messages = "";
message.towhom = toWhom;
message.fromwhom = fromWhom;
message.read = 0;
message.message = TextBox3.Text;
message.date = DateTime.Now;
using (var db = new Entities5())
{
System.Diagnostics.Debug.WriteLine("MESSAGE : " + db.Mesages.Count().ToString());
if (0 < db.Mesages.Count())
{
message.Id = db.Mesages.Select(m => m.Id).ToList().Max() + 1;
}
else
{
message.Id = 0;
}
db.Mesages.Add(message);
db.SaveChanges();
List <Mesage> messageHistory = db.Mesages.Where(m => (m.towhom.ToString() == toWhom)).ToList();
messageHistory.Reverse();
foreach (Mesage m in messageHistory)
{
write_messages += m.fromwhom + "(" + m.date.Value.ToShortTimeString().ToString() + "):" + "\n";
write_messages += " " + m.message + "\n";
}
}
TextBox1.Text = write_messages;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (User.Identity.Name.ToString() == "")
{
Response.Redirect("/Default.aspx");
}
List <AspNetUser> listUsers = new List <AspNetUser>();
List <AspNetUser> listManagers = new List <AspNetUser>();
AspNetUser potochnuj = new AspNetUser();
StreamWriter wr = new StreamWriter(@"E:\logWebSite5.txt", true);
wr.WriteLine("Page_Load()");
using (var db = new Entities5())
{
listUsers = db.AspNetUsers.Where(m => m.ManagerRights != true).ToList();
listManagers = db.AspNetUsers.Where(m => m.ManagerRights == true).ToList();
foreach (AspNetUser m in listManagers)
{
wr.WriteLine("m.UserName = "******" User.Identity.Name.ToString())" + User.Identity.Name.ToString());
if (m.UserName == User.Identity.Name.ToString())
{
potochnuj = m;
}
}
}
wr.Close();
listManagers.Remove(potochnuj);
CheckBoxList1.DataSource = listUsers;
CheckBoxList1.DataTextField = "UserName";
CheckBoxList1.DataValueField = "Id";
CheckBoxList2.DataSource = listManagers;
CheckBoxList2.DataTextField = "UserName";
CheckBoxList2.DataValueField = "Id";
if (!IsPostBack)
{
CheckBoxList1.DataBind();
CheckBoxList2.DataBind();
}
}
public ActionResult Index(user usr)
{
Entities5 dbObject = new Entities5();
var checkUser = dbObject.users.Where(l => l.user_name.Equals(usr.user_name) && l.user_password.Equals(usr.user_password)).FirstOrDefault();
if (checkUser != null)
{
var loggeduser = dbObject.users.Where(l => l.user_name.Equals(usr.user_name)).FirstOrDefault();
Session["user_name"] = loggeduser.user_name.ToString();
Session["user_id"] = loggeduser.user_id.ToString();
Session["user_type"] = loggeduser.user_type.ToString();
return(RedirectToAction("Dashboard"));
}
else
{
ViewBag.msg = "Invalid Username or Password";
}
return(View());
}
protected void Page_Load(object sender, EventArgs e)
{
if (User.Identity.Name.ToString() == "")
{
Response.Redirect("/Default.aspx");
}
List <AspNetUser> listUsers = new List <AspNetUser>();
AspNetUser potochnuj = new AspNetUser();
using (var db = new Entities5())
{
listUsers = db.AspNetUsers.ToList();
foreach (AspNetUser m in listUsers)
{
if (m.UserName == User.Identity.Name.ToString())
{
potochnuj = m;
}
}
if (potochnuj.ManagerRights == false)
{
listUsers = db.AspNetUsers.Where(m => m.ManagerRights == true).ToList();
}
else
{
//listUsers = db.AspNetUsers.ToList();
listUsers.Remove(potochnuj);
}
}
DropDownList1.DataSource = listUsers;
DropDownList1.DataTextField = "UserName";
DropDownList1.DataValueField = "Id";
if (!IsPostBack)
{
DropDownList1.DataBind();
//db.SaveChanges();
}
nickname.Text = User.Identity.Name.ToString();
}
public string refresh_comments()
{
List <Mesage> messageHistory = new List <Mesage>();
string write_messages = "";
using (var db = new Entities5())
{
string toWhom = "all";
if (db.Mesages.Select(m => (m.towhom == toWhom)).Count() > 0)
{
messageHistory = db.Mesages.Where(m => (m.towhom == toWhom)).ToList();
}
messageHistory.Reverse();
foreach (Mesage m in messageHistory)
{
write_messages += m.fromwhom + "(" + m.date.Value.ToShortTimeString().ToString() + "):" + "\n";
write_messages += " " + m.message + "\n";
}
}
return(write_messages);
}
protected void Page_Load(object sender, EventArgs e)
{
//AspNetUser currentUser = new AspNetUser();
//car currentCar = new car();
//List<car> listAvto = new List<car>();
//List<AspNetUser> listUsers = new List<AspNetUser>();
//List<order> listOrder = new List<order>();
string str = User.Identity.Name.ToString();
if (str != "")
{
using (var db = new Entities5())
{
AspNetUser User = db.AspNetUsers.Where(m => m.UserName == str).First();
if (User.ManagerRights == true)
{
ForManager.Visible = true;
}
}
}
}
public string refreshChat(string str)
{
string write_messages = "";
using (var db = new Entities5())
{
string toWhom = str;
string fromWhom = User.Identity.Name.ToString();
if (db.Mesages.Count() > 0)
{
List <Mesage> messageHistory = db.Mesages.Where(m => (m.towhom.ToString() == toWhom && m.fromwhom.ToString() == fromWhom) ||
(m.fromwhom.ToString() == toWhom && m.towhom.ToString() == fromWhom)).OrderBy(m => m.date).ToList();
messageHistory.Reverse();
foreach (Mesage m in messageHistory)
{
write_messages += m.fromwhom + "(" + m.date.Value.ToShortTimeString().ToString() + "):" + "\n";
write_messages += " " + m.message + "\n";
}
}
}
return(write_messages);
}