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);
}
}
