public Vendor_Order_View(int Orderid, int User_Id, int USER_ROLE)
{
InitializeComponent();
User_Role_Id = USER_ROLE;
if (User_Role_Id == 1)
{
dbc.BindClientName(ddl_ClientName);
}
else
{
dbc.BindClientNo(ddl_ClientName);
}
dbc.BindOrderType(ddl_ordertype);
userid = User_Id;
dbc.BindState(ddl_State);
int clientid = int.Parse(ddl_ClientName.SelectedValue.ToString());
if (User_Role_Id == 1)
{
dbc.BindSubProcessName(ddl_SubProcess, clientid);
}
else
{
dbc.BindSubProcessNumber(ddl_SubProcess, clientid);
}
ddl_ordertask.Visible = true;
ddl_ordertask.Items.Insert(0, "Search");
ddl_ordertask.Items.Insert(1, "Typing");
ddl_ordertask.Items.Insert(2, "Upload");
ddl_ordertask.Items.Insert(3, "Upload Completed");
ddl_ordertask.Items.Insert(4, "Abstractor");
ddl_ordertask.Items.Insert(5, "Vendor");
// ddl_Search_Type.Visible = true;
// ddl_Search_Type.Items.Insert(0, "SELECT");
//ddl_Search_Type.Items.Insert(0, "TIER 1");
//ddl_Search_Type.Items.Insert(1, "TIER 2");
//ddl_Search_Type.Items.Insert(2, "TIER 2-In house");
// ddl_Order_Source.Items.Insert(0, "SELECT");
ddl_Order_Source.Items.Insert(0, "Online");
ddl_Order_Source.Items.Insert(1, "Subscription");
ddl_Order_Source.Items.Insert(2, "Plant");
ddl_Order_Source.Items.Insert(3, "Abstractor");
ddl_Order_Source.Items.Insert(4, "Online/Abstractor");
//Order_Controls_Load();
Order_Id = Orderid;
// SetMyCustomFormat();
if (ddl_ClientName.SelectedIndex != 0)
{
dbc.BindSubProcessName(ddl_SubProcess, clientid);
// ddl_SubProcess.SelectedValue =Convert.ToString(SubprocessId);
ddl_SubProcess.Focus();
}
}
public void load_order_masters()
{
if (User_Role == "1" || userid == 260 || userid == 179)
{
dbc.BindClientName(ddl_ClientName);
dbc.BindClientName(ddl_Client_Search);
}
else
{
dbc.BindClientNo_for_Report(ddl_ClientName);
dbc.BindClientNo_for_Report(ddl_Client_Search);
}
dbc.BindOrderType(ddl_ordertype);
dbc.BindState(ddl_State);
client_Id = int.Parse(ddl_ClientName.SelectedValue.ToString());
ddl_ordertask.Visible = true;
ddl_ordertask.Items.Insert(0, "Search");
ddl_ordertask.Items.Insert(1, "Typing");
ddl_ordertask.Items.Insert(2, "Upload");
ddl_ordertask.Items.Insert(3, "Upload Completed");
ddl_ordertask.Items.Insert(4, "Abstractor");
// ddl_Search_Type.Visible = true;
// ddl_Search_Type.Items.Insert(0, "SELECT");
//ddl_Search_Type.Items.Insert(0, "TIER 1");
//ddl_Search_Type.Items.Insert(1, "TIER 2");
//ddl_Search_Type.Items.Insert(2, "TIER 2-In house");
// ddl_Order_Source.Items.Insert(0, "SELECT");
ddl_Order_Source.Items.Insert(0, "Online");
ddl_Order_Source.Items.Insert(1, "Subscription");
ddl_Order_Source.Items.Insert(2, "Plant");
ddl_Order_Source.Items.Insert(3, "Abstractor");
ddl_Order_Source.Items.Insert(4, "Online/Abstractor");
//Order_Controls_Load();
// SetMyCustomFormat();
if (ddl_ClientName.SelectedIndex != 0)
{
if (User_Role == "1" || userid == 260 || userid == 179)
{
dbc.BindSubProcessName(ddl_SubProcess, client_Id);
}
else
{
dbc.BindSubProcessNumber(ddl_SubProcess, client_Id);
}
// ddl_SubProcess.SelectedValue =Convert.ToString(SubprocessId);
ddl_SubProcess.Focus();
}
}
protected void ddl_ClientName_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddl_ClientName.SelectedIndex != 0)
{
int clientid = int.Parse(ddl_ClientName.SelectedValue.ToString());
dbc.BindSubProcessName(ddl_SubProcess, clientid);
GetClintNumber();
}
}
protected void grd_Orders_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditDetails")
{
DivCreate.Visible = true;
DivView.Visible = false;
ddl_ordersTask.Enabled = false;
ddl_orderstatus.Enabled = false;
GridViewRow row = (GridViewRow)(((Button)e.CommandSource).NamingContainer);
Label lbl_Order_ID = (Label)row.FindControl("lblOrder_id");
ViewState["Orderid"] = lbl_Order_ID.Text;
btn_Save.Text = "Edit Order";
Hashtable htselect = new Hashtable();
DataTable dtselect = new DataTable();
htselect.Add("@Trans", "SELECT_ORDER_WISE");
htselect.Add("@Order_ID", lbl_Order_ID.Text);
dtselect = dataaccess.ExecuteSP("Sp_Order", htselect);
if (dtselect.Rows.Count > 0)
{
txt_OrderNumber.Text = dtselect.Rows[0]["Client_Order_Number"].ToString();
ddl_ordertype.SelectedValue = dtselect.Rows[0]["Order_Type"].ToString();
ddl_ordersTask.SelectedValue = dtselect.Rows[0]["Order_Task_Id"].ToString();
ddl_ClientName.SelectedValue = dtselect.Rows[0]["Client_Id"].ToString();
dbc.BindSubProcessName(ddl_SubProcess, int.Parse(ddl_ClientName.SelectedValue.ToString()));
ddl_SubProcess.SelectedValue = dtselect.Rows[0]["Sub_ProcessId"].ToString();
txt_PhoneNumber.Text = dtselect.Rows[0]["Phone_Number"].ToString();
txt_ParcelNumber.Text = dtselect.Rows[0]["Parecel_Id"].ToString();
txt_ContractNumber.Text = dtselect.Rows[0]["Contract_Number"].ToString();
txt_BatchNumber.Text = dtselect.Rows[0]["Batch_Number"].ToString();
txt_LoanNumber.Text = dtselect.Rows[0]["Loan_Number"].ToString();
txt_ZipCode.Text = dtselect.Rows[0]["Barrower_Zip"].ToString();
txt_City.Text = dtselect.Rows[0]["Barrower_City"].ToString();
ddl_State.SelectedValue = dtselect.Rows[0]["Barrower_State"].ToString();
dbc.BindCounty(ddl_County, int.Parse(ddl_State.SelectedValue.ToString()));
ddl_County.SelectedValue = dtselect.Rows[0]["Barrower_County"].ToString();
ddl_orderstatus.SelectedValue = dtselect.Rows[0]["Order_Status"].ToString();
txt_BorrowerFirstname.Text = dtselect.Rows[0]["Borrower_Name"].ToString();
txt_BorrowerLastname.Text = dtselect.Rows[0]["Last_Name"].ToString();
txt_Date.Text = dtselect.Rows[0]["Date"].ToString();
txt_Notes.Text = dtselect.Rows[0]["Notes"].ToString();
txt_BarrowerAddress.Text = dtselect.Rows[0]["Barrower_Address"].ToString();
}
}
else if (e.CommandName == "DeleteRecord")
{
GridViewRow row = (GridViewRow)(((Button)e.CommandSource).NamingContainer);
Label lbl_Order_ID = (Label)row.FindControl("lblOrder_id");
Hashtable ht = new Hashtable();
DataTable dt = new DataTable();
ht.Add("@Trans", "DELETE");
ht.Add("@Order_ID", lbl_Order_ID.Text);
dt = dataaccess.ExecuteSP("Sp_Order", ht);
Gridview_Bind_Orders();
}
}
protected void ddl_Client_Name_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddl_Client_Name.SelectedValue != "0")
{
dbc.BindSubProcessName(ddl_Client_SubProcess, int.Parse(ddl_Client_Name.SelectedValue));
}
}
public Rework_Superqc_Order_Entry(int Orderid, int User_Id, string entry_type, string USER_ROLE, string PRODUCTION_DATE)
{
InitializeComponent();
Order_Id = Orderid;
userid = User_Id;
User_Role = USER_ROLE;
Production_Date = PRODUCTION_DATE;
if (User_Role == "1")
{
dbc.BindClientName(ddl_ClientName);
}
else
{
dbc.BindClientNo(ddl_ClientName);
}
dbc.BindOrderType(ddl_ordertype);
userid = User_Id;
Entry_Type = entry_type;
dbc.BindState(ddl_State);
clientid = int.Parse(ddl_ClientName.SelectedValue.ToString());
if (User_Role == "1")
{
dbc.BindSubProcessName(ddl_SubProcess, clientid);
}
else
{
dbc.BindSubProcessNumber(ddl_SubProcess, clientid);
}
dbc.BindAbstractor_Order_Serarh_Type(ddl_Abstractor_Search_Type);
ddl_ordertask.Visible = true;
ddl_ordertask.Items.Insert(0, "Search");
ddl_ordertask.Items.Insert(1, "Search QC");
ddl_ordertask.Items.Insert(2, "Typing");
ddl_ordertask.Items.Insert(3, "Typing QC");
ddl_ordertask.Items.Insert(4, "Upload");
ddl_ordertask.Items.Insert(5, "Upload Completed");
ddl_ordertask.Items.Insert(6, "Abstractor");
ddl_Order_Source.Items.Insert(0, "Online");
ddl_Order_Source.Items.Insert(1, "Subscription");
ddl_Order_Source.Items.Insert(2, "Abstractor");
ddl_Order_Source.Items.Insert(3, "Online/Abstractor");
ddl_Order_Source.Items.Insert(4, "Online/Data Tree");
ddl_Order_Source.Items.Insert(5, "Data Trace");
ddl_Order_Source.Items.Insert(6, "Title Point");
}
private void Bind_Individual_Invoice_Info()
{
Hashtable ht = new Hashtable();
DataTable dt = new DataTable();
ht.Add("@Trans", "SELECT_TAX_INVOICE_GEN_RECORD");
ht.Add("@Tax_Invoice_Id", orderid);
dt = dataaccess.ExecuteSP("Sp_Tax_Invoice_Entry", ht);
if (dt.Rows.Count > 0)
{
ddl_ClientName.SelectedValue = int.Parse(dt.Rows[0]["Client_Id"].ToString());
dbc.BindSubProcessName(ddl_SubProcess, int.Parse(ddl_ClientName.SelectedValue.ToString()));
ddl_SubProcess.SelectedValue = int.Parse(dt.Rows[0]["Subclient_Id"].ToString());
ddl_ordertype.SelectedValue = int.Parse(dt.Rows[0]["Order_type_Id"].ToString());
txt_OrderNumber.Text = dt.Rows[0]["Client_Order_Number"].ToString();
txt_APN.Text = dt.Rows[0]["APN"].ToString();
txt_Client_order_ref.Text = dt.Rows[0]["Client_Order_Ref"].ToString();
txt_Address.Text = dt.Rows[0]["Address"].ToString();
txt_Borrowername.Text = dt.Rows[0]["Borrower_Name"].ToString();
ddl_State.SelectedValue = int.Parse(dt.Rows[0]["State"].ToString());
dbc.BindCounty(ddl_County, int.Parse(ddl_State.SelectedIndex.ToString()));
ddl_County.SelectedValue = int.Parse(dt.Rows[0]["County"].ToString());
txt_City.Text = dt.Rows[0]["City"].ToString();
txt_Zip.Text = dt.Rows[0]["Zip"].ToString();
ddl_ordertask.SelectedValue = int.Parse(dt.Rows[0]["Order_Status"].ToString());
txt_Notes.Text = dt.Rows[0]["Notes"].ToString();
txt_Date.Text = dt.Rows[0]["Received_Date"].ToString();
ddl_Hour.Text = dt.Rows[0]["Hour"].ToString();
ddl_Minute.Text = dt.Rows[0]["Minute"].ToString();
ddl_Sec.Text = dt.Rows[0]["Sec"].ToString();
//ddl_Order_Source.SelectedValue = int.Parse(dt.Rows[0]["Order_source"].ToString());
txt_Search_cost.Text = dt.Rows[0]["Base_Cost"].ToString();
txt_Copy_cost.Text = dt.Rows[0]["Maily_way_Cost"].ToString();
txt_Tax_Invoice_baseCost.Text = dt.Rows[0]["Base_Cost"].ToString();
txt_Tax_Invoice_Mail_Cost.Text = dt.Rows[0]["Maily_way_Cost"].ToString();
txt_Invoice_Date.Text = dt.Rows[0]["Invoice_Date"].ToString();
txt_Invoice_comments.Text = dt.Rows[0]["Comments"].ToString();
Indiv_Orderid = int.Parse(dt.Rows[0]["Tax_Invoice_Id"].ToString());
orderid = int.Parse(dt.Rows[0]["Order_ID"].ToString());
Control_Enable_false();
}
}
public Abstractor_Order_View(int Orderid, int User_Id, string USER_ROLE_ID)
{
InitializeComponent();
// Clear();
pnl_visible();
User_Role_Id = USER_ROLE_ID;
// Order_Entry.ActiveForm.Width = 1045;
if (User_Role_Id == "1")
{
dbc.BindClientName(ddl_ClientName);
}
else
{
dbc.BindClientNo(ddl_ClientName);
}
dbc.BindOrderType(ddl_ordertype);
userid = User_Id;
dbc.BindState(ddl_State);
if (ddl_ClientName.SelectedIndex > 0)
{
clientid = int.Parse(ddl_ClientName.SelectedValue.ToString());
}
if (User_Role_Id == "1")
{
dbc.BindSubProcessName(ddl_SubProcess, clientid);
}
else
{
dbc.BindSubProcessNumber(ddl_SubProcess, clientid);
}
ddl_ordertask.Visible = true;
ddl_ordertask.Items.Insert(0, "Search");
ddl_ordertask.Items.Insert(1, "Typing");
ddl_ordertask.Items.Insert(2, "Upload");
ddl_ordertask.Items.Insert(3, "Upload Completed");
ddl_ordertask.Items.Insert(4, "Abstractor");
// ddl_Order_Source.Items.Insert(0, "SELECT");
ddl_Order_Source.Items.Insert(0, "Online");
ddl_Order_Source.Items.Insert(1, "Subscription");
ddl_Order_Source.Items.Insert(2, "Plant");
ddl_Order_Source.Items.Insert(3, "Abstractor");
ddl_Order_Source.Items.Insert(4, "Online/Abstractor");
//Order_Controls_Load();
Order_Id = Orderid;
// SetMyCustomFormat();
if (ddl_ClientName.SelectedIndex != 0)
{
dbc.BindSubProcessName(ddl_SubProcess, clientid);
// ddl_SubProcess.SelectedValue =Convert.ToString(SubprocessId);
ddl_SubProcess.Focus();
}
}
public void load_order_masters()
{
dbc.BindClientName(ddl_ClientName);
dbc.BindOrderType(ddl_ordertype);
dbc.BindState(ddl_State);
dbc.BindProduction_Unit_Type(ddl_Production_Unit);
dbc.Bind_Employee_Order_source(ddl_Inhouse_Order_Source);
dbc.Bind_Invoice_Ordered_For(ddl_Inhouse_Ordered_For);
client_Id = int.Parse(ddl_ClientName.SelectedValue.ToString());
ddl_ordertask.Visible = true;
ddl_ordertask.Items.Insert(0, "Search");
ddl_ordertask.Items.Insert(1, "Typing");
ddl_ordertask.Items.Insert(2, "Upload");
ddl_ordertask.Items.Insert(3, "Upload Completed");
ddl_ordertask.Items.Insert(4, "Abstractor");
// ddl_Search_Type.Visible = true;
// ddl_Search_Type.Items.Insert(0, "SELECT");
//ddl_Search_Type.Items.Insert(0, "TIER 1");
//ddl_Search_Type.Items.Insert(1, "TIER 2");
//ddl_Search_Type.Items.Insert(2, "TIER 2-In house");
// ddl_Order_Source.Items.Insert(0, "SELECT");
ddl_Order_Source.Items.Insert(0, "Online");
ddl_Order_Source.Items.Insert(1, "Subscription");
ddl_Order_Source.Items.Insert(2, "Plant");
ddl_Order_Source.Items.Insert(3, "Abstractor");
ddl_Order_Source.Items.Insert(4, "Online/Abstractor");
//Order_Controls_Load();
// SetMyCustomFormat();
if (ddl_ClientName.SelectedIndex != 0)
{
dbc.BindSubProcessName(ddl_SubProcess, client_Id);
// ddl_SubProcess.SelectedValue =Convert.ToString(SubprocessId);
ddl_SubProcess.Focus();
}
}
protected void Bind_Order_Details()
{
Hashtable htselect = new Hashtable();
DataTable dtselect = new DataTable();
htselect.Add("@Trans", "SELECT_ORDER_WISE");
htselect.Add("@Order_ID", Order_Id);
dtselect = dataaccess.ExecuteSP("Sp_Order", htselect);
if (dtselect.Rows.Count > 0)
{
txt_OrderNumber.Text = dtselect.Rows[0]["Client_Order_Number"].ToString();
ddl_ordertype.SelectedValue = dtselect.Rows[0]["Order_Type"].ToString();
ddl_ordersTask.SelectedValue = dtselect.Rows[0]["Order_Task_Id"].ToString();
ddl_ClientName.SelectedValue = dtselect.Rows[0]["Client_Id"].ToString();
dbc.BindSubProcessName(ddl_SubProcess, int.Parse(ddl_ClientName.SelectedValue.ToString()));
ddl_SubProcess.SelectedValue = dtselect.Rows[0]["Sub_ProcessId"].ToString();
txt_PhoneNumber.Text = dtselect.Rows[0]["Phone_Number"].ToString();
txt_ParcelNumber.Text = dtselect.Rows[0]["Parecel_Id"].ToString();
txt_ContractNumber.Text = dtselect.Rows[0]["Contract_Number"].ToString();
txt_BatchNumber.Text = dtselect.Rows[0]["Batch_Number"].ToString();
txt_LoanNumber.Text = dtselect.Rows[0]["Loan_Number"].ToString();
txt_ZipCode.Text = dtselect.Rows[0]["Barrower_Zip"].ToString();
txt_City.Text = dtselect.Rows[0]["Barrower_City"].ToString();
ddl_State.SelectedValue = dtselect.Rows[0]["Barrower_State"].ToString();
dbc.BindCounty(ddl_County, int.Parse(ddl_State.SelectedValue.ToString()));
ddl_County.SelectedValue = dtselect.Rows[0]["Barrower_County"].ToString();
ddl_orderstatus.SelectedValue = dtselect.Rows[0]["Order_Status"].ToString();
txt_BorrowerFirstname.Text = dtselect.Rows[0]["Borrower_Name"].ToString();
txt_BorrowerLastname.Text = dtselect.Rows[0]["Last_Name"].ToString();
txt_Date.Text = dtselect.Rows[0]["Date"].ToString();
txt_Notes.Text = dtselect.Rows[0]["Notes"].ToString();
txt_BarrowerAddress.Text = dtselect.Rows[0]["Barrower_Address"].ToString();
grd_Bind_Order_Task_Details();
grd_Bind_Comment_Details();
}
}