protected void Page_Load(object sender, EventArgs e)
{
string quoids = Session["quoids"].ToString();
DataTable dt = new QuotationLogic().selectForPrint(quoids);
Repeater1.DataSource = dt;
Repeater1.DataBind();
int c = 0;
String s = "";
foreach (DataRow row in dt.Rows)
{
if (c == 0)
{
s = row["CustomerName"].ToString();
c++;
}
else
{
if (!row["CustomerName"].ToString().Equals(s))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Multiple customer can not have same quotation.')", true);
Response.Redirect("QuotationList.aspx");
}
c++;
}
}
Label5.Text = s;
Label6.Text = dt.Rows[0]["Address"].ToString();
Label7.Text = dt.Rows[0]["Phone"].ToString();
Label8.Text = dt.Rows[0]["Email"].ToString();
Label9.Text = DateTime.Today.ToString("dd/MM/yyyy");
}
public TransactionController()
{
_enquiryLogic = new EnquiryLogic();
_quotationLogic = new QuotationLogic();
_salesOrderLogic = new SalesOrderLogic();
_deliveryNoteLogic = new DeliveryNoteLogic();
}
protected void Page_Load(object sender, EventArgs e)
{
string quoids = Session["quoids"].ToString();
DataTable dt = new QuotationLogic().selectForPrint(quoids);
Repeater1.DataSource = dt;
Repeater1.DataBind();
int c = 0;
String s = "";
foreach (DataRow row in dt.Rows)
{
if (c == 0)
{
s = row["CustomerName"].ToString();
c++;
}
else
{
if (!row["CustomerName"].ToString().Equals(s))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Multiple customer can not have same quotation.')", true);
Response.Redirect("QuotationList.aspx");
}
c++;
}
}
Label5.Text = s;
Label6.Text = dt.Rows[0]["Address"].ToString();
Label7.Text = dt.Rows[0]["Phone"].ToString();
Label8.Text = dt.Rows[0]["Email"].ToString();
Label9.Text = DateTime.Today.ToString("dd/MM/yyyy");
}
protected void Button1_Click(object sender, EventArgs e)
{
Label2.Visible = false;
//ScriptManager.RegisterClientScriptBlock(this , this.GetType(), "alertMessage", "alert('All selected quotations shoud be of same customer.')", true);
string ans = "";
foreach (RepeaterItem ri in Repeater1.Items)
{
CheckBox cb = (CheckBox)ri.FindControl("Checkbox1");
if (cb.Checked)
{
int quoid = Convert.ToInt32(((Label)ri.FindControl("Label1")).Text);
ans += quoid + ",";
}
}
if (ans.Length > 1)
{
ans = ans.Substring(0, ans.Length - 1);
Session["quoids"] = ans;
DataTable dt = new QuotationLogic().selectForPrint(ans);
// Repeater1.DataSource = dt;
// Repeater1.DataBind();
int c = 0;
String s = "";
foreach (DataRow row in dt.Rows)
{
if (c == 0)
{
s = row["CustomerName"].ToString();
c++;
}
else
{
if (!row["CustomerName"].ToString().Equals(s))
{
Label2.Visible = true;
break;
// Response.Redirect("QuotationList.aspx");
}
else
{
Label2.Visible = false;
}
c++;
}
}
if (Label2.Visible == false)
{
Response.Redirect("PrintQuotation.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
EmployeeLogic el = new EmployeeLogic();
Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"]));
if (!IsPostBack)
{
if (e2.Designation.Equals("MANAGING DIRECTOR") || e2.Designation.Equals("CHAIRMAN") || e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE") || e2.Designation.Equals("MARKETING MANAGER") || e2.Designation.Equals("MARKETING EMPLOYEE") || e2.Designation.Equals("PRODUCTION MANAGER") || e2.Designation.Equals("PRODUCTION EMPLOYEE"))
{
QuotationLogic QL = new QuotationLogic();
DataTable dt = QL.SelectAllJoined();
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (dt.Rows.Count == 0)
{
Table1.Visible = false;
Label1.Visible = true;
}
else
{
Table1.Visible = true;
Label1.Visible = false;
}
CustomerLogic cl = new CustomerLogic();
DataTable dt1 = cl.SelectAll();
dt1.Rows.Add(0, "All Customer", null, null, null, null, null, null, null, null, null);
dt1.DefaultView.Sort = "CustomerID";
DropDownList1.DataSource = dt1;
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "CustomerID";
DropDownList1.DataBind();
DropDownList1.SelectedItem.Text = "All Customer";
ProductLogic pl = new ProductLogic();
DataTable dt2 = pl.SelectAll();
dt2.Rows.Add(0, "All Product", null, null, null, null, null, null, null, null);
dt2.DefaultView.Sort = "ProductID";
DropDownList2.DataSource = dt2;
DropDownList2.DataTextField = "Name";
DropDownList2.DataValueField = "ProductID";
DropDownList2.DataBind();
DropDownList2.SelectedItem.Text = "All Product";
}
else
{
Response.Redirect("Access.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
EmployeeLogic el = new EmployeeLogic();
Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"]));
if (!IsPostBack)
{
if (e2.Designation.Equals("MANAGING DIRECTOR") || e2.Designation.Equals("CHAIRMAN") || e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE") || e2.Designation.Equals("MARKETING MANAGER") || e2.Designation.Equals("MARKETING EMPLOYEE") || e2.Designation.Equals("PRODUCTION MANAGER") || e2.Designation.Equals("PRODUCTION EMPLOYEE"))
{
QuotationLogic QL = new QuotationLogic();
DataTable dt = QL.SelectAllJoined();
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (dt.Rows.Count == 0)
{
Table1.Visible = false;
Label1.Visible = true;
}
else
{
Table1.Visible = true;
Label1.Visible = false;
}
CustomerLogic cl = new CustomerLogic();
DataTable dt1 = cl.SelectAll();
dt1.Rows.Add(0, "All Customer", null, null, null, null, null, null, null, null, null);
dt1.DefaultView.Sort = "CustomerID";
DropDownList1.DataSource = dt1;
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "CustomerID";
DropDownList1.DataBind();
DropDownList1.SelectedItem.Text = "All Customer";
ProductLogic pl = new ProductLogic();
DataTable dt2 = pl.SelectAll();
dt2.Rows.Add(0, "All Product", null, null, null, null, null, null, null, null);
dt2.DefaultView.Sort = "ProductID";
DropDownList2.DataSource = dt2;
DropDownList2.DataTextField = "Name";
DropDownList2.DataValueField = "ProductID";
DropDownList2.DataBind();
DropDownList2.SelectedItem.Text = "All Product";
}
else
{
Response.Redirect("Access.aspx");
}
}
}
protected void LinkButton1_Command(object sender, CommandEventArgs e)
{
EmployeeLogic el = new EmployeeLogic();
Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"]));
if (e2.Designation.Equals("MANAGING DIRECTOR") || e2.Designation.Equals("CHAIRMAN") || e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE"))
{
QuotationLogic ql = new QuotationLogic();
Quotation q1 = ql.SelectByID(Convert.ToInt32(e.CommandArgument));
if (q1 != null)
{
ql.Delete(q1.QuotationID);
Response.Redirect("QuotationList.aspx");
}
}
else
{
Response.Redirect("Access.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
EmployeeLogic el = new EmployeeLogic();
Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"]));
if (e2.Designation.Equals("MANAGING DIRECTOR") || e2.Designation.Equals("CHAIRMAN") || e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE"))
{
if (!IsPostBack)
{
ProductLogic pl = new ProductLogic();
DropDownList1.DataSource = pl.SelectAll();
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "ProductID";
DropDownList1.DataBind();
QuotationLogic ql = new QuotationLogic();
Quotation q1 = ql.SelectByID(Convert.ToInt32(Request.QueryString["id"]));
if (q1.QuotationID > 0)
{
Product p1 = pl.SelectByProductID(q1.ProductID);
DropDownList1.SelectedItem.Value = p1.ProductID.ToString();
TextBox1.Text = q1.MOQ.ToString();
TextBox2.Text = q1.Rate.ToString();
TextBox3.Text = q1.CreateDate.ToString("dd/MM/yyyy");
TextBox4.Text = q1.Status;
TextBox5.Text = q1.Remarks;
TextBox6.Text = q1.TermsConditions;
}
else
{
TextBox3.Text = DateTime.Now.ToString("dd/MM/yyyy");
}
}
}
else
{
Response.Redirect("Access.aspx");
}
}
protected void Button2_Click(object sender, EventArgs e)
{
EmployeeLogic el = new EmployeeLogic();
Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"]));
if (e2.Designation.Equals("MANAGING DIRECTOR") || e2.Designation.Equals("CHAIRMAN") || e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE"))
{
QuotationLogic ql = new QuotationLogic();
DateTime d1 = new DateTime();
DateTime d2 = new DateTime();
if (!DateTime.TryParseExact(TextBox1.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1))
{
d1 = DateTime.Now.AddYears(-100);
}
if (!DateTime.TryParseExact(TextBox2.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d2))
{
d2 = DateTime.Now.AddYears(10);
}
DataTable dt = ql.Search(Convert.ToInt32(DropDownList1.SelectedItem.Value), Convert.ToInt32(DropDownList2.SelectedItem.Value), d1, d2);
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (dt.Rows.Count == 0)
{
Table1.Visible = false;
Label1.Visible = true;
}
else
{
Table1.Visible = true;
Label1.Visible = false;
}
}
else
{
Response.Redirect("Access.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
EmployeeLogic el = new EmployeeLogic();
Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"]));
if (e2.Designation.Equals("MANAGING DIRECTOR") || e2.Designation.Equals("CHAIRMAN") || e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE"))
{
if (!IsPostBack)
{
ProductLogic pl = new ProductLogic();
DropDownList1.DataSource = pl.SelectAll();
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "ProductID";
DropDownList1.DataBind();
QuotationLogic ql = new QuotationLogic();
Quotation q1 = ql.SelectByID(Convert.ToInt32(Request.QueryString["id"]));
if (q1.QuotationID > 0)
{
Product p1 = pl.SelectByProductID(q1.ProductID);
DropDownList1.SelectedItem.Value = p1.ProductID.ToString();
TextBox1.Text = q1.MOQ.ToString();
TextBox2.Text = q1.Rate.ToString();
TextBox3.Text = q1.CreateDate.ToString("dd/MM/yyyy");
TextBox4.Text = q1.Status;
TextBox5.Text = q1.Remarks;
TextBox6.Text = q1.TermsConditions;
}
else
{
TextBox3.Text = DateTime.Now.ToString("dd/MM/yyyy");
}
}
}
else
{
Response.Redirect("Access.aspx");
}
}
protected void btnUpload_OnClick(object sender, EventArgs e)
{
string quoids = Session["quoids"].ToString();
string[] arr = quoids.Split(',');
QuotationLogic ql = new QuotationLogic();
Quotation q;
string path;
string ticks = DateTime.Now.Ticks.ToString();
if (FileUpload1.HasFile)
{
FileUpload1.SaveAs(Server.MapPath("Images/" + ticks + FileUpload1.FileName));
path = "Images/" + ticks + FileUpload1.FileName;
for (int i = 0; i < arr.Length; i++)
{
q = ql.SelectByID(Convert.ToInt32(arr[i]));
q.QuotationPath = path;
ql.Update(q);
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage" + arr[i], "alert(" + arr[i] + ")", true);
}
}
// Response.Redirect("QuotationList.aspx");
}
protected void btnUpload_OnClick(object sender, EventArgs e)
{
string quoids = Session["quoids"].ToString();
string[] arr = quoids.Split(',');
QuotationLogic ql = new QuotationLogic();
Quotation q;
string path;
string ticks = DateTime.Now.Ticks.ToString();
if (FileUpload1.HasFile)
{
FileUpload1.SaveAs(Server.MapPath("Images/" + ticks + FileUpload1.FileName));
path = "Images/" + ticks + FileUpload1.FileName;
for (int i = 0; i < arr.Length; i++)
{
q = ql.SelectByID(Convert.ToInt32(arr[i]));
q.QuotationPath = path;
ql.Update(q);
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage" + arr[i], "alert(" + arr[i] + ")", true);
}
}
// Response.Redirect("QuotationList.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Convert.ToInt32(Request.QueryString["ID"]) > 0)
{
QuotationLogic ql = new QuotationLogic();
Quotation objQuotation = ql.SelectByID(Convert.ToInt32(Request.QueryString["ID"]));
//objQuotation.ProductID = new ProductLogic().SelectByProductName(DropDownList1.Text).ProductID;
objQuotation.ProductID = Convert.ToInt32(DropDownList1.SelectedItem.Value);
objQuotation.MOQ = Convert.ToInt32(TextBox1.Text);
objQuotation.Rate = Convert.ToInt32(TextBox2.Text);
// objQuotation.CreateDate = Convert.ToDateTime(TextBox3.Text);
DateTime d1 = new DateTime();
if (!DateTime.TryParseExact(TextBox3.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1))
{
objQuotation.CreateDate = DateTime.Now;
}
if (d1.ToShortDateString().Equals(DateTime.Today.ToShortDateString()))
{
objQuotation.CreateDate = DateTime.Now;
}
else
{
objQuotation.CreateDate = d1;
}
objQuotation.Status = TextBox4.Text;
objQuotation.Remarks = TextBox5.Text;
objQuotation.TermsConditions = TextBox6.Text;
objQuotation.EmployeeID = Convert.ToInt32(Session["EmployeeID"]);
objQuotation.QuotationPath = "";
ql.Update(objQuotation);
Response.Redirect("QuotationList.aspx");
}
else
{
QuotationLogic ql = new QuotationLogic();
Quotation objQuotation = new Quotation();
//objQuotation.ProductID = new ProductLogic().SelectByProductName(DropDownList1.Text).ProductID;
objQuotation.ProductID = Convert.ToInt32(DropDownList1.SelectedItem.Value);
objQuotation.MOQ = Convert.ToInt32(TextBox1.Text);
objQuotation.Rate = Convert.ToInt32(TextBox2.Text);
// objQuotation.CreateDate = Convert.ToDateTime(TextBox3.Text);
DateTime d1 = new DateTime();
if (!DateTime.TryParseExact(TextBox3.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1))
{
objQuotation.CreateDate = DateTime.Today;
}
if (d1.ToShortDateString().Equals(DateTime.Today.ToShortDateString()))
{
objQuotation.CreateDate = DateTime.Now;
}
else
{
objQuotation.CreateDate = d1;
}
objQuotation.Status = TextBox4.Text;
objQuotation.Remarks = TextBox5.Text;
objQuotation.TermsConditions = TextBox6.Text;
objQuotation.EmployeeID = Convert.ToInt32(Session["EmployeeID"]);
objQuotation.QuotationPath = "";
ql.Insert(objQuotation);
Response.Redirect("QuotationList.aspx");
}
}
protected void Button2_Click(object sender, EventArgs e)
{
EmployeeLogic el = new EmployeeLogic();
Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"]));
if (e2.Designation.Equals("MANAGING DIRECTOR") || e2.Designation.Equals("CHAIRMAN") || e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE"))
{
QuotationLogic ql = new QuotationLogic();
DateTime d1 = new DateTime();
DateTime d2 = new DateTime();
if (!DateTime.TryParseExact(TextBox1.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1))
{
d1 = DateTime.Now.AddYears(-100);
}
if (!DateTime.TryParseExact(TextBox2.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d2))
{
d2 = DateTime.Now.AddYears(10);
}
DataTable dt = ql.Search(Convert.ToInt32(DropDownList1.SelectedItem.Value), Convert.ToInt32(DropDownList2.SelectedItem.Value), d1, d2);
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (dt.Rows.Count == 0)
{
Table1.Visible = false;
Label1.Visible = true;
}
else
{
Table1.Visible = true;
Label1.Visible = false;
}
}
else
{
Response.Redirect("Access.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["type"] == "login")
{
// login request
string un = Request.QueryString["un"].ToString();
string pw = Request.QueryString["pw"].ToString();
Employee e1 = new EmployeeLogic().selectUP(un, pw);
Response.Write(e1.EmployeeID+ ";"+e1.Username+";"+e1.Password+"---");
return;
}
else if (Request.QueryString["type"] == "notification")
{
// no other data is needed
QuotationLogic ql = new QuotationLogic();
DataTable dt = ql.SelectNotification();
String resp = "";
foreach (DataRow dr in dt.Rows)
{
resp = resp + dr["ID"].ToString() + ";";
resp = resp + dr["Data"].ToString() + ";";
resp = resp + dr["Type"].ToString() + ";";
resp = resp + Convert.ToDateTime(dr["Date"]).ToString("dd-MM-yyyy HH:mm:ss") + "---";
}
Response.Write(resp);
}
else if (Request.QueryString["type"] == "employee")
{
// no other data is needed
EmployeeLogic el = new EmployeeLogic();
DataTable dt = el.SelectForAndroid();
String resp = "";
foreach (DataRow dr in dt.Rows)
{
resp = resp + dr["EmployeeID"].ToString() + ";";
resp = resp + dr["Name"].ToString() + ";";
resp = resp + dr["Phone"].ToString() + "---";
}
Response.Write(resp);
}
else if (Request.QueryString["type"] == "employeeInfo")
{
// no other data is needed
EmployeeLogic el = new EmployeeLogic();
Employee e1 = el.SelectByID(Convert.ToInt32 (Request.QueryString["ID"]));
String resp = "";
resp = resp + e1.EmployeeID + ";";
resp = resp + e1.Name + ";";
resp = resp + e1.Designation + ";";
resp = resp + e1.Address+ ";";
resp = resp + e1.Email+ ";";
resp = resp + e1.Phone + ";";
resp = resp + Convert.ToDateTime(e1.DOB.ToString("dd-MM-yyyy"))+ ";";
resp = resp + Convert.ToDateTime(e1.DOJ.ToString("dd-MM-yyyy"))+ ";";
resp = resp + e1.Photo + "---";
Response.Write(resp);
}
//else if (Request.QueryString["type"] == "Teamlist")
//{
// // no other data is needed
// TeamLogic tl = new TeamLogic();
// DataTable dt = tl.SelectAll();
// String resp = "";
// foreach (DataRow dr in dt.Rows)
// {
// resp = resp + dr["TeamID"].ToString() + "-";
// resp = resp + dr["Name"].ToString() + "-";
// resp = resp + dr["CreateDate"].ToString() + "-";
// resp = resp + dr["TeamLeadID"].ToString() + "-";
// resp = resp + dr["ProjectID"].ToString() + "#";
// }
// Response.Write(resp);
//}
//else if (Request.QueryString["type"] == "Versionlist")
//{
// // no other data is needed
// ProjectVersionLogic PVL = new ProjectVersionLogic();
// DataTable dt = PVL.SelectAll();
// String resp = "";
// foreach (DataRow dr in dt.Rows)
// {
// resp = resp + dr["ProjectVersionID"].ToString() + "-";
// resp = resp + dr["Name"].ToString() + "-";
// // resp = resp + dr["ProjectID"].ToString() + "-";
// resp = resp + dr["ScheduledStartDate"].ToString() + "-";
// // resp = resp + dr["ActualStartDate"].ToString() + "-";
// resp = resp + dr["ScheduledEndDate"].ToString() + "#";
// }
// Response.Write(resp);
//}
////public string MD5Hash(string Password)
//{
// MD5 md5 = new MD5CryptoServiceProvider();
// //compute hash from the bytes of text
// md5.ComputeHash(ASCIIEncoding.ASCII.GetBytes(Password));
// //get hash result after compute it
// byte[] result = md5.Hash;
// StringBuilder strBuilder = new StringBuilder();
// for (int i = 0; i < result.Length; i++)
// {
// //change it into 2 hexadecimal digits
// //for each byte
// strBuilder.Append(result[i].ToString("x2"));
// }
// return strBuilder.ToString();
//}
}
protected void Button1_Click(object sender, EventArgs e)
{
Label2.Visible = false;
//ScriptManager.RegisterClientScriptBlock(this , this.GetType(), "alertMessage", "alert('All selected quotations shoud be of same customer.')", true);
string ans = "";
foreach (RepeaterItem ri in Repeater1.Items)
{
CheckBox cb = (CheckBox)ri.FindControl("Checkbox1");
if (cb.Checked)
{
int quoid = Convert.ToInt32(((Label)ri.FindControl("Label1")).Text);
ans += quoid + ",";
}
}
if (ans.Length > 1)
{
ans = ans.Substring(0, ans.Length - 1);
Session["quoids"] = ans;
DataTable dt = new QuotationLogic().selectForPrint(ans);
// Repeater1.DataSource = dt;
// Repeater1.DataBind();
int c = 0;
String s = "";
foreach (DataRow row in dt.Rows)
{
if (c == 0)
{
s = row["CustomerName"].ToString();
c++;
}
else
{
if (!row["CustomerName"].ToString().Equals(s))
{
Label2.Visible = true;
break;
// Response.Redirect("QuotationList.aspx");
}
else
{
Label2.Visible = false;
}
c++;
}
}
if (Label2.Visible == false)
{
Response.Redirect("PrintQuotation.aspx");
}
}
}
protected void DropDownList1_OnSelectedIndexChanged(object sender, EventArgs e)
{
QuotationLogic ql = new QuotationLogic();
TextBox1.Text = ql.SelectByProductID(Convert.ToInt32(DropDownList1.SelectedItem.Value)).QuotationID.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
EmployeeLogic el = new EmployeeLogic();
Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"]));
if (e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE") || e2.Designation.Equals("DESIGNER") || e2.Designation.Equals("PRODUCTION MANAGER") || e2.Designation.Equals("PRODUCTION EMPLOYEE"))
{
if (!IsPostBack)
{
ProductLogic pl = new ProductLogic();
DropDownList1.DataSource = pl.SelectAll();
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "ProductID";
DropDownList1.DataBind();
if (Convert.ToInt32(Request.QueryString["id"]) > 0)
{
OrderLogic ol = new OrderLogic();
Order o1 = ol.SelectByID(Convert.ToInt32(Request.QueryString["id"]));
Product p1 = pl.SelectByProductID(o1.ProductID);
DropDownList1.SelectedItem.Text = p1.Name;
QuotationLogic ql = new QuotationLogic();
TextBox1.Text = ql.SelectByProductID(Convert.ToInt32(DropDownList1.SelectedValue)).QuotationID.ToString();
TextBox2.Text = o1.Quantity.ToString();
TextBox3.Text = o1.Rate.ToString();
TextBox4.Text = o1.PODate.ToString("dd/MM/yyyy");
TextBox5.Text = o1.PONumber.ToString();
TextBox6.Text = o1.CreateDate.ToString("dd/MM/yyyy");
DropDownList2.SelectedItem.Text = o1.Status;
TextBox8.Text = o1.StatusRemarks;
TextArea2.Text = o1.DeliveryAddress;
TextBox9.Text = o1.DeliveryDate.ToString("dd/MM/yyyy");
String po = o1.AttachPO;
string ticks = DateTime.Now.Ticks.ToString();
if (FileUpload1.HasFile)
{
FileUpload1.SaveAs(Server.MapPath("Images/" + ticks + FileUpload1.FileName));
FileUpload1.Visible = false;
lnkImage1.Text = po.Substring(25);
lnkImage1.NavigateUrl = po;
}
else
{
lnkImage1.Visible = false;
LinkButton1.Visible = false;
}
}
else
{
lnkImage1.Visible = false;
LinkButton1.Visible = false;
QuotationLogic ql = new QuotationLogic();
TextBox1.Text = ql.SelectByProductID(Convert.ToInt32(DropDownList1.SelectedItem.Value)).QuotationID.ToString();
TextBox6.Text = DateTime.Now.ToString("dd/MM/yyyy");
}
}
Label2.Visible = false;
}
else
{
Response.Redirect("Access.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["type"] == "login")
{
// login request
string un = Request.QueryString["un"].ToString();
string pw = Request.QueryString["pw"].ToString();
Employee e1 = new EmployeeLogic().selectUP(un, pw);
Response.Write(e1.EmployeeID + ";" + e1.Username + ";" + e1.Password + "---");
return;
}
else if (Request.QueryString["type"] == "notification")
{
// no other data is needed
QuotationLogic ql = new QuotationLogic();
DataTable dt = ql.SelectNotification();
String resp = "";
foreach (DataRow dr in dt.Rows)
{
resp = resp + dr["ID"].ToString() + ";";
resp = resp + dr["Data"].ToString() + ";";
resp = resp + dr["Type"].ToString() + ";";
resp = resp + Convert.ToDateTime(dr["Date"]).ToString("dd-MM-yyyy HH:mm:ss") + "---";
}
Response.Write(resp);
}
else if (Request.QueryString["type"] == "employee")
{
// no other data is needed
EmployeeLogic el = new EmployeeLogic();
DataTable dt = el.SelectForAndroid();
String resp = "";
foreach (DataRow dr in dt.Rows)
{
resp = resp + dr["EmployeeID"].ToString() + ";";
resp = resp + dr["Name"].ToString() + ";";
resp = resp + dr["Phone"].ToString() + "---";
}
Response.Write(resp);
}
else if (Request.QueryString["type"] == "employeeInfo")
{
// no other data is needed
EmployeeLogic el = new EmployeeLogic();
Employee e1 = el.SelectByID(Convert.ToInt32(Request.QueryString["ID"]));
String resp = "";
resp = resp + e1.EmployeeID + ";";
resp = resp + e1.Name + ";";
resp = resp + e1.Designation + ";";
resp = resp + e1.Address + ";";
resp = resp + e1.Email + ";";
resp = resp + e1.Phone + ";";
resp = resp + Convert.ToDateTime(e1.DOB.ToString("dd-MM-yyyy")) + ";";
resp = resp + Convert.ToDateTime(e1.DOJ.ToString("dd-MM-yyyy")) + ";";
resp = resp + e1.Photo + "---";
Response.Write(resp);
}
//else if (Request.QueryString["type"] == "Teamlist")
//{
// // no other data is needed
// TeamLogic tl = new TeamLogic();
// DataTable dt = tl.SelectAll();
// String resp = "";
// foreach (DataRow dr in dt.Rows)
// {
// resp = resp + dr["TeamID"].ToString() + "-";
// resp = resp + dr["Name"].ToString() + "-";
// resp = resp + dr["CreateDate"].ToString() + "-";
// resp = resp + dr["TeamLeadID"].ToString() + "-";
// resp = resp + dr["ProjectID"].ToString() + "#";
// }
// Response.Write(resp);
//}
//else if (Request.QueryString["type"] == "Versionlist")
//{
// // no other data is needed
// ProjectVersionLogic PVL = new ProjectVersionLogic();
// DataTable dt = PVL.SelectAll();
// String resp = "";
// foreach (DataRow dr in dt.Rows)
// {
// resp = resp + dr["ProjectVersionID"].ToString() + "-";
// resp = resp + dr["Name"].ToString() + "-";
// // resp = resp + dr["ProjectID"].ToString() + "-";
// resp = resp + dr["ScheduledStartDate"].ToString() + "-";
// // resp = resp + dr["ActualStartDate"].ToString() + "-";
// resp = resp + dr["ScheduledEndDate"].ToString() + "#";
// }
// Response.Write(resp);
//}
////public string MD5Hash(string Password)
//{
// MD5 md5 = new MD5CryptoServiceProvider();
// //compute hash from the bytes of text
// md5.ComputeHash(ASCIIEncoding.ASCII.GetBytes(Password));
// //get hash result after compute it
// byte[] result = md5.Hash;
// StringBuilder strBuilder = new StringBuilder();
// for (int i = 0; i < result.Length; i++)
// {
// //change it into 2 hexadecimal digits
// //for each byte
// strBuilder.Append(result[i].ToString("x2"));
// }
// return strBuilder.ToString();
//}
}
protected void Page_Load(object sender, EventArgs e)
{
QuotationLogic QL = new QuotationLogic();
Repeater1.DataSource = QL.SelectNotification();
Repeater1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Convert.ToInt32(Request.QueryString["ID"]) > 0)
{
QuotationLogic ql = new QuotationLogic();
Quotation objQuotation = ql.SelectByID(Convert.ToInt32(Request.QueryString["ID"]));
//objQuotation.ProductID = new ProductLogic().SelectByProductName(DropDownList1.Text).ProductID;
objQuotation.ProductID =Convert.ToInt32(DropDownList1.SelectedItem.Value);
objQuotation.MOQ = Convert.ToInt32(TextBox1.Text);
objQuotation.Rate = Convert.ToInt32(TextBox2.Text);
// objQuotation.CreateDate = Convert.ToDateTime(TextBox3.Text);
DateTime d1 = new DateTime();
if (!DateTime.TryParseExact(TextBox3.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1))
{
objQuotation.CreateDate = DateTime.Now;
}
if (d1.ToShortDateString().Equals(DateTime.Today.ToShortDateString()))
{
objQuotation.CreateDate = DateTime.Now;
}
else
{
objQuotation.CreateDate = d1;
}
objQuotation.Status = TextBox4.Text;
objQuotation.Remarks = TextBox5.Text;
objQuotation.TermsConditions = TextBox6.Text;
objQuotation.EmployeeID = Convert.ToInt32(Session["EmployeeID"]);
objQuotation.QuotationPath = "";
ql.Update(objQuotation);
Response.Redirect("QuotationList.aspx");
}
else
{
QuotationLogic ql = new QuotationLogic();
Quotation objQuotation = new Quotation();
//objQuotation.ProductID = new ProductLogic().SelectByProductName(DropDownList1.Text).ProductID;
objQuotation.ProductID = Convert.ToInt32(DropDownList1.SelectedItem.Value);
objQuotation.MOQ = Convert.ToInt32(TextBox1.Text);
objQuotation.Rate = Convert.ToInt32(TextBox2.Text);
// objQuotation.CreateDate = Convert.ToDateTime(TextBox3.Text);
DateTime d1 = new DateTime();
if (!DateTime.TryParseExact(TextBox3.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1))
{
objQuotation.CreateDate = DateTime.Today;
}
if (d1.ToShortDateString().Equals(DateTime.Today.ToShortDateString()))
{
objQuotation.CreateDate = DateTime.Now;
}
else
{
objQuotation.CreateDate = d1;
}
objQuotation.Status = TextBox4.Text;
objQuotation.Remarks = TextBox5.Text;
objQuotation.TermsConditions = TextBox6.Text;
objQuotation.EmployeeID = Convert.ToInt32(Session["EmployeeID"]);
objQuotation.QuotationPath = "";
ql.Insert(objQuotation);
Response.Redirect("QuotationList.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
EmployeeLogic el = new EmployeeLogic();
Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"]));
if (e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE") || e2.Designation.Equals("DESIGNER") || e2.Designation.Equals("PRODUCTION MANAGER") || e2.Designation.Equals("PRODUCTION EMPLOYEE"))
{
if (!IsPostBack)
{
ProductLogic pl = new ProductLogic();
DropDownList1.DataSource = pl.SelectAll();
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "ProductID";
DropDownList1.DataBind();
if (Convert.ToInt32(Request.QueryString["id"]) > 0)
{
OrderLogic ol = new OrderLogic();
Order o1 = ol.SelectByID(Convert.ToInt32(Request.QueryString["id"]));
Product p1 = pl.SelectByProductID(o1.ProductID);
DropDownList1.SelectedItem.Text = p1.Name;
QuotationLogic ql = new QuotationLogic();
TextBox1.Text = ql.SelectByProductID(Convert.ToInt32(DropDownList1.SelectedValue)).QuotationID.ToString();
TextBox2.Text = o1.Quantity.ToString();
TextBox3.Text = o1.Rate.ToString();
TextBox4.Text = o1.PODate.ToString("dd/MM/yyyy");
TextBox5.Text = o1.PONumber.ToString();
TextBox6.Text = o1.CreateDate.ToString("dd/MM/yyyy");
DropDownList2.SelectedItem.Text = o1.Status;
TextBox8.Text = o1.StatusRemarks;
TextArea2.Text = o1.DeliveryAddress;
TextBox9.Text = o1.DeliveryDate.ToString("dd/MM/yyyy");
String po = o1.AttachPO;
string ticks = DateTime.Now.Ticks.ToString();
if (FileUpload1.HasFile)
{
FileUpload1.SaveAs(Server.MapPath("Images/" + ticks + FileUpload1.FileName));
FileUpload1.Visible = false;
lnkImage1.Text = po.Substring(25);
lnkImage1.NavigateUrl = po;
}
else
{
lnkImage1.Visible = false;
LinkButton1.Visible = false;
}
}
else
{
lnkImage1.Visible = false;
LinkButton1.Visible = false;
QuotationLogic ql = new QuotationLogic();
TextBox1.Text = ql.SelectByProductID(Convert.ToInt32(DropDownList1.SelectedItem.Value)).QuotationID.ToString();
TextBox6.Text = DateTime.Now.ToString("dd/MM/yyyy");
}
}
Label2.Visible = false;
}
else
{
Response.Redirect("Access.aspx");
}
}
protected void DropDownList1_OnSelectedIndexChanged(object sender, EventArgs e)
{
QuotationLogic ql = new QuotationLogic();
TextBox1.Text = ql.SelectByProductID(Convert.ToInt32(DropDownList1.SelectedItem.Value)).QuotationID.ToString();
}
protected void LinkButton1_Command(object sender, CommandEventArgs e)
{
EmployeeLogic el = new EmployeeLogic();
Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"]));
if (e2.Designation.Equals("MANAGING DIRECTOR") || e2.Designation.Equals("CHAIRMAN") || e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE"))
{
QuotationLogic ql = new QuotationLogic();
Quotation q1 = ql.SelectByID(Convert.ToInt32(e.CommandArgument));
if (q1 != null)
{
ql.Delete(q1.QuotationID);
Response.Redirect("QuotationList.aspx");
}
}
else
{
Response.Redirect("Access.aspx");
}
}
