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