//New
protected void B_21_OnClick(object sender, EventArgs e)
{
try
{
Rep_General general = new Rep_General();
DataTable user = (DataTable)Session["user"];
int userId = int.Parse(user.Rows[0]["UserID"].ToString());
string module = general.SelectModule(userId, "AccountSearch");
if (module != "Stop")
{
string accId = Request.QueryString[general.ObfuscateQueryString("accID")].ToString();
Response.Redirect("~/Modules/" + module + ".aspx?" + general.ObfuscateQueryString("accID") + "=" + accId + "", false);
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", "Access Denied"), true);
}
}
catch (Exception ex)
{
string error = ex.Message;
string errText = error.Replace("\'", "");
string AlertMSG = "";
AlertMSG += error;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", AlertMSG), true);
}
}
private DataTable SelectContacts()
{
DataTable contactsDt = new DataTable();
try
{
Rep_Account accountSearch = new Rep_Account();
Rep_General general = new Rep_General();
DataTable User = (DataTable)Session["user"];
string userId = User.Rows[0]["UserID"].ToString();
string accId = "";
if (Request.QueryString[general.ObfuscateQueryString("accID")] != null)
{
string value = Request.QueryString[general.ObfuscateQueryString("accID")].ToString();
accId = general.DecryptIds(int.Parse(value)).ToString();
}
contactsDt = accountSearch.SelectContactSearch(int.Parse(userId), accId);
}
catch (Exception ex)
{
string error = ex.Message;
string errText = error.Replace("\'", "");
string AlertMSG = "Error occurred please try again ";
AlertMSG += errText;
this.ClientScript.RegisterStartupScript(this.GetType(), this.GetType().Name,
string.Format("window.alert('{0}');", AlertMSG), true);
}
return(contactsDt);
}
protected void CustomersGRD_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "EditCommand")
{
//string strKey = e.CommandArgument.ToString();
string strr = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["AccID"].ToString();
//Response.Redirect("~/Modules/Account/AccountAdd.aspx?ARXDWB=" + strr + "");
try
{
Rep_General accountSearch = new Rep_General();
DataTable user = (DataTable)Session["user"];
int userId = int.Parse(user.Rows[0]["UserID"].ToString());
string module = accountSearch.SelectModule(userId, "AccountAdd");
if (module != "Stop")
{
int accId = accountSearch.EncryptIds(int.Parse(strr));
Response.Redirect("~/Modules/" + module + ".aspx?" + accountSearch.ObfuscateQueryString("accID") + "=" + accId + "");
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", "Access Denied"), true);
}
}
catch (Exception ex)
{
string error = ex.Message;
string errText = error.Replace("\'", "");
string AlertMSG = "";
AlertMSG += error;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", AlertMSG), true);
}
}
#region Link
else if (e.CommandName == "LinkCommand")
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("ShowconfirmDialog();"), true);
lblAccId.Text = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["AccID"].ToString();
}
#endregion Link
#region Refresh Grid
else if (e.CommandName == "RebindGrid")
{
SearchBTN_Click(null, null);
}
#endregion Refresh Grid
#region Else
else
{
SearchBTN_Click(null, null);
}
#endregion Else
}
protected void AddCustomerBTN_Click(object sender, EventArgs e)
{
//WindowsFlag = true;
//AddCustomerWindow.Visible = true;
//AddCustomerWindow.VisibleOnPageLoad = true;
//Response.Redirect("CreateAccount.aspx");
//Response.Redirect("~/Modules/Account/AccountCreate.aspx");
//Response.Redirect("~/Modules/Account/AccountCreate.aspx?UZQF=1");
try
{
Rep_General accountSearch = new Rep_General();
DataTable user = (DataTable)Session["user"];
int userId = int.Parse(user.Rows[0]["UserID"].ToString());
string module = accountSearch.SelectModule(userId, "AccountAdd");
if (module != "Stop")
{
if (Request.QueryString[accountSearch.ObfuscateQueryString("accID")] != null)
{
string accId = Request.QueryString[accountSearch.ObfuscateQueryString("accID")].ToString();
Response.Redirect("~/Modules/" + module + ".aspx?" + accountSearch.ObfuscateQueryString("accID") + "=" + accId + "&" + accountSearch.ObfuscateQueryString("view") + "=1", false);
}
else
{
Response.Redirect("~/Modules/" + module + ".aspx", false);
}
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", "Access Denied"), true);
}
}
catch (Exception ex)
{
string error = ex.Message;
string errText = error.Replace("\'", "");
string AlertMSG = "";
AlertMSG += error;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", AlertMSG), true);
}
}
private void Select_Account_Crdt()
{
try
{
DataTable User = (DataTable)Session["user"];
Rep_General general = new Rep_General();
string userId = User.Rows[0]["UserID"].ToString();
string accId = Request.QueryString[general.ObfuscateQueryString("accID")].ToString();
int id = general.DecryptIds(int.Parse(accId));
Rep_Account accountCrdt = new Rep_Account();
DataTable accCrdtTable = accountCrdt.SelectCrdt(int.Parse(userId), id);
if (accCrdtTable.Rows.Count > 0)
{
txtCrdtNo.Text = accCrdtTable.Rows[0]["AccCrdtNo"].ToString();
dllCategory_1.Text = accCrdtTable.Rows[0]["AccCrdtGategory1"].ToString();
dllCategory_2.Text = accCrdtTable.Rows[0]["AccCrdtGategory2"].ToString();
dllResponsible.Text = accCrdtTable.Rows[0]["AccCrdtResp"].ToString();
dllType.Text = accCrdtTable.Rows[0]["AccCrdtType"].ToString();
txtMax.Text = accCrdtTable.Rows[0]["AccCrdtMax"].ToString();
txtExtra.Text = accCrdtTable.Rows[0]["AccCrdtExtra"].ToString();
txtMemo.InnerText = accCrdtTable.Rows[0]["AccCrdtMemo"].ToString();
RBLBlocked.Text = accCrdtTable.Rows[0]["AccCrdtStop"].ToString() == "True" ? "1" : "2";
//RBLBlocked.Items.FindByText(accCrdTable.Rows[0]["AccCrdtStop"].ToString()).Selected = true;
}
else
{
}
string texttaccNo = Request.QueryString[general.ObfuscateQueryString("accNo")] != null ? Request.QueryString[general.ObfuscateQueryString("accNo")].ToString() : "";
accNo.Text = texttaccNo != string.Empty ? general.DecryptIds(int.Parse(texttaccNo)).ToString() : "";
}
catch (Exception ex)
{
string error = ex.Message;
string errText = error.Replace("\'", "");
string AlertMSG = "";
AlertMSG += errText;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", AlertMSG), true);
}
}
private void Select_Account_Name()
{
try
{
Rep_General general = new Rep_General();
DataTable User = (DataTable)Session["user"];
string userId = User.Rows[0]["UserID"].ToString();
string accId = "";
if (Request.QueryString[general.ObfuscateQueryString("accID")] != null)
{
string value = Request.QueryString[general.ObfuscateQueryString("accID")].ToString();
accId = general.DecryptIds(int.Parse(value)).ToString();
}
else
{
//accId = lblAccID.Text;
}
Rep_Account account = new Rep_Account();
DataTable accTable = account.SelectAcc(int.Parse(userId), int.Parse(accId));
if (accTable.Rows.Count > 0)
{
accNo.Text = accTable.Rows[0]["AccNo"].ToString();
accName.Text = accTable.Rows[0]["AccName"].ToString();
}
else
{
}
}
catch (Exception ex)
{
string error = ex.Message;
string errText = error.Replace("\'", "");
string AlertMSG = "";
AlertMSG += errText;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", AlertMSG), true);
}
}
protected void btnLinkContact_OnClick(object sender, EventArgs e)
{
try
{
Rep_General general = new Rep_General();
Rep_Account contactLink = new Rep_Account();
DataTable user = (DataTable)Session["user"];
int userId = int.Parse(user.Rows[0]["UserID"].ToString());
int accId = general.DecryptIds(int.Parse(Request.QueryString[general.ObfuscateQueryString("accID")].ToString()));
int accContactId = int.Parse(lblAccId.Text);
byte contactType = byte.Parse(ddlContactType.Text);
contactLink.Contact_Link(userId, accId, accContactId, contactType);
//return to contact page
string module = general.SelectModule(userId, "AccountContact");
if (module != "Stop")
{
int value = int.Parse(Request.QueryString[general.ObfuscateQueryString("accID")].ToString());
Response.Redirect("~/Modules/" + module + ".aspx?" + general.ObfuscateQueryString("accID") + "=" + value + "", false);
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", "Access Denied"), true);
}
}
catch (Exception ex)
{
string error = ex.Message;
string errText = error.Replace("\'", "");
string AlertMSG = "";
AlertMSG += errText;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", AlertMSG), true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Generate_Buttons();
Get_Navegation_Panel();
Rep_General general = new Rep_General();
if (!IsPostBack)
{
Get_ddls();
Get_AccCrdt_Blocked();
}
if (Request.QueryString[general.ObfuscateQueryString("accID")] != null)
{
if (!IsPostBack)
{
string lblaccId = Request.QueryString[general.ObfuscateQueryString("accID")].ToString();
lblAccID.Text = general.DecryptIds(int.Parse(lblaccId)).ToString();
Select_Account_Crdt();
Select_Account_Name();
hidnViewFlag.Value = "View";
lblSubject.Text = "View";
}
}
else if (hidnViewFlag.Value == "Update")
{
}
else
{
if (!IsPostBack)
{
hidnViewFlag.Value = "Add";
lblSubject.Text = "New";
}
}
//get Roles after check the flag value
Btn_Fields_Roles();
}
private void Get_ContactType()
{
try
{
Rep_General general = new Rep_General();
Rep_Account accountUdt = new Rep_Account();
DataTable User = (DataTable)Session["user"];
DataTable accUdtTable = new DataTable();
string userId = User.Rows[0]["UserID"].ToString();
string accId = "";
if (Request.QueryString[general.ObfuscateQueryString("accID")] != null)
{
string value = Request.QueryString[general.ObfuscateQueryString("accID")].ToString();
accId = general.DecryptIds(int.Parse(value)).ToString();
accUdtTable = accountUdt.SelectAcc(int.Parse(userId), int.Parse(accId));
}
else
{
}
ddlContactType.DataSource = SelectddlDataTable("SP_SysCode_AccContact_Type", accUdtTable.Rows[0]["AccCategory"].ToString());
ddlContactType.DataTextField = "ContactType";
ddlContactType.DataValueField = "ContactTypeID";
ddlContactType.DataBind();
ddlContactType.Items.Insert(0, new ListItem("Select", "-1"));
}
catch (Exception ex)
{
string error = ex.Message;
string errText = error.Replace("\'", "");
string AlertMSG = "";
AlertMSG += errText;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", AlertMSG), true);
}
}
protected void panel_lnkAccSales_OnClick(object sender, EventArgs e)
{
Rep_General general = new Rep_General();
foreach (GridDataItem selectinganItem in CustomersGRD.MasterTableView.Items)
{
if (selectinganItem.Selected)
{
try
{
int accId = general.EncryptIds(int.Parse(selectinganItem["AccID"].Text));
int accNo = general.EncryptIds(int.Parse(selectinganItem["AccNo"].Text));
Rep_General accountSearch = new Rep_General();
DataTable user = (DataTable)Session["user"];
int userId = int.Parse(user.Rows[0]["UserID"].ToString());
string module = accountSearch.SelectModule(userId, "AccountSales");
if (module != "Stop")
{
Response.Redirect("~/Modules/" + module + ".aspx?" + general.ObfuscateQueryString("accID") + "=" + accId + "&" + general.ObfuscateQueryString("accNo") + "=" + accNo + "", false);
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", "Access Denied"), true);
}
}
catch (Exception ex)
{
string error = ex.Message;
string errText = error.Replace("\'", "");
string AlertMSG = "";
AlertMSG += error;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", AlertMSG), true);
}
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", "Please select your record"), true);
}
}
}
private void Udt_Account_Crdt()
{
try
{
Rep_General general = new Rep_General();
Rep_Account accountCrdt = new Rep_Account();
string value = Request.QueryString[general.ObfuscateQueryString("accID")].ToString();
DataTable user = (DataTable)Session["user"];
int userId = int.Parse(user.Rows[0]["UserID"].ToString());
int accId = general.DecryptIds(int.Parse(value));
int crdtNo = int.Parse(txtCrdtNo.Text);
byte crdtCategory1 = byte.Parse(dllCategory_1.Text);
byte crdtCategory2 = byte.Parse(dllCategory_2.Text);
byte crdtType = byte.Parse(dllType.Text);
double crdtMax = double.Parse(txtMax.Text);
double crdtExtra = double.Parse(txtExtra.Text);
byte crdtStop = byte.Parse(RBLBlocked.Text);
byte crdtResp = byte.Parse(dllResponsible.Text);
string crdtMemo = txtMemo.InnerText;
string aUpdateCrdtccUdt = accountCrdt.UpdateCrdt(userId, accId, crdtNo, crdtCategory1, crdtCategory2, crdtType, crdtMax, crdtExtra, crdtStop, crdtResp, crdtMemo);
Disable_Fields();
Select_Account_Crdt();
hidnViewFlag.Value = "View";
lblSubject.Text = "View";
Btn_Fields_Roles();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", aUpdateCrdtccUdt), true);
}
catch (Exception ex)
{
string error = ex.Message;
string errText = error.Replace("\'", "");
string AlertMSG = "";
AlertMSG += error;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", AlertMSG), true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Generate_Buttons();
Get_Navegation_Panel();
Rep_General general = new Rep_General();
if (!IsPostBack)
{
if (Request.QueryString[general.ObfuscateQueryString("accID")] != null)
{
CustomersGRD.MasterTableView.Columns.FindByUniqueName("EditCustomer").Display = false;
Get_ContactType();
Select_Account_Name();
accHeader.Attributes["style"] = @"display: normal;";
}
else
{
CustomersGRD.MasterTableView.Columns.FindByUniqueName("LinkCustomer").Display = false;
}
//DataTable InitialDT = SelectCustomers();
//CustomersGRD.DataSource = InitialDT;
//CustomersGRD.DataBind();
//AddCustomerWindow.VisibleOnPageLoad = false;
}
else
{
//if (!WindowsFlag)
//{
// AddCustomerWindow.VisibleOnPageLoad = false;
//}
//else
//{
// AddCustomerWindow.VisibleOnPageLoad = true;
// WindowsFlag = false;
//}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Get_Navegation_Panel();
if (!IsPostBack)
{
Generate_Buttons();
Rep_General general = new Rep_General();
if (Request.QueryString[general.ObfuscateQueryString("accID")] != null)
{
if (hidnViewFlag.Value == "Update")
{
//hidnViewFlag.Value = "Update";
lblSubject.Text = "Edit";
}
else if (hidnViewFlag.Value == "Add")
{
//hidnViewFlag.Value = "Add";
lblSubject.Text = "New";
}
else
{
hidnViewFlag.Value = "View";
lblSubject.Text = "View";
AccIDEnc.Value = Request.QueryString[general.ObfuscateQueryString("accID")].ToString();
DataTable User = Session["user"] != null ? (DataTable)Session["user"] : new DataTable();
if (User.Rows.Count > 0)
{
UserID.Value = User.Rows[0]["UserID"].ToString();
lblAccID.Text = general.DecryptIds(int.Parse(AccIDEnc.Value)).ToString();
AccIDDec.Value = lblAccID.Text;
string texttaccNo = Request.QueryString[general.ObfuscateQueryString("accNo")] != null
? Request.QueryString[general.ObfuscateQueryString("accNo")].ToString()
: "";
accNo.Text = texttaccNo != string.Empty ? general.DecryptIds(int.Parse(texttaccNo)).ToString() : "";
Rep_Account account = new Rep_Account();
DataTable accTable = account.SelectAcc(int.Parse(UserID.Value), int.Parse(AccIDDec.Value));
accName.Text = accTable.Rows.Count > 0 ? accTable.Rows[0]["AccName"].ToString() : string.Empty;
FillDDLs();
FillAccountSales(GetAccountSales());
}
else
{
B_11_OnClick(null, null);
}
}
//get Roles after check the flag value
Btn_Fields_Roles();
DisableEdit();
}
else
{
B_11_OnClick(null, null);
}
}
else
{
// FillAccountInfoGRD();
}
}
private DataTable SelectCustomers()
{
//string SelectCommand = "SELECT Account.AccID, Account.AccNo, Account.AccName, Account.Cancelled, AccountInfo.LineID, AccountInfo.InfoType, AccountInfo.InfoData, AccountInfo.Cancelled AS Expr1 "
// + " FROM Account INNER JOIN "
// + " AccountInfo ON Account.AccID = AccountInfo.AccID "
// + " and Account.Cancelled = 0 "
// + " and CONCAT(Account.AccNo ,' ' , Account.AccName ,' ', AccountInfo.InfoData) like @search ";
//SqlCommand SqlSelectCommand = new SqlCommand(SelectCommand, CustomersConnection);
// SqlSelectCommand.Parameters.Add("@SearchText", SqlDbType.NVarChar, 65);
// SqlSelectCommand.Parameters.Add("@SearchText", System.Data.SqlDbType.Text);
// SqlSelectCommand.Parameters["@SearchText"].Value = SearchTXT.Text;
// adapter.InsertCommand.Parameters.Add("@CompanyName",
//SqlDbType.VarChar, 40, "CompanyName");
//SqlDataAdapter CustomersDA = new SqlDataAdapter("SP_Account_Search", CustomersConnection);
//CustomersDA.SelectCommand.CommandType = CommandType.StoredProcedure;
//CustomersDA.SelectCommand.Parameters.AddWithValue("@UserID", userId);
//CustomersDA.SelectCommand.Parameters.AddWithValue("@SearchType", "Mobile");
//CustomersDA.SelectCommand.Parameters.AddWithValue("@ModuleName", "AccountSearch");
//CustomersDA.SelectCommand.Parameters.AddWithValue("@search", "%" + SearchTXT.Text + "%");
//CustomersDA.SelectCommand.Parameters.AddWithValue("@SearchText", SearchTXT.Text);
//Add(SearchTXT.Text);
//CustomersDA.Fill(CustomersDT);
DataTable CustomersDT = new DataTable();
DataTable boundTable = new DataTable();
try
{
Rep_Account accountSearch = new Rep_Account();
Rep_General general = new Rep_General();
DataTable User = (DataTable)Session["user"];
string userId = User.Rows[0]["UserID"].ToString();
CustomersDT = accountSearch.SelectSearch(int.Parse(userId), "Mobile", SearchTXT.Text, "AccountSearch");
//if query string
if (Request.QueryString[general.ObfuscateQueryString("accID")] != null)
{
DataTable contactsDt = new DataTable();
int accId = general.DecryptIds(int.Parse(Request.QueryString[general.ObfuscateQueryString("accID")].ToString()));
contactsDt = accountSearch.SelectContactSearch(int.Parse(userId), accId.ToString());
//var rows = from r in CustomersDT.AsEnumerable()
// //make sure there aren't any matching names in dt2
// where contactsDt.AsEnumerable().Any(r2 => r["AccID"].ToString() != r2["AccID"].ToString() && r["AccID"].ToString() != accId.ToString())
// select r;
//var rows = CustomersDT.AsEnumerable().Where(r => contactsDt.AsEnumerable()
// //make sure there aren't any matching names in dt2
// .Any( r2 => r["AccID"].ToString() != r2["AccID"].ToString() ));
//boundTable = rows.CopyToDataTable();
if (CustomersDT.Rows.Count > 0)
{
boundTable = CustomersDT.Rows.OfType <DataRow>()
.Where(a => CustomersDT.Rows.OfType <DataRow>().Select(k => Convert.ToInt32(k["AccID"])).Except(contactsDt.Rows.OfType <DataRow>()
.Select(k => Convert.ToInt32(k["AccID"])).ToList()).Contains(Convert.ToInt32(a["AccID"])) && Convert.ToInt32(a["AccID"]) != accId).CopyToDataTable();
}
}
else
{
if (CustomersDT.Rows.Count > 0)
{
boundTable = CustomersDT;
}
}
}
catch (Exception ex)
{
string error = ex.Message;
string errText = error.Replace("\'", "");
string AlertMSG = "Error occurred please try again ";
AlertMSG += errText;
this.ClientScript.RegisterStartupScript(this.GetType(), this.GetType().Name,
string.Format("window.alert('{0}');", AlertMSG), true);
}
return(boundTable);
}
