protected void ButtonSend_Click(object sender, EventArgs e)
{
if (workObject.Text == "" || typeOfWork.Text == "" || nameOfCost.Text == ""
|| measure.Text == "" || labour.Text == "" || materials.Text == "" || mechanisms.Text == "" ||
contractor.Text == "" || customer.Text == "")
{
Alert.Show("Пожалуйста заполните все поля");
return;
}
var db = new DBClassesDataContext();
Plan p = new Plan { Status = 3, Object = workObject.Text, WorkType = typeOfWork.Text,
CostName = nameOfCost.Text, UnitName = measure.Text, Labor = labour.Text,
Materials = materials.Text, Mechnisms = mechanisms.Text,
};
db.Plans.InsertOnSubmit(p);
try
{
db.SubmitChanges();
Alert.Show("Запись успешно добавлена");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Ошибка", "нет записи", true);
}
}
protected void Button2_Click(object sender, EventArgs e)
{
var db = new DBClassesDataContext();
var query =
from plan in db.Plans
where plan.ID == planindex
select plan;
query.ToArray()[0].Status = 2;
try
{
db.SubmitChanges();
}
catch (Exception exception)
{
Console.WriteLine(exception.StackTrace);
}
viewPlan();
string email;
try
{
email = contr[0].Email;
}
catch (Exception)
{
email = "";
}
ClientScript.RegisterStartupScript(this.GetType(), "mailto",
"<script type = 'text/javascript'>parent.location='mailto:" + email +
"'</script>");
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
user = Membership.GetUser().UserName;
}
catch (Exception ex)
{
Alert.Show("Нет прав доступа, пожалуйста зайдите как Подрядчик");
Response.Redirect("Account/Login.aspx");
}
bool hasAccess = false;
foreach (var role in Roles.GetRolesForUser())
{
if (role.Equals(Global.contractorRole)) hasAccess = true;
}
if (!hasAccess)
{
Alert.Show("Нет прав доступа, пожалуйста зайдите как Подрядчик");
Response.Redirect("Account/Login.aspx");
}
var db = new DBClassesDataContext();
var query =
from contractor in db.Contractors
where contractor.Email.Equals(user)
select contractor;
if (query != null)
{
id = query.ToArray()[0].ID;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
var db = new DBClassesDataContext();
var query =
from plan in db.Plans
where plan.ID == planindex
select plan;
query.ToArray()[0].Status = 1;
try
{
db.SubmitChanges();
}
catch (Exception exception)
{
Console.WriteLine(exception.StackTrace);
}
viewPlan();
}
protected void approve_Click(object sender, EventArgs e)
{
var db = new DBClassesDataContext();
//var query =
// from plan in db.Plans
// where plan.PlanID == int.Parse(DropDownList1.SelectedValue)
// select plan;
//query.ToArray()[0].Status = 3;
try
{
String updatePlan = "UPDATE [Plan] SET Status=3 WHERE PlanID=" + int.Parse(DropDownList1.SelectedValue);
conn.Open();
SqlCommand cmd = new SqlCommand(updatePlan, conn);
cmd.ExecuteNonQuery();
conn.Close();
var query =
from plan in db.Plans
where plan.PlanID == int.Parse(DropDownList1.SelectedValue)
select plan;
try
{
Plan[] results = null;
results = query.ToArray<Plan>();
Table1.Caption = results[0].Name + ", Одобрен";
}
catch { }
Alert.Show("Статус плана обновлён.");
approve.Visible = false;
reject.Visible = false;
}
catch { }
//try
//{
// db.SubmitChanges();
//}
//catch (Exception exception)
//{
// Console.WriteLine(exception.StackTrace);
//}
}
protected void regUser(object sender, EventArgs e)
{
TextBox userName = (TextBox)this.RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("UserName");
TextBox email = (TextBox)this.RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("Email");
TextBox password = (TextBox)this.RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("Password");
TextBox password2 = (TextBox)this.RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("ConfirmPassword");
if (userName.Text == "" || email.Text == "" || password.Text == ""
|| password2.Text == "")
{
Alert.Show("Пожалуйста, заполните все поля");
return;
}
var db = new DBClassesDataContext();
Contractor c = null;
Customer cus = null;
if (RadioButton1.Checked == true)//Заказчик
{
cus = new Customer { Name = userName.Text, Email = email.Text, Password = password.Text };
db.Customers.InsertOnSubmit(cus);
}
else //Подрядчик
{
c = new Contractor { Name = userName.Text, Email = email.Text, Password = password.Text };
db.Contractors.InsertOnSubmit(c);
}
try
{
db.SubmitChanges();
Alert.Show("Запись успешно добавлена");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Ошибка", "нет записи", true);
}
Response.Redirect("http://.../Default.aspx");
}
public IQueryable<Plan> GetPlans()
{
var db = new PlanViewer.Models.DBClassesDataContext();
IQueryable<Plan> query = db.Plans;
return query;
}
protected void gvbind()
{
conn.Open();
SqlCommand cmd = new SqlCommand("Select ID, FactObject, WorkType, UnitName, CostName, Labor, Materials, Mechanisms from Fact where FactID=" + planID, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();
}
else
{
// (Table1.Rows.Count > 1)
{
var db = new DBClassesDataContext();
var query =
from plan in db.Plans
where plan.PlanID == planID
select plan;
Plan[] plans = query.ToArray();
List<Fact> facts = new List<Fact>();
for (int i = 0; i < plans.Length; i++)
{
Fact f = new Fact { FactID = planID, CostName = plans[i].CostName, FactObject = plans[i].Object, Labor = plans[i].Labor, Materials = plans[i].Materials, Mechanisms = plans[i].Mechanisms, UnitName = plans[i].UnitName, WorkType = plans[i].WorkType, Status = 1 };
facts.Add(f);
}
db.Facts.InsertAllOnSubmit<Fact>(facts);
try
{
db.SubmitChanges();
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print(ex.StackTrace);
}
conn.Open();
cmd = new SqlCommand("Select ID, FactObject, WorkType, UnitName, CostName, Labor, Materials, Mechanisms from Fact where FactID=" + planID, conn);
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
conn.Close();
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();
}
else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
GridView1.DataSource = ds;
GridView1.DataBind();
int columncount = GridView1.Rows[0].Cells.Count;
GridView1.Rows[0].Cells.Clear();
GridView1.Rows[0].Cells.Add(new TableCell());
GridView1.Rows[0].Cells[0].ColumnSpan = columncount;
GridView1.Rows[0].Cells[0].Text = "Ошибка";
}
}
}
}
protected void sendRequest_Click(object sender, EventArgs e)
{
{
try
{
SmtpClient Smtp = new SmtpClient("smtp.gmail.com", 587); //формируем письмо
Smtp.UseDefaultCredentials = false;
Smtp.Credentials = new NetworkCredential("*****@*****.**", "techup2013");
Smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
Smtp.EnableSsl = true;
MailMessage Message = new MailMessage();
Message.From = new MailAddress("*****@*****.**");
var db = new DBClassesDataContext();
var query =
from plan in db.Plans
where plan.PlanID == planID
select plan;
Plan pl = query.First();
var query2 =
from contr in db.Contractors
where contr.ID == pl.Contractor
select contr;
Contractor ct = query2.First();
var query3 =
from cust in db.Customers
where cust.ID == id
select cust;
Customer cs = query3.First();
Message.To.Add(new MailAddress(ct.Email));
Message.Subject = "Запрос по плану: " + pl.Name + " "+ Subject.Text + " ";
Message.Body = "Заказчик: "+cs.Name +"\n" + MessageText.Text;
Smtp.Send(Message); //отправляем письмо
Alert.Show("Письмо успешно отправлено!");
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print(ex.StackTrace);
}
}
}
private void buildPlanTable()
{
for (int i = 1; i < Table1.Rows.Count; i++)
{
Table1.Rows.RemoveAt(i);
}
var db = new DBClassesDataContext();
var query =
from plan in db.Plans
where plan.PlanID == int.Parse(DropDownList1.SelectedValue)
select plan;
//query.Cast<Plan>();
Plan[] results = null;
try
{
results = query.ToArray<Plan>();
Table1.Caption = results[0].Name;
if (results[0].Status < 3 || results[0].Status==4)
{
Table1.Caption += ", " + "Не одобрен\n\n";
approve.Visible = true;
reject.Visible = true;
}
else
{
Table1.Caption += ", " + "Одобрен\n\n";
approve.Visible = false;
reject.Visible = false;
}
bool gotfacts = false;
foreach (Plan item in results)
{
var fact_query =
from fact in db.Facts
where fact.ExtPlanID == item.ID
select fact;
Fact facts;
try
{
facts = fact_query.First<Fact>();
gotfacts = true;
}
catch (Exception ex)
{
facts = new Fact { Labor = "er", Materials = "er", Mechanisms = "er" };
}
TableRow tr = new TableRow();
List<TableCell> cells = new List<TableCell>();
TableCell c = new TableCell();
c.Text = item.ID + "";
c.BorderStyle = BorderStyle.Solid;
c.BorderWidth = 1;
c.BorderColor = System.Drawing.Color.Black;
c.Visible = false;
cells.Add(c);
c = new TableCell();
c.Text = item.Object;
c.BorderStyle = BorderStyle.Solid;
c.BorderWidth = 1;
c.BorderColor = System.Drawing.Color.Black;
cells.Add(c);
c = new TableCell();
c.Text = item.WorkType;
c.BorderStyle = BorderStyle.Solid;
c.BorderWidth = 1;
c.BorderColor = System.Drawing.Color.Black;
cells.Add(c);
c = new TableCell();
c.Text = item.CostName;
c.BorderStyle = BorderStyle.Solid;
c.BorderWidth = 1;
c.BorderColor = System.Drawing.Color.Black;
cells.Add(c);
c = new TableCell();
c.Text = item.UnitName;
c.BorderStyle = BorderStyle.Solid;
c.BorderWidth = 1;
c.BorderColor = System.Drawing.Color.Black;
cells.Add(c);
c = new TableCell();
c.Text = item.Labor;
c.BorderStyle = BorderStyle.Solid;
c.BorderWidth = 1;
c.BorderColor = System.Drawing.Color.Black;
cells.Add(c);
c = new TableCell();
c.Text = facts.Labor;
c.BorderStyle = BorderStyle.Solid;
c.BorderWidth = 1;
c.BorderColor = System.Drawing.Color.Black;
c.BackColor = System.Drawing.Color.PowderBlue;
cells.Add(c);
c = new TableCell();
c.Text = item.Materials;
c.BorderStyle = BorderStyle.Solid;
c.BorderWidth = 1;
c.BorderColor = System.Drawing.Color.Black;
cells.Add(c);
c = new TableCell();
c.Text = facts.Materials;
c.BackColor = System.Drawing.Color.PowderBlue;
c.BorderStyle = BorderStyle.Solid;
c.BorderWidth = 1;
c.BorderColor = System.Drawing.Color.Black;
cells.Add(c);
c = new TableCell();
c.Text = item.Mechanisms;
c.BorderStyle = BorderStyle.Solid;
c.BorderWidth = 1;
c.BorderColor = System.Drawing.Color.Black;
cells.Add(c);
c = new TableCell();
c.Text = facts.Mechanisms;
c.BackColor = System.Drawing.Color.PowderBlue;
c.BorderStyle = BorderStyle.Solid;
c.BorderWidth = 1;
c.BorderColor = System.Drawing.Color.Black;
cells.Add(c);
c = new TableCell();
c.Text = item.Status + "";
c.BorderStyle = BorderStyle.Solid;
c.BorderWidth = 1;
c.BorderColor = System.Drawing.Color.Black;
c.Visible = false;
//c.Enabled = true;
cells.Add(c);
foreach (TableCell cell in cells)
{
tr.Cells.Add(cell);
}
Table1.Rows.Add(tr);
planID = int.Parse(DropDownList1.SelectedValue);
}
if (!gotfacts)
{
foreach (TableRow tr in Table1.Rows)
{
tr.Cells[6].Visible = false;
tr.Cells[8].Visible = false;
tr.Cells[10].Visible = false;
}
}
else
{
foreach (TableRow tr in Table1.Rows)
{
tr.Cells[6].Visible = true;
tr.Cells[8].Visible = true;
tr.Cells[10].Visible = true;
}
}
}
catch (FormatException fe)
{
Table1.Visible = false;
return;
}
}
protected void registerCustomer(object sender, EventArgs e)
{
string name = CustomerName.Text;
string email = CustomerEmail.Text;
string pas = CustomerPassword.Text;
string pas2 = CustomerPassword2.Text;
if (!pas.Equals(pas2))
{
Alert.Show("Пароли не совпадают!");
return;
}
if (name == "" || email == "" || pas == ""
|| pas2 == "")
{
Alert.Show("Пожалуйста, заполните все поля");
return;
}
if (pas.Length < 6)
{
Alert.Show("Пароль должен состоять не менее чем из 6 символов");
return;
}
var db = new DBClassesDataContext();
Customer c = new Customer { Name = name, Email = email, Password = pas, Info = "", Address=""};
db.Customers.InsertOnSubmit(c);
try
{
db.SubmitChanges();
//отправляем письмо
string emailString = email;
string subject = "Регистрация в системе";
string text = "Здравствуйте, " + name + "!" + ".\n" +
"Вы успешно зарегистрированы в системе взаимодействия подрядчиков и заказчиков." + ".\n" +
"Ваша роль в системе: заказчик " + "\nС уважением, администрация сервиса.";
sendEmail(emailString, subject, text);
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Ошибка", "нет записи", true);
System.Diagnostics.Debug.Print(ex.StackTrace);
return;
}
try
{
Membership.CreateUser(email, pas);
FormsAuthentication.SetAuthCookie(email, true);
Roles.AddUserToRole(email, Global.customerRole);
Response.Redirect("../ViewPlan.aspx");
//Alert.Show("Запись успешно добавлена");
}
catch (Exception ex)
{
Alert.Show("Пользователь с таким email уже зарегистрирован!");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
user = Membership.GetUser().UserName;
}
catch (Exception ex)
{
Alert.Show("Нет прав доступа, пожалуйста зайдите как Подрядчик");
Response.Redirect("Account/Login.aspx");
}
bool hasAccess = false;
foreach (var role in Roles.GetRolesForUser())
{
if (role.Equals(Global.contractorRole)) hasAccess = true;
}
if (!hasAccess)
{
Alert.Show("Нет прав доступа, пожалуйста зайдите как Подрядчик");
Response.Redirect("Account/Login.aspx");
}
var db = new DBClassesDataContext();
var query =
from contractor in db.Contractors
where contractor.Email.Equals(user)
select contractor;
if (query != null)
{
id = query.ToArray()[0].ID;
}
providerstring = "SELECT Customer.Name, [Plan].PlanID FROM Contractor INNER JOIN [Plan] ON Contractor.ID = [Plan].Contractor INNER JOIN Customer ON [Plan].Customer = Customer.ID where Contractor.ID=10 GROUP BY [Plan].PlanID , Customer.Name";
SqlDataSource1.SelectCommand = string.Format(providerstring);
DataBind();
//Session["UserID"] = id;
//DropDownList1.DataBind();
try
{
if (int.Parse(DropDownList1.SelectedValue) > 0)
buildPlanTable();
}
catch
{
}
if (!Page.IsPostBack)
{
gvbind();
}
}
protected void contRPass_Click(object sender, EventArgs e)
{
string email = femailco.Text;
email = email.ToLower();
if (email == "")
{
Alert.Show("Введите email!");
}
string connectionStr = WebConfigurationManager.ConnectionStrings["TeamProjectDBConnectionString1"].ConnectionString;
SqlConnection con = new SqlConnection(connectionStr);
con.Open();
string sqlUserName = "******" + email+"'";
SqlCommand cmd = new SqlCommand(sqlUserName, con);
string CurrentName;
CurrentName = (string)cmd.ExecuteScalar();
if (CurrentName != null)
{
var db = new DBClassesDataContext();
var query =
from contractor in db.Contractors
where contractor.Email.Equals(email)
select contractor;
Contractor cust = (Contractor)query.First();
string mes = "Здравствуйте, " + CurrentName + "\n"
+ "Ваш пароль в системе: " + cust.Password + "\nС уважением, администрация сервиса.";
string subj = "Восстановление пароля";
try
{
sendEmail(email, subj, mes);
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print(ex.StackTrace);
}
Alert.Show("Письмо с Вашим паролем отправлено. Проверьте почту.");
}
else
{
Alert.Show("Пользователь с таким email не найден.");
}
}
private void viewPlan()
{
try
{
string[] selected = DropDownList1.SelectedValue.Split(' ');
planindex = int.Parse(selected[1].Substring(1).Trim());
ClientScript.RegisterStartupScript(this.GetType(), "Ошибка", " " + planindex, true);
}
catch (IndexOutOfRangeException)
{
planindex = 1;
}
catch (Exception)
{
ClientScript.RegisterStartupScript(this.GetType(), "Ошибка", "Ошибка поиска", true);
planindex = 1;
}
//ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert(' index = " + planindex + "');", true);
try
{
var db = new DBClassesDataContext();
IQueryable<Plan> plans = db.Plans;
IQueryable<Contractor> contrs = db.Contractors;
IQueryable<Customer> custs = db.Customers;
plans = plans.Where(p => p.ID == planindex);
res = plans.ToArray<Plan>();
contrs = contrs.Where(p => p.ID == res[0].Contractor);
contr= contrs.ToArray<Contractor>();
custs = custs.Where(p => p.ID == res[0].Customer);
cust = custs.ToArray<Customer>();
Table1.Rows[1].Cells[0].Text = res[0].ID.ToString();
try
{
Table1.Rows[1].Cells[1].Text = cust[0].Name.ToString();
Table1.Rows[1].Cells[2].Text = contr[0].Name.ToString();
}
catch (Exception)
{ }
Table1.Rows[1].Cells[3].Text = res[0].Object.ToString();
Table1.Rows[1].Cells[4].Text = res[0].WorkType.ToString();
Table1.Rows[1].Cells[5].Text = res[0].CostName.ToString();
Table1.Rows[1].Cells[6].Text = res[0].UnitName.ToString();
Table1.Rows[1].Cells[7].Text = res[0].Labor.ToString();
Table1.Rows[1].Cells[8].Text = res[0].Materials.ToString();
Table1.Rows[1].Cells[9].Text = res[0].Mechnisms.ToString();
switch (res[0].Status)
{
case 1:
Table1.Rows[1].Cells[10].Text = "Подтвержден";
Table1.Rows[1].Cells[10].BackColor = System.Drawing.Color.Green;
break;
case 2:
Table1.Rows[1].Cells[10].Text = "Отклонен";
Table1.Rows[1].Cells[10].BackColor = System.Drawing.Color.Red;
break;
case 3:
Table1.Rows[1].Cells[10].Text = "Ожидает подтверждения";
Table1.Rows[1].Cells[10].BackColor = System.Drawing.Color.Yellow;
break;
default:
break;
}
}
catch (Exception)
{
//ClientScript.RegisterStartupScript(this.GetType(), "Ошибка", "нет записи", true);
Alert.Show("Ошибка загрузки данных");
}
}
private void buildPlanTable()
{
for (int i = 1; i < Table.Rows.Count; i++)
{
Table.Rows.RemoveAt(i);
}
var db = new DBClassesDataContext();
var query =
from plan in db.Plans
where plan.PlanID == int.Parse(DropDownList1.SelectedValue)
select plan;
Plan[] results = null;
try
{
results = query.ToArray<Plan>();
}
catch (Exception ex)
{
Table.Visible = false;
sendFact.Visible = false;
DropDownList1.Visible = false;
NoPlan.Visible = true;
return;
}
if (results[0].Status == 5)
{
}
Table.Visible = true;
sendFact.Visible = true;
DropDownList1.Visible = true;
NoPlan.Visible = false;
foreach (Plan item in results)
{
if (item.Name == null)
{
Table.Caption = "План";
}
else
{
Table.Caption = item.Name;
}
TableRow tr = new TableRow();
List<TableCell> cells = new List<TableCell>();
TableCell c = new TableCell();
c.Text = item.ID + "";
c.Visible = false;
cells.Add(c);
c = new TableCell();
c.Text = item.Object;
cells.Add(c);
c = new TableCell();
c.Text = item.WorkType;
cells.Add(c);
c = new TableCell();
c.Text = item.CostName;
cells.Add(c);
c = new TableCell();
c.Text = item.UnitName;
cells.Add(c);
c = new TableCell();
c.Text = item.Labor;
cells.Add(c);
c = new TableCell();
c.BackColor = System.Drawing.Color.LightBlue;
TextBox l = new TextBox();
l.Width = 70;
//l.BackColor = System.Drawing.Color.LightBlue;
if (firstTableBuilding)
l.Text = item.Labor;
//l.AutoPostBack = true;
c.Controls.Add(l);
cells.Add(c);
c = new TableCell();
c.Text = item.Materials;
cells.Add(c);
c = new TableCell();
c.BackColor = System.Drawing.Color.LightBlue;
l = new TextBox();
l.Width = 70;
//l.BackColor = System.Drawing.Color.LightBlue;
if (firstTableBuilding)
l.Text = item.Materials;
//l.AutoPostBack = true;
c.Controls.Add(l);
cells.Add(c);
c = new TableCell();
c.Text = item.Mechanisms;
cells.Add(c);
c = new TableCell();
c.BackColor = System.Drawing.Color.LightBlue;
l = new TextBox();
l.Width = 70;
//l.BackColor = System.Drawing.Color.LightBlue;
if (firstTableBuilding)
l.Text = item.Mechanisms;
//l.AutoPostBack = true;
c.Controls.Add(l);
cells.Add(c);
c = new TableCell();
c.Text = item.Status+"";
c.Visible = false;
cells.Add(c);
foreach (TableCell cell in cells)
{
cell.BorderColor = System.Drawing.Color.Black;
cell.BorderWidth = 1;
cell.BorderStyle = BorderStyle.Solid;
tr.Cells.Add(cell);
}
Table.Rows.Add(tr);
planID = int.Parse(DropDownList1.SelectedValue);
}
firstTableBuilding = false;
}
protected void sendFact_Click(object sender, EventArgs e)
{
int tmpID;
List<Fact> facts = new List<Fact>();
foreach (TableRow row in Table.Rows)
{
if (row.Cells[0].Text == "№ ") continue;
try
{
tmpID = int.Parse(row.Cells[0].Text);
TextBox lab = (TextBox)row.Cells[6].Controls[0];
TextBox mat = (TextBox)row.Cells[8].Controls[0];
TextBox mech = (TextBox)row.Cells[10].Controls[0];
Fact tmp = new Fact
{
FactObject = row.Cells[1].Text,
WorkType = row.Cells[2].Text,
UnitName = row.Cells[3].Text,
CostName = row.Cells[4].Text,
Labor = lab.Text,
Materials = mat.Text,
Mechanisms = mech.Text,
ExtPlanID = tmpID,
FactID = planID
};
facts.Add(tmp);
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print(ex.StackTrace);
}
}
try
{
var db = new DBClassesDataContext();
var query =
from fact in db.Facts
where fact.FactID == planID
select fact;
Fact[] factsToRemove = query.ToArray();
db.Facts.DeleteAllOnSubmit(factsToRemove);
db.SubmitChanges();
db.Facts.InsertAllOnSubmit(facts);
db.SubmitChanges();
String updatePlan = "UPDATE [Plan] SET Status=5 WHERE PlanID=" + planID;
conn.Open();
SqlCommand cmd = new SqlCommand(updatePlan, conn);
cmd.ExecuteNonQuery();
conn.Close();
Alert.Show("Фактические значения успешно отправлены!");
Response.Redirect("NewPlan.aspx");
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print(ex.StackTrace);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
user = Membership.GetUser().UserName;
}
catch (Exception ex)
{
Alert.Show("Нет прав доступа, пожалуйста зайдите как Подрядчик");
Response.Redirect("Account/Login.aspx");
}
bool hasAccess = false;
foreach (var role in Roles.GetRolesForUser())
{
if (role.Equals(Global.contractorRole)) hasAccess = true;
}
if (!hasAccess)
{
Alert.Show("Нет прав доступа, пожалуйста зайдите как Подрядчик");
Response.Redirect("Account/Login.aspx");
}
var db = new DBClassesDataContext();
var query =
from contractor in db.Contractors
where contractor.Email.Equals(user)
select contractor;
if (query != null)
{
id = query.ToArray()[0].ID;
}
if (!Page.IsPostBack)
{
providerstring = "SELECT CONCAT (N'Заказчик: ', Customer.Name , N', План: ' , [Plan].Name) AS res, [Plan].PlanID FROM Contractor INNER JOIN [Plan] ON Contractor.ID = [Plan].Contractor INNER JOIN Customer ON [Plan].Customer = Customer.ID where Contractor.ID=" + id + " AND (Status=3 OR Status=5) GROUP BY [Plan].PlanID, [Plan].Name, Customer.Name";
SqlDataSource1.SelectCommand = string.Format(providerstring);
DataBind();
}
if (!Page.IsPostBack)
{
firstTableBuilding = true;
}
else
{
buildPlanTable();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
user = Membership.GetUser().UserName;
}
catch (Exception ex)
{
Alert.Show("Нет прав доступа, пожалуйста зайдите как Подрядчик");
Response.Redirect("Account/Login.aspx");
}
bool hasAccess = false;
foreach (var role in Roles.GetRolesForUser())
{
if (role.Equals(Global.contractorRole)) hasAccess = true;
}
if (!hasAccess)
{
Alert.Show("Нет прав доступа, пожалуйста зайдите как Подрядчик");
Response.Redirect("Account/Login.aspx");
}
var db = new DBClassesDataContext();
var query =
from contractor in db.Contractors
where contractor.Email.Equals(user)
select contractor;
if (query != null)
{
id = query.ToArray()[0].ID;
}
if (!Page.IsPostBack)
{
try
{
//очищать бд Plan от записей с PlanID==-1 и всплывающие окна ---> TODO
conn.Open();
SqlCommand cmd = new SqlCommand("DELETE [Plan] WHERE PlanId=" + -1, conn);
cmd.ExecuteNonQuery();
conn.Close();
gvbind();
//GridView1.EditIndex = 0;
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print(ex.StackTrace);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
user = Membership.GetUser().UserName;
}
catch (Exception ex)
{
Alert.Show("Нет прав доступа, пожалуйста зайдите как Заказчик");
Response.Redirect("Account/Login.aspx");
}
bool hasAccess = false;
foreach (var role in Roles.GetRolesForUser())
{
if (role.Equals(Global.customerRole)) hasAccess = true;
}
if (!hasAccess)
{
Alert.Show("Нет прав доступа, пожалуйста зайдите как Заказчик");
Response.Redirect("Account/Login.aspx");
}
var db = new DBClassesDataContext();
var query =
from customer in db.Customers
where customer.Email.Equals(user)
select customer;
if (query != null)
{
id = query.ToArray()[0].ID;
}
if (!Page.IsPostBack)
{
providerstring = "SELECT CONCAT (N'Подрядчик: ', Contractor.Name , N', План: ' , [Plan].Name) AS res, [Plan].PlanID FROM [Plan] INNER JOIN Contractor ON Contractor.ID = [Plan].Contractor INNER JOIN Customer ON [Plan].Customer = " + id + " GROUP BY [Plan].PlanID, [Plan].Name, Contractor.Name";
//providerstring = "SELECT Contractor.Name, [Plan].Name FROM [Plan] INNER JOIN [Customer] ON [Customer].[ID] = [Plan].[Customer] INNER JOIN [Contractor] ON [Plan].Customer = Customer.ID where Contractor.ID=10 GROUP BY [Plan].PlanID , Customer.Name";
SqlDataSource1.SelectCommand = string.Format(providerstring);
DataBind();
var db1 = new DBClassesDataContext();
var query1 = from plan in db.Plans
where plan.Customer == id
select plan;
DropDownList1.Visible = true;
download.Visible = true;
Panel5.Visible = true;
PlanLabel.Text = "Выберите план:";
try
{
Plan cs = query1.First();
}
catch
{
DropDownList1.Visible = false;
download.Visible = false;
Panel5.Visible = false;
PlanLabel.Text = "Нет данных";
}
}
//Session["UserID"] = id;
//DropDownList1.DataBind();
try
{
//if (int.Parse(DropDownList1.SelectedValue) > 0)
//buildPlanTable();
}
catch
{
}
if (Page.IsPostBack)
{
buildPlanTable();
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridView1.Caption = PlanName.Text;
if (e.CommandName.Equals("Insert"))
{
if (first == 0)
{
conn.Open();
SqlCommand cmd = new SqlCommand("Select ID, Object, WorkType, UnitName, CostName, Labor, Materials, Mechanisms from [Plan] where PlanID=" + planID, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
ds.Tables[0].Rows.Clear();
GridView1.DataSource = ds;
GridView1.DataBind();
}
GridViewRow row = GridView1.FooterRow;
Label lblID = (Label)row.FindControl("ID");
TextBox factObject = (TextBox)row.FindControl("FactObject");
TextBox worktype = (TextBox)row.FindControl("WorkType");
TextBox costname = (TextBox)row.FindControl("CostName");
TextBox unitname = (TextBox)row.FindControl("UnitName");
TextBox labor = (TextBox)row.FindControl("Labor");
TextBox materials = (TextBox)row.FindControl("Materials");
TextBox mechanisms = (TextBox)row.FindControl("Mechanisms");
GridView1.EditIndex = -1;
var db = new DBClassesDataContext();
try
{
if (planID==-1)
{
Plan plan = new Plan { Contractor = id,Object = factObject.Text, CostName = costname.Text, WorkType = worktype.Text, UnitName = unitname.Text, Labor = labor.Text, Materials = materials.Text, Mechanisms = mechanisms.Text, Customer = int.Parse(DropDownList1.SelectedValue), Status = 0, PlanID = -1, Name=PlanName.Text };
db.Plans.InsertOnSubmit(plan);
db.SubmitChanges();
var query =
from pl in db.Plans
where pl.PlanID==-1
select pl;
if (query != null)
{
planID = query.ToArray()[0].ID;
}
/*
conn.Open();
SqlCommand cmd = new SqlCommand("update [Plan] set Contractor="+ id +", Object="+ factObject.Text +", CostName="+ costname.Text +", WorkType="+ worktype.Text + ", UnitName="+ unitname.Text+", Labor=" + labor.Text + ", Materials=" + materials.Text + ", Mechanisms="+mechanisms.Text +", PlanID=" + planID + ", Status=" + 1 + " where PlanID=" + -1, conn);
cmd.ExecuteNonQuery();
conn.Close();
*/
planID = planID + 1;
Plan plans = new Plan { Contractor = id, Object = factObject.Text, CostName = costname.Text, WorkType = worktype.Text, UnitName = unitname.Text, Labor = labor.Text, Materials = materials.Text, Mechanisms = mechanisms.Text, Customer = int.Parse(DropDownList1.SelectedValue), Status = 0, PlanID = planID};
db.Plans.InsertOnSubmit(plans);
db.SubmitChanges();
conn.Open();
SqlCommand cmd = new SqlCommand("DELETE [Plan] WHERE PlanID=" + -1, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
else
{
Plan plans = new Plan { Contractor = id, Object = factObject.Text, CostName = costname.Text, WorkType = worktype.Text, UnitName = unitname.Text, Labor = labor.Text, Materials = materials.Text, Mechanisms = mechanisms.Text, Customer = int.Parse(DropDownList1.SelectedValue), Status = 0, PlanID = planID};
db.Plans.InsertOnSubmit(plans);
db.SubmitChanges();
}
gvbind();
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print(ex.StackTrace);
}
}
}
private void buildPlanTable()
{
for (int i = 1; i < Table1.Rows.Count; i++)
{
Table1.Rows.RemoveAt(i);
}
var db = new DBClassesDataContext();
var query =
from plan in db.Plans
where plan.PlanID == int.Parse(DropDownList1.SelectedValue)
select plan;
Plan[] results = query.ToArray<Plan>();
foreach (Plan item in results)
{
TableRow tr = new TableRow();
List<TableCell> cells = new List<TableCell>();
TableCell c = new TableCell();
c.Text = item.ID + "";
cells.Add(c);
c = new TableCell();
c.Text = item.Object;
cells.Add(c);
c = new TableCell();
c.Text = item.WorkType;
cells.Add(c);
c = new TableCell();
c.Text = item.CostName;
cells.Add(c);
c = new TableCell();
c.Text = item.UnitName;
cells.Add(c);
c = new TableCell();
c.Text = item.Labor;
cells.Add(c);
c = new TableCell();
c.Text = item.Materials;
cells.Add(c);
c = new TableCell();
c.Text = item.Mechanisms;
cells.Add(c);
c = new TableCell();
c.Text = item.Status+"";
//c.Enabled = true;
cells.Add(c);
foreach (TableCell cell in cells)
{
tr.Cells.Add(cell);
}
Table1.Rows.Add(tr);
planID = int.Parse(DropDownList1.SelectedValue);
}
}
