private void DeleteAttachment() { if (!mboDeleteTransactionItemAttachment) { MessageBox.Show("Sorry you are not allowed to delete posted attachments, please consult your system administrator.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2); } else { if (dgvItems.SelectedRows.Count == 1) { if (MessageBox.Show("Are you sure you want to delete the attachment.", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes) { foreach (DataGridViewRow dr in dgvItems.SelectedRows) { string strOrigFileName = dr.Cells["OrigFileName"].Value.ToString(); Int64 iTransactionItemAttachmentsID = Int64.Parse(dr.Cells["TransactionItemAttachmentsID"].Value.ToString()); Data.SalesTransactionItemAttachments clsSalesTransactionItemAttachments = new Data.SalesTransactionItemAttachments(); clsSalesTransactionItemAttachments.Delete(iTransactionItemAttachmentsID.ToString()); clsSalesTransactionItemAttachments.CommitAndDispose(); LoadData(); MessageBox.Show("The attachment: " + strOrigFileName + " has been deleted.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } }
private void DeleteAttachment() { if (!mboDeleteTransactionItemAttachment) { MessageBox.Show("Sorry you are not allowed to delete posted attachments, please consult your system administrator.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2); } else { if (dgvItems.SelectedRows.Count == 1) { if (MessageBox.Show("Are you sure you want to delete the attachment.", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes) { foreach (DataGridViewRow dr in dgvItems.SelectedRows) { string strOrigFileName = dr.Cells["OrigFileName"].Value.ToString(); Int64 iTransactionItemAttachmentsID = Int64.Parse(dr.Cells["TransactionItemAttachmentsID"].Value.ToString()); Data.SalesTransactionItemAttachments clsSalesTransactionItemAttachments = new Data.SalesTransactionItemAttachments(); clsSalesTransactionItemAttachments.Delete(iTransactionItemAttachmentsID.ToString()); clsSalesTransactionItemAttachments.CommitAndDispose(); LoadData(); MessageBox.Show("The attachment: " + strOrigFileName +" has been deleted.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } }
private void AttachFile() { try { OpenFileDialog ofd = new OpenFileDialog(); ofd.Multiselect = false; if (ofd.ShowDialog() == DialogResult.OK) { string fileName = System.IO.Path.GetFileName(ofd.FileName); string filePath = System.IO.Path.GetFullPath(ofd.FileName); string strNewFileName = SalesTransactionItemDetails.TransactionID.ToString() + "_" + SalesTransactionItemDetails.TransactionItemsID + "_" + fileName; Data.SalesTransactionItemAttachmentDetails clsDetails = new Data.SalesTransactionItemAttachmentDetails(); clsDetails.TransactionItemAttachmentsID = 0; clsDetails.TransactionItemsID = SalesTransactionItemDetails.TransactionItemsID; clsDetails.TransactionID = SalesTransactionItemDetails.TransactionID; clsDetails.OrigFileName = fileName; clsDetails.FileName = strNewFileName; clsDetails.UploadedByName = CashierName; clsDetails.CreatedOn = DateTime.Now; clsDetails.LastModified = clsDetails.CreatedOn; Data.SalesTransactionItemAttachments clsSalesTransactionItemAttachments = new Data.SalesTransactionItemAttachments(); clsSalesTransactionItemAttachments.Insert(clsDetails); clsSalesTransactionItemAttachments.CommitAndDispose(); try { string strServer = "127.0.0.1"; if (System.Configuration.ConfigurationManager.AppSettings["VersionFTPIPAddress"] != null) { try { strServer = System.Configuration.ConfigurationManager.AppSettings["VersionFTPIPAddress"].ToString(); } catch { } } int intPort = 21; if (System.Configuration.ConfigurationManager.AppSettings["VersionFTPPort"] != null) { try { intPort = int.Parse(System.Configuration.ConfigurationManager.AppSettings["VersionFTPPort"]); } catch { } } string strUserName = "******"; string strPassword = "******"; string strFTPDirectory = "attachment"; string destinationDirectory = Application.StartupPath; //string strConstantRemarks = "Please contact your system administrator immediately."; FtpClient ftpClient = new FtpClient(); ftpClient.Host = strServer; ftpClient.Port = intPort; ftpClient.Credentials = new NetworkCredential(strUserName, strPassword); IEnumerable<FtpListItem> lstFtpListItem = ftpClient.GetListing(strFTPDirectory, FtpListOption.Modify | FtpListOption.Size); Event clsEvent = new Event(); bool bolIsFileExist = false; clsEvent.AddEventLn("Checking file if already exist...", true); try { foreach (FtpListItem ftpListItem in lstFtpListItem) { if (ftpListItem.Name.ToUpper() == Path.GetFileName(strNewFileName).ToUpper()) { bolIsFileExist = true; break; } } } catch (Exception excheck) { clsEvent.AddEventLn("checking error..." + excheck.Message, true); } if (bolIsFileExist) { clsEvent.AddEventLn("exist...", true); clsEvent.AddEventLn("uploading now...", true); } else { clsEvent.AddEventLn("does not exist...", true); clsEvent.AddEventLn("uploading now...", true); } using (var fileStream = File.OpenRead(filePath)) using (var ftpStream = ftpClient.OpenWrite(string.Format("{0}/{1}", strFTPDirectory, Path.GetFileName(strNewFileName)))) { var buffer = new byte[8 * 1024]; int count; while ((count = fileStream.Read(buffer, 0, buffer.Length)) > 0) { ftpStream.Write(buffer, 0, count); } clsEvent.AddEventLn("Upload Complete: TotalBytes: " + buffer.ToString(), true); } ftpClient.Disconnect(); ftpClient.Dispose(); ftpClient = null; } catch { } LoadData(); MessageBox.Show("The attachment: " + fileName + " has been uploaded.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void LoadData() { try { //DateTime dteRetValue = DateTime.MinValue; //Data.CreditPaymentCashDetails clsCreditPaymentCashDetails = new Data.CreditPaymentCashDetails(); //clsCreditPaymentCashDetails.BranchDetails = new Data.BranchDetails(); //clsCreditPaymentCashDetails.TerminalNo = ""; //clsCreditPaymentCashDetails.PaymentDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : DateTime.Now.AddDays(-60); //clsCreditPaymentCashDetails.PaymentDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : DateTime.Now; //clsCreditPaymentCashDetails.CreditType = CreditType.Both; //clsCreditPaymentCashDetails.CreditCardTypeID = 0; //clsCreditPaymentCashDetails.ContactID = mclsCustomerDetails.ContactID; Data.SalesTransactionItemAttachments clsSalesTransactionItemAttachments = new Data.SalesTransactionItemAttachments(); System.Data.DataTable dt = clsSalesTransactionItemAttachments.ListAsDataTable(new Data.SalesTransactionItemAttachmentDetails() { TransactionItemsID = SalesTransactionItemDetails.TransactionItemsID }); clsSalesTransactionItemAttachments.CommitAndDispose(); //System.Data.DataView dv = dt.DefaultView; //dv.Sort = "TransactionDate"; //dt = dv.ToTable(); dgvItems.MultiSelect = false; dgvItems.AutoGenerateColumns = true; dgvItems.AutoSize = false; dgvItems.DataSource = dt.TableName; dgvItems.DataSource = dt; foreach (DataGridViewColumn dc in dgvItems.Columns) { dc.Visible = false; } dgvItems.Columns["OrigFileName"].Visible = true; dgvItems.Columns["UploadedByName"].Visible = true; dgvItems.Columns["LastUpdatedByName"].Visible = true; dgvItems.Columns["CreatedOn"].Visible = true; dgvItems.Columns["OrigFileName"].Width = dgvItems.Width - 570; dgvItems.Columns["UploadedByName"].Width = 200; dgvItems.Columns["LastUpdatedByName"].Width = 200; dgvItems.Columns["CreatedOn"].Width = 150; dgvItems.Columns["OrigFileName"].HeaderCell.Style = new DataGridViewCellStyle() { Alignment = DataGridViewContentAlignment.MiddleLeft }; dgvItems.Columns["UploadedByName"].HeaderCell.Style = new DataGridViewCellStyle() { Alignment = DataGridViewContentAlignment.MiddleLeft }; dgvItems.Columns["LastUpdatedByName"].HeaderCell.Style = new DataGridViewCellStyle() { Alignment = DataGridViewContentAlignment.MiddleLeft }; dgvItems.Columns["CreatedOn"].HeaderCell.Style = new DataGridViewCellStyle() { Alignment = DataGridViewContentAlignment.MiddleCenter }; dgvItems.Columns["OrigFileName"].HeaderText = "File Name"; dgvItems.Columns["UploadedByName"].HeaderText = "Uploaded By"; dgvItems.Columns["LastUpdatedByName"].HeaderText = "Last Updated By"; dgvItems.Columns["CreatedOn"].HeaderText = "Upload Date"; dgvItems.Columns["CreatedOn"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvItems.Columns["CreatedOn"].DefaultCellStyle.Format = "yyyy-MMM-dd hh:mm tt"; dgvItems.ReadOnly = true; dgvItems.Select(); grpBox1.Text = "Attachments of: " + SalesTransactionItemDetails.ProductCode + "."; } catch (Exception ex) { MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error); } }
private void AttachFile() { try { OpenFileDialog ofd = new OpenFileDialog(); ofd.Multiselect = false; if (ofd.ShowDialog() == DialogResult.OK) { string fileName = System.IO.Path.GetFileName(ofd.FileName); string filePath = System.IO.Path.GetFullPath(ofd.FileName); string strNewFileName = SalesTransactionItemDetails.TransactionID.ToString() + "_" + SalesTransactionItemDetails.TransactionItemsID + "_" + fileName; Data.SalesTransactionItemAttachmentDetails clsDetails = new Data.SalesTransactionItemAttachmentDetails(); clsDetails.TransactionItemAttachmentsID = 0; clsDetails.TransactionItemsID = SalesTransactionItemDetails.TransactionItemsID; clsDetails.TransactionID = SalesTransactionItemDetails.TransactionID; clsDetails.OrigFileName = fileName; clsDetails.FileName = strNewFileName; clsDetails.UploadedByName = CashierName; clsDetails.CreatedOn = DateTime.Now; clsDetails.LastModified = clsDetails.CreatedOn; Data.SalesTransactionItemAttachments clsSalesTransactionItemAttachments = new Data.SalesTransactionItemAttachments(); clsSalesTransactionItemAttachments.Insert(clsDetails); clsSalesTransactionItemAttachments.CommitAndDispose(); try { string strServer = "127.0.0.1"; if (System.Configuration.ConfigurationManager.AppSettings["VersionFTPIPAddress"] != null) { try { strServer = System.Configuration.ConfigurationManager.AppSettings["VersionFTPIPAddress"].ToString(); } catch { } } int intPort = 21; if (System.Configuration.ConfigurationManager.AppSettings["VersionFTPPort"] != null) { try { intPort = int.Parse(System.Configuration.ConfigurationManager.AppSettings["VersionFTPPort"]); } catch { } } string strUserName = "******"; string strPassword = "******"; string strFTPDirectory = "attachment"; string destinationDirectory = Application.StartupPath; //string strConstantRemarks = "Please contact your system administrator immediately."; FtpClient ftpClient = new FtpClient(); ftpClient.Host = strServer; ftpClient.Port = intPort; ftpClient.Credentials = new NetworkCredential(strUserName, strPassword); IEnumerable <FtpListItem> lstFtpListItem = ftpClient.GetListing(strFTPDirectory, FtpListOption.Modify | FtpListOption.Size); Event clsEvent = new Event(); bool bolIsFileExist = false; clsEvent.AddEventLn("Checking file if already exist...", true); try { foreach (FtpListItem ftpListItem in lstFtpListItem) { if (ftpListItem.Name.ToUpper() == Path.GetFileName(strNewFileName).ToUpper()) { bolIsFileExist = true; break; } } } catch (Exception excheck) { clsEvent.AddEventLn("checking error..." + excheck.Message, true); } if (bolIsFileExist) { clsEvent.AddEventLn("exist...", true); clsEvent.AddEventLn("uploading now...", true); } else { clsEvent.AddEventLn("does not exist...", true); clsEvent.AddEventLn("uploading now...", true); } using (var fileStream = File.OpenRead(filePath)) using (var ftpStream = ftpClient.OpenWrite(string.Format("{0}/{1}", strFTPDirectory, Path.GetFileName(strNewFileName)))) { var buffer = new byte[8 * 1024]; int count; while ((count = fileStream.Read(buffer, 0, buffer.Length)) > 0) { ftpStream.Write(buffer, 0, count); } clsEvent.AddEventLn("Upload Complete: TotalBytes: " + buffer.ToString(), true); } ftpClient.Disconnect(); ftpClient.Dispose(); ftpClient = null; } catch { } LoadData(); MessageBox.Show("The attachment: " + fileName + " has been uploaded.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void LoadData() { try { //DateTime dteRetValue = DateTime.MinValue; //Data.CreditPaymentCashDetails clsCreditPaymentCashDetails = new Data.CreditPaymentCashDetails(); //clsCreditPaymentCashDetails.BranchDetails = new Data.BranchDetails(); //clsCreditPaymentCashDetails.TerminalNo = ""; //clsCreditPaymentCashDetails.PaymentDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : DateTime.Now.AddDays(-60); //clsCreditPaymentCashDetails.PaymentDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : DateTime.Now; //clsCreditPaymentCashDetails.CreditType = CreditType.Both; //clsCreditPaymentCashDetails.CreditCardTypeID = 0; //clsCreditPaymentCashDetails.ContactID = mclsCustomerDetails.ContactID; Data.SalesTransactionItemAttachments clsSalesTransactionItemAttachments = new Data.SalesTransactionItemAttachments(); System.Data.DataTable dt = clsSalesTransactionItemAttachments.ListAsDataTable(new Data.SalesTransactionItemAttachmentDetails() { TransactionItemsID = SalesTransactionItemDetails.TransactionItemsID }); clsSalesTransactionItemAttachments.CommitAndDispose(); //System.Data.DataView dv = dt.DefaultView; //dv.Sort = "TransactionDate"; //dt = dv.ToTable(); dgvItems.MultiSelect = false; dgvItems.AutoGenerateColumns = true; dgvItems.AutoSize = false; dgvItems.DataSource = dt.TableName; dgvItems.DataSource = dt; foreach (DataGridViewColumn dc in dgvItems.Columns) { dc.Visible = false; } dgvItems.Columns["OrigFileName"].Visible = true; dgvItems.Columns["UploadedByName"].Visible = true; dgvItems.Columns["LastUpdatedByName"].Visible = true; dgvItems.Columns["CreatedOn"].Visible = true; dgvItems.Columns["OrigFileName"].Width = dgvItems.Width - 570; dgvItems.Columns["UploadedByName"].Width = 200; dgvItems.Columns["LastUpdatedByName"].Width = 200; dgvItems.Columns["CreatedOn"].Width = 150; dgvItems.Columns["OrigFileName"].HeaderCell.Style = new DataGridViewCellStyle() { Alignment = DataGridViewContentAlignment.MiddleLeft }; dgvItems.Columns["UploadedByName"].HeaderCell.Style = new DataGridViewCellStyle() { Alignment = DataGridViewContentAlignment.MiddleLeft }; dgvItems.Columns["LastUpdatedByName"].HeaderCell.Style = new DataGridViewCellStyle() { Alignment = DataGridViewContentAlignment.MiddleLeft }; dgvItems.Columns["CreatedOn"].HeaderCell.Style = new DataGridViewCellStyle() { Alignment = DataGridViewContentAlignment.MiddleCenter }; dgvItems.Columns["OrigFileName"].HeaderText = "File Name"; dgvItems.Columns["UploadedByName"].HeaderText = "Uploaded By"; dgvItems.Columns["LastUpdatedByName"].HeaderText = "Last Updated By"; dgvItems.Columns["CreatedOn"].HeaderText = "Upload Date"; dgvItems.Columns["CreatedOn"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvItems.Columns["CreatedOn"].DefaultCellStyle.Format = "yyyy-MMM-dd hh:mm tt"; dgvItems.ReadOnly = true; dgvItems.Select(); grpBox1.Text = "Attachments of: " + SalesTransactionItemDetails.ProductCode + "."; } catch (Exception ex) { MessageBox.Show(ex.Message, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error); } }