protected void btnExcel_Click(object sender, EventArgs e)
{
if (Session["ViewAdjustments-Where"] != null)
{
string where = Session["ViewAdjustments-Where"].ToString();
if (!string.IsNullOrEmpty(where))
{
int maximumRows = int.MaxValue;
int startRowIndex = 0;
List <TransactionLines> transactionList = TransactionLines.GetPagedAdjustmentsByDateInterval(ref maximumRows, ref startRowIndex, where);
gvExport.DataSource = transactionList;
gvExport.DataBind();
gvExport.Visible = true;
}
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=ViewAdjustments.xls");
Response.Charset = "";
// If you want the option to open the Excel file without saving then
// comment out the line below
// Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/ms-excel";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
gvExport.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
gvExport.Visible = false;
}
}
protected void btnRemove_Click(object sender, EventArgs e)
{
try
{
int id = -1;
string _id = Request.QueryString["id"].ToString();
int.TryParse(_id, out id);
int userId = CurrentEnvironment.LoggedUser.Id;
int i = TransactionLines.Delete(id);
if (i > 0)
{
lblSuccess.Visible = true;
lblWarning.Visible = false;
lblError.Visible = false;
gvTransactionLines.DataBind();
ClearControls(this);
}
else
{
lblSuccess.Visible = false;
lblWarning.Visible = true;
lblError.Visible = false;
}
}
catch (Exception ex)
{
lblSuccess.Visible = false;
lblWarning.Visible = false;
lblError.Visible = true;
}
}
protected bool tlExists(int transactionId, int lotid)
{
if (TransactionLines.GetTransactionLinesByTransactionIdLotId(transactionId, lotid) != null)
{
lblSuccess.Visible = false;
lblWarning.Visible = true;
lblError.Visible = false;
return(true);
}
return(false);
}
private void btnDelete_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
if (LinesView.FocusedRowHandle >= 0)
{
TransactionLines l = lines.Get(long.Parse(LinesView.GetRowCellValue(LinesView.FocusedRowHandle, LinesView.Columns[0]).ToString()));
lines.Delete(l);
LinesView.DeleteRow(LinesView.FocusedRowHandle);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void ExecuteSaveItemViewCommand(object obj)
{
try
{
CurrentItem.CategoryId = SelectedCategory.Id;
CurrentItem.UnitOfMeasureId = SelectedUnitOfMeasure.Id;
var stat = _itemService.InsertOrUpdate(CurrentItem);
if (stat == string.Empty)
{
if (SelectedTransaction != null)
{
//if (TransactionQuantity == null || (TransactionQuantity!=null && TransactionQuantity<=0))
//{
// MessageBox.Show("Quantity Can't Be Empty and Less than or equalzero");
// return;
//}
var selectedTransactionLine = new TransactionLineDTO()
{
TransactionId = SelectedTransaction.Id
};
if (SelectedTransaction.Id == 0)
{
selectedTransactionLine.Transaction = SelectedTransaction;
}
selectedTransactionLine.ItemId = CurrentItem.Id;
selectedTransactionLine.Unit = (decimal)TransactionLine.UnitQuantity;// TransactionQuantity;
selectedTransactionLine.EachPrice = 0;
stat = new TransactionService(true).InsertOrUpdateChild(selectedTransactionLine);
if (string.IsNullOrEmpty(stat))
{
selectedTransactionLine.Item = new ItemDTO()
{
ItemCode = CurrentItem.ItemCode,
Id = CurrentItem.Id
};
TransactionLines.Add(selectedTransactionLine);
}
}
#region Change Item Qty after adding a new PI
//if (QuantityEditVisibility != null && QuantityEditVisibility == "Visible" &&
// _itemPreviousQty != CurrentQuantity && SelectedWarehouse != null && SelectedWarehouse.Id != -1)
//{
// var itemQty = new ItemQuantityDTO
// {
// WarehouseId = SelectedWarehouse.Id,
// ItemId = CurrentItem.Id,
// QuantityOnHand = CurrentQuantity
// };
// var stat2 = _itemQuantityService.InsertOrUpdate(itemQty, true);
// if (stat2 == string.Empty)
// CloseWindow(obj);
// else
// MessageBox.Show(
// "item detail saved successfully but updating quantity failed, try again..." +
// Environment.NewLine + stat2, "save error", MessageBoxButton.OK, MessageBoxImage.Error);
//}
//else
//{
// CloseWindow(obj);
//}
#endregion
CurrentItem = GetNewCurrentItem();
TransactionLine = new TransactionLineModel();
ItemsListVisibility = "Collapsed";
_itemPreviousQty = 0;
}
else
{
MessageBox.Show("Got Problem while saving item, try again..." + Environment.NewLine + stat, "save error", MessageBoxButton.OK,
MessageBoxImage.Error);
}
}
catch (Exception exception)
{
MessageBox.Show("Problem saving Item..." +
Environment.NewLine + exception.Message +
Environment.NewLine + exception.InnerException);
}
}
public LocalReport GetDelivaryReport(
String Receipt)
{
string receipt = Receipt;
int type = 2;
int entryStatus = 0;
int transactionStatus = 0;
int defaultAddressType = 0;
Transaction TransactionHeader = new Transaction();
TransactionCustomer TransactionCustomer = new TransactionCustomer();
TransactionLines TransactionLines = new TransactionLines(null);
using (var db = new DeliveryDbContext(builder.ConnectionString))
{
var transaction = from tra_h in db.RBOTRANSACTIONTABLE
join sto in db.RBOSTORETABLE on tra_h.STORE equals sto.STOREID
where tra_h.RECEIPTID == receipt &&
tra_h.TYPE == type &&
tra_h.ENTRYSTATUS == entryStatus
select new Transaction()
{
ReceiptID = tra_h.RECEIPTID,
StoreID = sto.STOREID,
Name = sto.NAME,
TransDate = tra_h.TRANSDATE ?? DateTime.MinValue,
NetAmount = tra_h.NETAMOUNT ?? 0
};
// LINENUM changed to LINENUM = (decimal)tra_i.LINEID in line 195 colu 156 by rafeeq
var transactionLine = from tra_h in db.RBOTRANSACTIONTABLE
join tra_l in db.RBOTRANSACTIONSALESTRANS
on tra_h.TRANSACTIONID equals tra_l.TRANSACTIONID
join tra_i in db.RBOTRANSACTIONINFOCODETRANS
on
new { tra_l.TRANSACTIONID, tra_l.LINENUM, INFOCODEID = Program.isDelevary } equals new { tra_i.TRANSACTIONID, LINENUM = (decimal)tra_i.LINEID, tra_i.INFOCODEID } into info_d
from info in info_d.DefaultIfEmpty()
join info_sub in db.RBOINFORMATIONSUBCODETABLE on
info.INFORMATION equals info_sub.SUBCODEID into info_sub_d
from info_s in info_sub_d.DefaultIfEmpty()
where tra_h.RECEIPTID == receipt &&
tra_h.TYPE == type &&
tra_h.ENTRYSTATUS == entryStatus &&
tra_l.TRANSACTIONSTATUS == transactionStatus
select new TransactionLine()
{
ItemId = tra_l.ITEMID,
Description = tra_l.DESCRIPTION,
Qty = (tra_l.QTY ?? 0) * -1,
TaxInckInPrice = tra_l.TAXINCLINPRICE ?? 0,
Comment = tra_l.COMMENT,
ExtraInfo = string.IsNullOrEmpty(info_s.DESCRIPTION) ? "NON DELIVERABLE" : info_s.DESCRIPTION
};
var transactionCustomer = from tra_h in db.RBOTRANSACTIONTABLE
join tra_i in db.RBOTRANSACTIONINFOCODETRANS
on
new { tra_h.TRANSACTIONID, INFOCODEID = Program.customerInfoCode } equals new { tra_i.TRANSACTIONID, tra_i.INFOCODEID } into info_d
from info in info_d.DefaultIfEmpty()
join cust in db.CUSTTABLE on new { CUSTACCOUNT = string.IsNullOrEmpty(info.INFORMATION) ? tra_h.CUSTACCOUNT : info.INFORMATION } equals
new { CUSTACCOUNT = cust.ACCOUNTNUM }
join address in db.CUSTOMERADDRESS on
new { cust.ACCOUNTNUM, ADDRESSTYPE = defaultAddressType } equals new { address.ACCOUNTNUM, address.ADDRESSTYPE }
where tra_h.RECEIPTID == receipt &&
tra_h.TYPE == type &&
tra_h.ENTRYSTATUS == entryStatus
select new TransactionCustomer()
{
ReceiptID = tra_h.RECEIPTID,
CustAccount = string.IsNullOrEmpty(info.INFORMATION) ? tra_h.CUSTACCOUNT : info.INFORMATION,
Name = cust.NAME,
Address = cust.ADDRESS,
Phone = cust.PHONE,
Address1 = address.ADDRESS,
Street = address.STREET
};
TransactionHeader = transaction.Count() > 0 ? transaction.ToList()[0] : null;
TransactionLines = transactionLine.Count() > 0 ? new TransactionLines(transactionLine.ToList()) : null;
TransactionCustomer = transactionCustomer.Count() > 0 ? transactionCustomer.ToList()[0] : null;
//this.dataGridViewReceipt.DataSource = transaction.ToList();
//this.dataGridViewTransaction.DataSource = transactionLine.ToList();
//this.dataGridViewCustomer.DataSource = transactionCustomer.ToList();
this.TransactionBindingSource.DataSource = TransactionHeader;
this.TransactionCustomerBindingSource.DataSource = TransactionCustomer;
this.TransactionLinesBindingSource.DataSource = TransactionLines;
//ReportDataSource dataSourceTran = new ReportDataSource("Transaction", transaction.Count() > 0 ? transaction.ToList()[0] : null);
//ReportDataSource dataSourceCust = new ReportDataSource("TrransactionCustomer", transactionCustomer.Count() > 0 ? transactionCustomer.ToList()[0] : null);
//ReportDataSource dataSourceLine = new ReportDataSource("TransactionLines", transactionLine.Count() > 0 ? new TransactionLines(transactionLine.ToList()) : null);
//this.reportViewerDelivary.LocalReport.DataSources.Add(dataSourceTran);
//Sthis.reportViewerDelivary.LocalReport.DataSources.Add(dataSourceCust);
//this.reportViewerDelivary.LocalReport.DataSources.Add(dataSourceLine);
LocalReport.Refresh();
return(LocalReport);
}
}
