public void UserNameExist(string suario, string searchType, string accName)
{
DataTable accNameTable = new DataTable();
string nameInUse = "0";
Rep_Account accountSearch = new Rep_Account();
//DataTable User = (DataTable)Session["user"];
//userId = "4";
accName = Regex.Replace(accName, "[ ]{2,}", " ");
accNameTable = accountSearch.SelectSearch(int.Parse(suario), searchType, accName, "AccountSearch");
if (accNameTable.Rows.Count > 0)
{
nameInUse = accNameTable.Rows[0]["AccID"].ToString();
}
else
{
nameInUse = "0";
}
JavaScriptSerializer js = new JavaScriptSerializer();
Context.Response.Write(js.Serialize(nameInUse));
}
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);
}
private DataTable SelectddlDataTable(string proceduer, string param)
{
DataTable ddlTable = new DataTable();
try
{
Rep_Account accountCrdtDdlsDetails = new Rep_Account();
DataTable User = (DataTable)Session["user"];
string userId = User.Rows[0]["UserID"].ToString();
ddlTable = accountCrdtDdlsDetails.SelectddlDataTable(int.Parse(userId), proceduer, param);
}
catch (Exception ex)
{
string Error = ex.Message;
string AlertMSG = "";
AlertMSG += Error;
this.ClientScript.RegisterStartupScript(this.GetType(), this.GetType().Name,
string.Format("window.alert('{0}');", AlertMSG), true);
return(ddlTable);
}
return(ddlTable);
}
protected void lbSave_Service_OnClick(object sender, EventArgs e)
{
try
{
Rep_Account accServiceSave = new Rep_Account();
DataTable user = (DataTable)Session["user"];
int userId = int.Parse(user.Rows[0]["UserID"].ToString());
string accId = AccIDDec.Value;
float service = float.Parse(txtService_2.Text);
accServiceSave.Acc_Service_Save(userId, accId, service);
txtService_2.Text = string.Empty;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", "Saved"), 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 btnSaveCurrency_OnClick(object sender, EventArgs e)
{
try
{
Rep_Account accCurrencySave = new Rep_Account();
DataTable user = (DataTable)Session["user"];
DataTable currencyDataTable = new DataTable();
int userId = int.Parse(user.Rows[0]["UserID"].ToString());
string currency = txtCurrency.Text.Replace(" ", string.Empty);
currencyDataTable = DDLsData("SP_SysCode_All_Currency");
string find = "Currency='" + currency + "'";
DataRow[] foundRows = currencyDataTable.Select(find);
if (foundRows.Length != 0)
{
//currency is exist
lblCurrencyMsg.Text = "* This currency isn't allowed. Try again";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("ShowcurrencyDialog();"), true);
}
else
{
lblCurrencyMsg.Text = "";
accCurrencySave.Acc_Currency_Save(userId, currency);
txtCurrency.Text = string.Empty;
dllCurrency.DataSource = DDLsData("SP_SysCode_All_Currency");
dllCurrency.DataTextField = "Currency";
dllCurrency.DataValueField = "CurrencyID";
dllCurrency.DataBind();
dllCurrency.Items.Insert(0, new ListItem("Select Currency", "-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 btnSaveCat2_OnClick(object sender, EventArgs e)
{
try
{
Rep_Account crdtCategorySave = new Rep_Account();
DataTable user = (DataTable)Session["user"];
DataTable categoryDT = new DataTable();
int userId = int.Parse(user.Rows[0]["UserID"].ToString());
string crdtCategory = txtAddCategory2.Text.Replace(" ", string.Empty);
categoryDT = SelectddlDataTable("SP_SysCode_AccCrdt_Category2", "");
string find = "Category='" + crdtCategory + "'";
//myDataTable.Select("columnName1 like '%" + value + "%'");
DataRow[] foundRows = categoryDT.Select(find);
if (foundRows.Length != 0)
{
//Category is exist
lblCat2Msg.Text = "* This Category isn't allowed. Try again";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("ShowCat_2_Dialog();"), true);
}
else
{
lblCat2Msg.Text = "";
crdtCategorySave.Crdt_Category2_Save(userId, crdtCategory);
txtAddCategory2.Text = string.Empty;
}
dllCategory_2.DataSource = SelectddlDataTable("SP_SysCode_AccCrdt_Category2", "");
dllCategory_2.DataValueField = "CategoryID";
dllCategory_2.DataTextField = "Category";
dllCategory_2.DataBind();
dllCategory_2.Items.Insert(0, new ListItem("- Select -", "0"));
}
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_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);
}
}
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 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);
}
}
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 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();
}
}
protected void Export_OnClick(object sender, EventArgs e)
{
//CustomersGRD.ExportSettings.ExportOnlyData = true;
//CustomersGRD.ExportSettings.IgnorePaging = true;
//CustomersGRD.ExportSettings.OpenInNewWindow = false;
//CustomersGRD.ExportSettings.UseItemStyles = true;
////CustomersGRD.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
//CustomersGRD.ExportSettings.Excel.Format = GridExcelExportFormat.Xlsx;
////CustomersGRD.ExportSettings.Excel.Format = (GridExcelExportFormat)Enum.Parse(typeof(GridExcelExportFormat), "Xlsx");
////CustomersGRD.ExportSettings.FileName = "Customers (" + DateTime.Now + ")";
//CustomersGRD.ExportSettings.FileName = string.Format("Customers_{0}", DateTime.Now);
//CustomersGRD.MasterTableView.ExportToExcel();
//PostBackTrigger trigger = new PostBackTrigger();
//trigger.ControlID = "B_42";
//AccountUpdatePanel.Triggers.Add(trigger);
//TriggerId = ID.ToString();
DataTable expCustomersDt = new DataTable();
//expCustomersDt = SelectCustomers();
try
{
Rep_Account accountSearch = new Rep_Account();
DataTable User = (DataTable)Session["user"];
string userId = User.Rows[0]["UserID"].ToString();
expCustomersDt = accountSearch.SelectSearch(int.Parse(userId), "Excel", SearchTXT.Text, "AccountSearch");
}
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);
}
if (expCustomersDt.Rows.Count <= 0)
{
//ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", string.Format("window.alert('{0}');", "No records to export"), true);
}
else
{
expCustomersDt.Columns.Remove("AccID");
using (XLWorkbook wb = new XLWorkbook())
{
wb.Worksheets.Add(expCustomersDt, "Accounts");
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;filename=" + string.Format("Accounts_{0}", DateTime.Now) + ".xlsx");
using (MemoryStream MyMemoryStream = new MemoryStream())
{
wb.SaveAs(MyMemoryStream);
MyMemoryStream.WriteTo(Response.OutputStream);
Response.Flush();
Response.End();
}
}
}
}
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);
}