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