protected void btn_Submit_Click(object sender, EventArgs e)
{
// Divcreate.Visible = true;
//DivView.Visible = false;
lblhead.Text = "Add New Order";
GetMaximum_OrderNumber();
Clear_Order_Details();
ModalPopupOrder.Show();
}
protected void EditOrder_Details(object sender, CommandEventArgs e)
{
int order_Id = Convert.ToInt32(e.CommandArgument.ToString());
Hashtable ht_Select_Order_Details = new Hashtable();
DataTable dt_Select_Order_Details = new DataTable();
ht_Select_Order_Details.Add("@Trans", "SELECT_ORDER_WISE");
ht_Select_Order_Details.Add("@Order_ID", order_Id);
dt_Select_Order_Details = dataaccess.ExecuteSP("Sp_Order", ht_Select_Order_Details);
if (dt_Select_Order_Details.Rows.Count > 0)
{
ViewState["Orderid"] = order_Id.ToString();
txt_OrderNumber.Text = dt_Select_Order_Details.Rows[0]["Order_Number"].ToString();
txt_Date.Text = dt_Select_Order_Details.Rows[0]["Date"].ToString();
txt_Placedby.Text = dt_Select_Order_Details.Rows[0]["Placed_By"].ToString();
ddl_ordertype.SelectedValue = dt_Select_Order_Details.Rows[0]["Order_Type_Id"].ToString();
ddl_ClientName.SelectedValue = dt_Select_Order_Details.Rows[0]["Client_Id"].ToString();
if (ddl_ClientName.SelectedValue != "")
{
int clientid = int.Parse(ddl_ClientName.SelectedValue.ToString());
dbc.BindSubProcessName(ddl_SubProcess, clientid);
}
txt_ClientNumber.Text = dt_Select_Order_Details.Rows[0]["Client_Number"].ToString();
ddl_SubProcess.SelectedValue = dt_Select_Order_Details.Rows[0]["Sub_ProcessId"].ToString();
txt_SubprocessNumber.Text = dt_Select_Order_Details.Rows[0]["Subprocess_Number"].ToString();
txt_VendorName.Text = dt_Select_Order_Details.Rows[0]["Vendor_Name"].ToString();
txt_VendorNumber.Text = dt_Select_Order_Details.Rows[0]["Vendor_Number"].ToString();
txt_Address.Text = dt_Select_Order_Details.Rows[0]["Address"].ToString();
txt_ZipCode.Text = dt_Select_Order_Details.Rows[0]["Zip"].ToString();
txt_City.Text = dt_Select_Order_Details.Rows[0]["City"].ToString();
ddl_State.SelectedValue = dt_Select_Order_Details.Rows[0]["stateid"].ToString();
if (ddl_State.SelectedValue != "")
{
int stateid = int.Parse(ddl_State.SelectedValue.ToString());
dbc.BindCounty(ddl_County, stateid);
}
ddl_County.SelectedValue = dt_Select_Order_Details.Rows[0]["CountyId"].ToString();
txt_Similar.Text = "";
txt_Borrowername.Text = dt_Select_Order_Details.Rows[0]["Borrower_Name"].ToString();
txt_BorrowerName2.Text = dt_Select_Order_Details.Rows[0]["Borrower_Name2"].ToString();
txt_Effectivedate.Text = dt_Select_Order_Details.Rows[0]["Effective_date"].ToString();
txt_LastDeed.Text = dt_Select_Order_Details.Rows[0]["Last_Deed"].ToString();
txt_Grantee.Text = dt_Select_Order_Details.Rows[0]["Grantee"].ToString();
txt_APN.Text = dt_Select_Order_Details.Rows[0]["APN"].ToString();
txt_TotalCost.Text = dt_Select_Order_Details.Rows[0]["Total_Cost"].ToString();
txt_Notes.Text = dt_Select_Order_Details.Rows[0]["Notes"].ToString();
txt_Legal.Text = dt_Select_Order_Details.Rows[0]["Legal"].ToString();
ddl_orderstatus.SelectedValue = dt_Select_Order_Details.Rows[0]["Order_Status_Id"].ToString();
btn_Save.Text = "Edit Order";
}
// Divcreate.Visible = true;
// DivView.Visible = false;
ModalPopupOrder.Show();
}
protected void btn_order_cancel_Click(object sender, EventArgs e)
{
ModalPopupOrder.Hide();
}
protected void grd_order_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = grd_order.SelectedRow;
Label lblSubprocessid = (Label)row.FindControl("lblSubprocessid");
Label lblorderid = (Label)row.FindControl("lblorderid");
Button btnordernuber = (Button)row.FindControl("btnordernumber");
Label lblCustomerName = (Label)row.FindControl("lblcustomerName");
Label lblEffectiveDate = (Label)row.FindControl("lblSubmited");
Label lblstatus = (Label)row.FindControl("lblstatus");
Label lblCounty = (Label)row.FindControl("lblCounty");
Label lblState = (Label)row.FindControl("lblState");
Button btnEdit_Order = (Button)row.FindControl("btnEditOrder");
OrderStatus = lblstatus.Text.ToString();
if (OrderStatus == "Typing")
{
Session["userid"] = userid.ToString();
Session["Empname"] = Empname.ToString();
Session["Orderid"] = lblorderid.Text.ToString();
Session["EffectiveDate"] = lblEffectiveDate.Text.ToString();
Session["OrderNumber"] = btnordernuber.Text.ToString();
Session["County"] = lblCounty.Text.ToString();
Session["State"] = lblState.Text.ToString();
Response.Redirect("~/Admin/Order_Serach_Entry_Create.aspx");
}
else if (OrderStatus == "Search1")
{
int order_Id = Convert.ToInt32(lblorderid.Text);
Hashtable ht_Select_Order_Details = new Hashtable();
DataTable dt_Select_Order_Details = new DataTable();
ht_Select_Order_Details.Add("@Trans", "SELECT_ORDER_WISE");
ht_Select_Order_Details.Add("@Order_ID", order_Id);
dt_Select_Order_Details = dataaccess.ExecuteSP("Sp_Order", ht_Select_Order_Details);
if (dt_Select_Order_Details.Rows.Count > 0)
{
ViewState["Orderid"] = order_Id.ToString();
txt_OrderNumber.Text = dt_Select_Order_Details.Rows[0]["Order_Number"].ToString();
txt_Date.Text = dt_Select_Order_Details.Rows[0]["Date"].ToString();
txt_Placedby.Text = dt_Select_Order_Details.Rows[0]["Placed_By"].ToString();
ddl_ordertype.SelectedValue = dt_Select_Order_Details.Rows[0]["Order_Type_Id"].ToString();
ddl_ClientName.SelectedValue = dt_Select_Order_Details.Rows[0]["Client_Id"].ToString();
if (ddl_ClientName.SelectedValue != "")
{
int clientid = int.Parse(ddl_ClientName.SelectedValue.ToString());
dbc.BindSubProcessName(ddl_SubProcess, clientid);
}
txt_ClientNumber.Text = dt_Select_Order_Details.Rows[0]["Client_Number"].ToString();
ddl_SubProcess.SelectedValue = dt_Select_Order_Details.Rows[0]["Sub_ProcessId"].ToString();
txt_SubprocessNumber.Text = dt_Select_Order_Details.Rows[0]["Subprocess_Number"].ToString();
txt_VendorName.Text = dt_Select_Order_Details.Rows[0]["Vendor_Name"].ToString();
txt_VendorNumber.Text = dt_Select_Order_Details.Rows[0]["Vendor_Number"].ToString();
txt_Address.Text = dt_Select_Order_Details.Rows[0]["Address"].ToString();
txt_ZipCode.Text = dt_Select_Order_Details.Rows[0]["Zip"].ToString();
txt_City.Text = dt_Select_Order_Details.Rows[0]["City"].ToString();
ddl_State.SelectedValue = dt_Select_Order_Details.Rows[0]["stateid"].ToString();
if (ddl_State.SelectedValue != "")
{
int stateid = int.Parse(ddl_State.SelectedValue.ToString());
dbc.BindCounty(ddl_County, stateid);
}
ddl_County.SelectedValue = dt_Select_Order_Details.Rows[0]["CountyId"].ToString();
txt_Similar.Text = "";
txt_Borrowername.Text = dt_Select_Order_Details.Rows[0]["Borrower_Name"].ToString();
txt_BorrowerName2.Text = dt_Select_Order_Details.Rows[0]["Borrower_Name2"].ToString();
txt_Effectivedate.Text = dt_Select_Order_Details.Rows[0]["Effective_date"].ToString();
txt_LastDeed.Text = dt_Select_Order_Details.Rows[0]["Last_Deed"].ToString();
txt_Grantee.Text = dt_Select_Order_Details.Rows[0]["Grantee"].ToString();
txt_APN.Text = dt_Select_Order_Details.Rows[0]["APN"].ToString();
txt_TotalCost.Text = dt_Select_Order_Details.Rows[0]["Total_Cost"].ToString();
txt_Notes.Text = dt_Select_Order_Details.Rows[0]["Notes"].ToString();
txt_Legal.Text = dt_Select_Order_Details.Rows[0]["Legal"].ToString();
ddl_orderstatus.SelectedValue = dt_Select_Order_Details.Rows[0]["Order_Status_Id"].ToString();
btn_Save.Text = "Edit Order";
lblhead.Text = "Edit Order Details";
}
// Divcreate.Visible = true;
// DivView.Visible = false;
ModalPopupOrder.Show();
}
else if (OrderStatus == "Search")
{
Session["userid"] = userid.ToString();
Session["Empname"] = Empname.ToString();
Session["Orderid"] = lblorderid.Text.ToString();
Session["OrderNumber"] = btnordernuber.Text.ToString();
Response.Redirect("~/Admin/Order_Search.aspx");
}
else if (OrderStatus == "search mapping")
{
Session["userid"] = userid.ToString();
Session["Empname"] = Empname.ToString();
Session["Orderid"] = lblorderid.Text.ToString();
Session["OrderNumber"] = btnordernuber.Text.ToString();
Response.Redirect("~/Admin/Order_Search_Mapping.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
if (Validation() != false && btn_Save.Text == "Add New Order")
{
string ordernumber = txt_OrderNumber.Text.ToString();
string Placedby = txt_Placedby.Text.ToUpper().ToString();
int ordertype = int.Parse(ddl_ordertype.SelectedValue.ToString());
int clientid = int.Parse(ddl_ClientName.SelectedValue.ToString());
string Customernumber = txt_ClientNumber.Text.ToUpper().ToString();
int subprocessid = int.Parse(ddl_SubProcess.SelectedValue.ToString());
string Subprocessnumber = txt_SubprocessNumber.Text.ToUpper().ToString();
string VendorName = txt_VendorName.Text.ToUpper().ToString();
string VendorNumber = txt_VendorNumber.Text.ToUpper().ToString();
string address = txt_Address.Text.ToUpper().ToString();
int zipcode = int.Parse(txt_ZipCode.Text.ToString());
string City = txt_City.Text.ToUpper().ToString();
int state = int.Parse(ddl_State.SelectedValue.ToString());
int county = int.Parse(ddl_County.SelectedValue.ToString());
string Similar = txt_Similar.Text.ToUpper().ToString();
string Barrowername = txt_Borrowername.Text.ToUpper().ToString();
string BarrowerName2 = txt_BorrowerName2.Text.ToUpper().ToString();
string effectivedate = txt_Effectivedate.Text.ToString();
string Lastdeed = txt_LastDeed.Text.ToString();
string Grantee = txt_Grantee.Text.ToString();
string APN = txt_APN.Text.ToUpper().ToString();
if (txt_TotalCost.Text != "")
{
Totalcost = Convert.ToDecimal(txt_TotalCost.Text.ToString());
}
else
{
Totalcost = 0;
}
int OrderStatus = int.Parse(ddl_orderstatus.SelectedValue.ToString());
string Notes = txt_Notes.Text.ToUpper().ToString();
string Legal = txt_Legal.Text.ToUpper().ToString();
Hashtable htorder = new Hashtable();
DataTable dtorder = new DataTable();
DateTime date = new DateTime();
date = DateTime.Now;
string dateeval = date.ToString("dd/MM/yyyy");
htorder.Add("@Trans", "INSERT");
htorder.Add("@Sub_ProcessId", subprocessid);
htorder.Add("@Date", date);
htorder.Add("@Order_Type", ordertype);
htorder.Add("@Order_Number", ordernumber);
htorder.Add("@Customer_Number", Customernumber);
htorder.Add("@Vendor_Name", VendorName);
htorder.Add("@Vendor_Number", VendorNumber);
htorder.Add("@Order_Status", OrderStatus);
htorder.Add("@Documents", "");
htorder.Add("@APN", APN);
htorder.Add("@Address", address);
htorder.Add("@City", City);
htorder.Add("@State", state);
htorder.Add("@Zip", zipcode);
htorder.Add("@County", county);
htorder.Add("@Borrower_Name", Barrowername);
htorder.Add("@Borrower_Name2", BarrowerName2);
htorder.Add("@Notes", Notes);
htorder.Add("@Effective_date", effectivedate);
htorder.Add("@Total_Cost", Totalcost);
htorder.Add("@Grantee", Grantee);
htorder.Add("@Legal", Legal);
htorder.Add("@Last_Deed", Lastdeed);
htorder.Add("@Paid", "");
htorder.Add("@Id", 0);
htorder.Add("@Opened", date);
htorder.Add("@Action_Date", date);
htorder.Add("@Turn_Time", "");
htorder.Add("@Inserted_By", userid);
htorder.Add("@Inserted_date", date);
htorder.Add("@status", true);
dtorder = dataaccess.ExecuteSP("Sp_Order", htorder);
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Msg", "<script> alert('New Order Added Sucessfully')</script>", false);
GridviewbindOrderdata();
ModalPopupOrder.Hide();
}
else if (Validation() != false && btn_Save.Text == "Edit Order")
{
string ordernumber = txt_OrderNumber.Text.ToString();
string Placedby = txt_Placedby.Text.ToUpper().ToString();
int ordertype = int.Parse(ddl_ordertype.SelectedValue.ToString());
int clientid = int.Parse(ddl_ClientName.SelectedValue.ToString());
string Customernumber = txt_ClientNumber.Text.ToUpper().ToString();
int subprocessid = int.Parse(ddl_SubProcess.SelectedValue.ToString());
string Subprocessnumber = txt_SubprocessNumber.Text.ToUpper().ToString();
string VendorName = txt_VendorName.Text.ToUpper().ToString();
string VendorNumber = txt_VendorNumber.Text.ToUpper().ToString();
string address = txt_Address.Text.ToUpper().ToString();
int zipcode = int.Parse(txt_ZipCode.Text.ToString());
string City = txt_City.Text.ToUpper().ToString();
int state = int.Parse(ddl_State.SelectedValue.ToString());
int county = int.Parse(ddl_County.SelectedValue.ToString());
string Similar = txt_Similar.Text.ToUpper().ToString();
string Barrowername = txt_Borrowername.Text.ToUpper().ToString();
string BarrowerName2 = txt_BorrowerName2.Text.ToUpper().ToString();
string effectivedate = txt_Effectivedate.Text.ToString();
string Lastdeed = txt_LastDeed.Text.ToString();
string Grantee = txt_Grantee.Text.ToString();
string APN = txt_APN.Text.ToUpper().ToString();
if (txt_TotalCost.Text != "")
{
Totalcost = Convert.ToDecimal(txt_TotalCost.Text.ToString());
}
else
{
Totalcost = 0;
}
int OrderStatus = int.Parse(ddl_orderstatus.SelectedValue.ToString());
string Notes = txt_Notes.Text.ToUpper().ToString();
string Legal = txt_Legal.Text.ToUpper().ToString();
int orderid = int.Parse(ViewState["Orderid"].ToString());
Hashtable htorder = new Hashtable();
DataTable dtorder = new DataTable();
DateTime date = new DateTime();
date = DateTime.Now;
string dateeval = date.ToString("dd/MM/yyyy");
htorder.Add("@Trans", "UPDATE");
htorder.Add("@Order_ID", orderid);
htorder.Add("@Date", date);
htorder.Add("@Sub_ProcessId", subprocessid);
htorder.Add("@Placed_By", Placedby);
htorder.Add("@Order_Type", ordertype);
htorder.Add("@Order_Number", ordernumber);
htorder.Add("@Customer_Number", Customernumber);
htorder.Add("@Vendor_Name", VendorName);
htorder.Add("@Vendor_Number", VendorNumber);
htorder.Add("@Order_Status", OrderStatus);
htorder.Add("@Documents", "");
htorder.Add("@APN", APN);
htorder.Add("@Address", address);
htorder.Add("@City", City);
htorder.Add("@State", state);
htorder.Add("@Zip", zipcode);
htorder.Add("@County", county);
htorder.Add("@Borrower_Name", Barrowername);
htorder.Add("@Borrower_Name2", BarrowerName2);
htorder.Add("@Notes", Notes);
htorder.Add("@Effective_date", effectivedate);
htorder.Add("@Total_Cost", Totalcost);
htorder.Add("@Grantee", Grantee);
htorder.Add("@Legal", Legal);
htorder.Add("@Last_Deed", Lastdeed);
htorder.Add("@Paid", "");
htorder.Add("@Id", 0);
htorder.Add("@Opened", date);
htorder.Add("@Action_Date", date);
htorder.Add("@Turn_Time", "");
htorder.Add("@Inserted_By", userid);
htorder.Add("@Inserted_date", date);
htorder.Add("@status", true);
dtorder = dataaccess.ExecuteSP("Sp_Order", htorder);
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Msg", "<script> alert('Order Updated Sucessfully')</script>", false);
btn_Save.Text = "Add New Order";
GridviewbindOrderdata();
Clear_Order_Details();
GetMaximum_OrderNumber();
DivView.Visible = true;
Divcreate.Visible = false;
ModalPopupOrder.Hide();
}
}
