public static void AddNewRowSingleColumn(int OpCode, string SpName, ref GridView dg, ref bool k_blnIsAddingNew, ref HtmlGenericControl DivError, ref Label _LblError) { string g_strErrorMessage = ""; try { DataTable GridTable = GeneralBL.FillDataGrid(OpCode, SpName, ref g_strErrorMessage, ""); //if ((GridTable.Rows.Count == 0) || (GridTable == null)) //{ // DataRow dr = GridTable.NewRow(); // GridTable.Rows.Add(dr); // dg.DataSource = GridTable; // dg.DataBind(); //} DataRow NewRow = GridTable.NewRow(); Label lblName = new Label(); if (dg.Rows.Count == 0) { lblName.Text = ""; } /************************************************************ * Here We have Two Options If the User is on First Pasge then */ //Label lblName = (Label)dg.Rows[0].FindControl(ControlName); int nNewItemIndex = dg.Rows.Count; if (nNewItemIndex < dg.PageSize) { if (lblName.Text == "") { dg.EditIndex = nNewItemIndex; } else { dg.EditIndex = nNewItemIndex; } } else { int r = GridTable.Rows.Count; int m_pageNumber = r / nNewItemIndex; dg.PageIndex = m_pageNumber; r = (r - nNewItemIndex * m_pageNumber); dg.EditIndex = r; } GridTable.Rows.Add(NewRow); GridTable.AcceptChanges(); dg.DataSource = GridTable; dg.DataBind(); k_blnIsAddingNew = true; } catch (Exception exp) { DivError.Visible = true; _LblError.Text = exp.Message; } }
public static bool dgRowDeleting(int _OpCode, string SpName, string _RecFieldID, ref GridView dg, ref GridViewDeleteEventArgs e, ref HtmlGenericControl DivError, ref Label _LblError) { bool _isretval = false; try { string g_strErrorMessage = ""; if (GeneralBL.isEmptyorNull(dg.DataKeys[e.RowIndex].Value) != "") { GeneralBL.Delete(_OpCode, SpName, _RecFieldID, Convert.ToInt32(dg.DataKeys[e.RowIndex].Value), ref g_strErrorMessage, ""); if (g_strErrorMessage.Length > 0) { DivError.Visible = true; _LblError.Text = g_strErrorMessage.Replace("Error : ", ""); } else { _isretval = true; } } else { DivError.Visible = true; _LblError.Text = "No Record Found to delete."; } } catch (Exception exp) { DivError.Visible = true; _LblError.Text = exp.Message; } return(_isretval); }
public static bool dgRowDeleting(int _OpCode, string SpName, string _RecFieldID, string _RecFieldValue, ref HtmlGenericControl DivError, ref Label _LblError) { bool _isretval = false; try { string g_strErrorMessage = ""; GeneralBL.Delete(_OpCode, SpName, _RecFieldID, _RecFieldValue, ref g_strErrorMessage, ""); if (g_strErrorMessage.Length > 0) { DivError.Visible = true; _LblError.Text = g_strErrorMessage.Replace("Error : ", ""); } else { _isretval = true; } } catch (Exception exp) { DivError.Visible = true; _LblError.Text = exp.Message; } return(_isretval); }
protected void GetDataSourceInvoices() { var lstRoles = (List <Roles>)Session["CCFNRoles"]; var rolesCSV = ""; lstRoles.ForEach(rol => rolesCSV += (rol.Name + ", ")); rolesCSV = rolesCSV.TrimEnd(',', ' '); RadGrid1.DataSource = GeneralBL.GetLog(txtRFC.Text, txtNombre.Text, txtFolio.Text, cmbActionId.SelectedValue, dteDesde.SelectedDate, dteHasta.SelectedDate); }
protected void GetDataSourceInvoices() { var lstRoles = (List <Roles>)Session["CCFNRoles"]; var rolesCSV = ""; lstRoles.ForEach(rol => rolesCSV += (rol.Name + ", ")); rolesCSV = rolesCSV.TrimEnd(',', ' '); RadGrid1.DataSource = GeneralBL.GetInvoices(rolesCSV.Contains("ADMINISTRADOR"), ((Users)Session["CCFNUser"]).RFC, txtSerie.Text, txtFolio.Text, dteDesde.SelectedDate, dteHasta.SelectedDate, ((Users)Session["CCFNUser"]).UserId, txtSucursal.Text, txtCodigoCliente.Text, txtRFC.Text); }
public static string FillDataTable() { try { DataSet ds = GeneralBL.FillDataSet(40, "SP_RoomType", ref strErrorMessge, strErrorType); return(ds.GetXml()); } catch (Exception exp) { return(strErrorMessge = exp.Message); } }
public static string LoadRawItems(string Value) { try { strErrorType = strErrorType = ""; DataSet ds = GeneralBL.FillDataSet(4, "SPR_RawItems", ref strErrorType, strErrorType); return(ds.GetXml()); } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string LoadItemscategory() { try { strErrorType = strErrorType = ""; DataSet ds = GeneralBL.FillDataSet(5, "SPR_ItemsCategory", ref strErrorType, strErrorType); return(ds.GetXml()); } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string EditSuppilers(int SuppliersID) { try { strErrorMessage = strErrorType = ""; DataSet ds = GeneralBL.FillDataSet(4, SuppliersID, "@SuppliersID", "SPR_Suppliers", ref strErrorMessage, strErrorType); return(ds.GetXml()); } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string EditCustomer(int CustomerID) { try { strErrorMessage = strErrorType = ""; DataSet ds = GeneralBL.FillDataSet(5, CustomerID, "@CustomerID", "SPR_Customers", ref strErrorMessage, strErrorType); return(ds.GetXml()); } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
protected void chkRecibos_Click(object sender, EventArgs e) { if ((bool)chkRecibos.Checked) { var lstRoles = (List <Roles>)Session["CCFNRoles"]; var rolesCSV = ""; lstRoles.ForEach(rol => rolesCSV += (rol.Name + ", ")); rolesCSV = rolesCSV.TrimEnd(',', ' '); RadGrid1.DataSource = GeneralBL.GetInvoicesRecibos(rolesCSV.Contains("ADMINISTRADOR"), ((Users)Session["CCFNUser"]).RFC, txtSerie.Text, txtFolio.Text, dteDesde.SelectedDate, dteHasta.SelectedDate, ((Users)Session["CCFNUser"]).UserId, txtSucursal.Text, txtCodigoCliente.Text, txtRFC.Text); } else { GetDataSourceInvoices(); } RadGrid1.DataBind(); //Response.Write("<script language='javascript'>alert('"+ chkRecibos.Checked + "');</script>"); }
public static string insertItems(string Items) { try { GeneralBL.AddUpdate(200, "@Items", Items, "SPR_RawItems", ref strErrorMessage); if (strErrorMessage.Length < 1) { return(strErrorMessage); } else { return(strErrorMessage); } } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string insertCategory(string CategoryName) { try { GeneralBL.AddUpdate(1, "@CategoryName", CategoryName, "SPR_ItemsCategory", ref strErrorMessage); if (strErrorMessage.Length < 1) { return(strErrorMessage); } else { return(strErrorMessage); } } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string InsertCustomer(string Customer, string Email, string CellNo, string Cnic, string Address) { try { GeneralBL.AddUpdate(1, "@CustomerName", Customer, "@Email", Email, "@CellPhone", CellNo, "@CNIC", Cnic, "@Address", Address, "SPR_Customers", ref strErrorMessage); if (strErrorMessage.Length < 1) { return(strErrorMessage); } else { return(strErrorMessage); } } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string LoadCustomer(string Search) { try { strErrorType = strErrorType = ""; //SqlParameter[] paramstostore = new SqlParameter[2]; //paramstostore[0] = new SqlParameter("@OpCode", SqlDbType.Int); //paramstostore[0].Value = 5; //paramstostore[1] = new SqlParameter("@Amount", SqlDbType.VarChar); //paramstostore[1].Value = Search; DataSet ds = GeneralBL.FillDataSet(8, Search, "@CustomerName", "SPR_Customers", ref strErrorType, strErrorType); return(ds.GetXml()); } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string insertSuppliers(string Suppliers, string Address, string Contact, string Status) { try { GeneralBL.AddUpdate(1, "@Suppliers", Suppliers, "@Address", Address, "@Contact", Contact, "@Status", Status, "SPR_Suppliers", ref strErrorMessage); if (strErrorMessage.Length < 1) { return(strErrorMessage); } else { return(strErrorMessage); } } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
protected void Page_Load(object sender, EventArgs e) { try { var invoiceId = int.Parse(Request["FacturaId"].ToString()); var invoice = GeneralBL.GetInvoice(invoiceId); var lstParameters = ParameterBL.GetParameters(); var filesPath = lstParameters.Where(p => p.Name.Equals("FilesPath")).FirstOrDefault().Value; if (Request["FileType"].ToString() == "PDF") { GeneralBL.Log((int)Constants.Actions.DESCARGA_PDF, ((Users)Session["CCFNUser"]).UserId, "", invoiceId); var fileInfo = new FileInfo(filesPath + "\\" + invoice.PDF); Response.Clear(); Response.ClearHeaders(); Response.ClearContent(); Response.AddHeader("Content-Disposition", "attachment; filename=" + invoice.PDF); Response.AddHeader("Content-Length", fileInfo.Length.ToString()); Response.ContentType = "text/plain"; Response.Flush(); Response.TransmitFile(filesPath + "\\" + invoice.PDF); Response.End(); } else if (Request["FileType"].ToString() == "XML") { GeneralBL.Log((int)Constants.Actions.DESCARGA_XML, ((Users)Session["CCFNUser"]).UserId, "", invoiceId); var fileInfo = new FileInfo(filesPath + "\\" + invoice.XML); Response.Clear(); Response.ClearHeaders(); Response.ClearContent(); Response.AddHeader("Content-Disposition", "attachment; filename=" + invoice.XML); Response.AddHeader("Content-Length", fileInfo.Length.ToString()); Response.ContentType = "text/plain"; Response.Flush(); Response.TransmitFile(filesPath + "\\" + invoice.XML); Response.End(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public static string CheckStatus(string SuppliersID) { try { strErrorMessage = strErrorType = ""; GeneralBL.AddUpdate(100, "@SuppliersID", SuppliersID, "SPR_Suppliers", ref strErrorMessage); if (strErrorMessage.Length < 1) { return(strErrorMessage); } else { return(strErrorMessage); } } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string DeleteSuppliers(string SuppliersID) { try { strErrorMessage = strErrorType = ""; GeneralBL.Delete(3, "SPR_Suppliers", "@SuppliersID", SuppliersID, ref strErrorMessage, strErrorType); if (strErrorMessage.Length < 1) { return(strErrorMessage); } else { return(strErrorMessage); } } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string DeleteCustomer(string CustomerID) { try { strErrorMessage = strErrorType = ""; GeneralBL.Delete(3, "SPR_Customers", "@CustomerID", CustomerID, ref strErrorMessage, strErrorType); if (strErrorMessage.Length < 1) { return(strErrorMessage); } else { return(strErrorMessage); } } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string UpdateSuppilers(string SuppliersID, string Suppliers, string Address, string Contact, string Status) { try { strErrorMessage = strErrorType = ""; GeneralBL.AddUpdate(2, "@SuppliersID", SuppliersID, "@Suppliers", Suppliers, "@Address", Address, "@Contact", Contact, "@Status", Status, "SPR_Suppliers", ref strErrorMessage); if (strErrorMessage.Length < 1) { return(strErrorMessage); } else { return(strErrorMessage); } } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string DeleteAllCustomer(string checkAll) { try { strErrorMessage = strErrorType = ""; GeneralBL.Delete(13, "SPR_Customers", "@CustomerDel", checkAll, ref strErrorMessage, strErrorType); if (strErrorMessage.Length < 1) { return(strErrorMessage); } else { return(strErrorMessage); } } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string DeleteCategory(string CategoryID) { try { strErrorMessage = strErrorType = ""; GeneralBL.Delete(3, "SPR_ItemsCategory", "@CategoryID", CategoryID, ref strErrorMessage, strErrorType); if (strErrorMessage.Length < 1) { return(strErrorMessage); } else { return(strErrorMessage); } } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
public static string UpdateCategory(string CategoryID, string CategoryName) { try { strErrorMessage = strErrorType = ""; GeneralBL.AddUpdate(2, "@CategoryID", CategoryID, "@CategoryName", CategoryName, "SPR_ItemsCategory", ref strErrorMessage); if (strErrorMessage.Length < 1) { return(strErrorMessage); } else { return(strErrorMessage); } } catch (Exception exp) { return(strErrorMessage = exp.Message); } }
// Fill Grid New Version public static void FillDirectGrid(int OpCode, string _spName, ref HtmlGenericControl DivError, ref Label _LblError, ref GridView dg, ref int k_intTotalRowsNumbers, int EditCol, int delcol) { try { string g_strErrorMessage = ""; DivError.Visible = false; _LblError.Text = ""; dg.DataSource = null; dg.DataBind(); DataTable dt = GeneralBL.FillDataGrid(OpCode, _spName, ref g_strErrorMessage, "2"); if (g_strErrorMessage.Length < 1) { if (GeneralBL.isdtEmptyNull(dt) == true) { if (EditCol != -1) { dg.Columns[EditCol].Visible = true; } if (delcol != -1) { dg.Columns[delcol].Visible = true; } k_intTotalRowsNumbers = dt.Rows.Count; } dg.DataSource = dt; dg.DataBind(); } else { DivError.Visible = true; _LblError.Text = g_strErrorMessage.Replace("Error : ", ""); } } catch (Exception exp) { DivError.Visible = true; _LblError.Text = exp.Message; } }
protected void Page_Load(object sender, EventArgs e) { try { var lstFacturas = Request["Facturas"]; var files = GeneralBL.GetInvoiceFiles(lstFacturas, ((Users)Session["CCFNUser"]).UserId); if (files.Rows.Count > 0) { var lstParameters = ParameterBL.GetParameters(); var filesPath = lstParameters.Where(p => p.Name.Equals("FilesPath")).FirstOrDefault().Value; var memStream = new MemoryStream(); using (var archive = new ZipArchive(memStream, ZipArchiveMode.Create, true, null)) { foreach (DataRow row in files.Rows) { if (File.Exists(filesPath + row["RFC"] + "\\" + row["PDF"])) { using (var entry = archive.CreateEntry(row["PDF"].ToString())) { using (var stream = new MemoryStream(File.ReadAllBytes(filesPath + row["RFC"] + "\\" + row["PDF"]))) { var writer = new BinaryWriter(entry.Open()); writer.Write(stream.ToArray()); writer.Flush(); } } } if (File.Exists(filesPath + row["RFC"] + "\\" + row["XML"])) { using (var entry = archive.CreateEntry(row["XML"].ToString())) { using (var stream = new MemoryStream(File.ReadAllBytes(filesPath + row["RFC"] + "\\" + row["XML"]))) { var writer = new BinaryWriter(entry.Open()); writer.Write(stream.ToArray()); writer.Flush(); } } } } } memStream.Seek(0, SeekOrigin.Begin); if (memStream != null && memStream.Length > 0) { Response.Clear(); Response.AddHeader("content-disposition", "attachment; filename=facturas.zip"); Response.ContentType = "application/zip"; Response.BinaryWrite(memStream.ToArray()); Response.End(); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } }