public string ExportCSVTranscationsReport(ViewTransactionCBE transaction)
{
Int16 IsDataFound = 0;
var filename = "TransactionDetails_" + DateTime.Now.ToString(Constants.dateTimeFormat24HForFileName) + ".csv";
FileInfo file = new FileInfo(Server.MapPath("~/Attachment/ExportFiles/" + filename));
try
{
string strstarttime = Convert.ToDateTime(transaction.StartDate).ToString("dd/MM/yyyy HH:mm:ss");
string strendtime = Convert.ToDateTime(transaction.EndDate).ToString("dd/MM/yyyy HH:mm:ss");
IsDataFound = CSVUtility.CreateCsv(file.FullName, TransactionBLL.TransDeatilsReport(strstarttime, strendtime));
if (IsDataFound == 0)
{
filename = "No Data to Export.";
}
}
catch (Exception ex)
{
HelperClass.LogMessage("Failed Export Transaction Details_ CSV " + ex);
}
string Det = JsonConvert.SerializeObject(filename, Formatting.Indented);
return(Det.Replace("\r", "").Replace("\n", ""));
}
public void DisplayDateRange(DateTime min, DateTime max)
{
UserBLL bll = new UserBLL();
TransactionBLL tll = new TransactionBLL();
List <ReportBO> lst = tll.Read_Report();
string head = String.Format("{0,-15} {1,-10} {2,-10} {3,-10} {4,-10}", "Transaction Type", "User ID", "Holders Name", "Amount", "Date");
WriteLine(head);
for (int i = 0; i < lst.Count; i++)
{
DateTime temp;
CultureInfo provider = CultureInfo.InvariantCulture;
try
{
temp = DateTime.ParseExact(lst[i].Date, "d/MM/yyyy", provider);
}
catch (Exception ex)
{
temp = temp = DateTime.ParseExact(lst[i].Date, "dd/MM/yyyy", provider);
}
if (temp >= min.Date && temp <= max.Date)
{
WriteLine("{0,-15} {1,-10} {2,-10} {3,-10} {4,-10}", lst[i].Type, lst[i].User_Id, lst[i].Name, lst[i].Amount, lst[i].Date);
}
}
}
public void WithDrawCash(UserO usr, ref bool MaxAmount, ref DateTime tomorrow)
{
TransactionBLL tll = new TransactionBLL();
DateTime today = DateTime.UtcNow.Date;
if (today == tomorrow)
{
MaxAmount = false;
}
if (tll.Is24Hours(usr))
{
MaxAmount = false;
}
if (MaxAmount)
{
WriteLine("You cannot withdraw more than 20000 in one day.Please wait for 24 hours.");
return;
}
Console.Clear();
WriteLine("1---Fast Cash");
WriteLine("2---Normal cash");
int num = System.Convert.ToInt32(ReadLine());
if (num == 1)
{
FastCash(usr, ref MaxAmount);
}
else if (num == 2)
{
NormalCash(usr, ref MaxAmount);
}
}
public void DepositCash(UserO usr)
{
WriteLine("Enter the amount to deposit:");
string amo = ReadLine();
int amount;
if (int.TryParse(amo, out amount))
{
amount = System.Convert.ToInt32(amo);
UserBLL bll = new UserBLL();
UserBO obj = new UserBO(bll.SearchByObject(usr));
UserBO Deposit = new UserBO(obj);
Deposit.Starting_balance = Deposit.Starting_balance + amount;
bll.Save_User(Deposit);
WriteLine("Deposit successful.");
DateTime dateTime = DateTime.UtcNow.Date;
string dat = dateTime.ToString("dd/MM/yyyy");
ReportBO repobj = new ReportBO {
Type = "Cash Deposit", User_Id = obj.UsrAccNum, Name = obj.Name, Amount = amount.ToString(), Date = dat
};
TransactionBLL tll = new TransactionBLL();
tll.Save_Transaction(repobj);
WriteLine("Do you wish to print a reciept?(y/n)");
char ans2 = ReadKey().KeyChar;
if (ans2.Equals('y') || ans2.Equals('Y'))
{
bll.Receipt_Deposit(obj, amount);
}
}
else
{
WriteLine("Amount enetered was not in a correct format");
}
}
private void DashboardQueue()
{
try
{
string strstarttime = DateTime.Now.ToString("dd-MMM-yyyy");
string Det = JsonConvert.SerializeObject(TransactionBLL.StackChartData(strstarttime, strstarttime), Newtonsoft.Json.Formatting.Indented);
if (!string.IsNullOrEmpty(Det))
{
#region Send data to MSMQ
Message m = new Message();
m.Formatter = new BinaryMessageFormatter();
m.Body = Det;
m.Recoverable = true;
dashQueue = VaaaN.MLFF.Libraries.CommonLibrary.MSMQ.Queue.Create(VaaaN.MLFF.Libraries.CommonLibrary.MSMQ.Queue.webChartDashboardMessageQueue);
if (dashQueue != null)
{
dashQueue.Purge();
}
dashQueue.Send(m);
#endregion
}
}
catch (Exception ex)
{
LogMessage("Failed to send into Dasboard Queue." + ex.Message);
}
}
private void printTransactionReportbutton_Click(object sender, EventArgs e)
{
TransactionBLL aTransactionBll = new TransactionBLL();
List <TransationReport> aReports = new List <TransationReport>();
aReports = (List <TransationReport>)inventoryTransactionDataGridView.DataSource;
if (aReports == null)
{
MessageBox.Show("No data Available Into GridView");
return;
}
int printlenght = aReports.Count;
PrintDocument doc = new TextDocument(aTransactionBll.PrintTransactionReport(aReports), printlenght);
//ViewReport aReport = new ViewReport();
printReportLogoType = 1;
doc.PrintPage += this.Doc_PrintPage;
doc.DefaultPageSettings.Landscape = true;
PrintDialog dlgSettings = new PrintDialog();
dlgSettings.UseEXDialog = true;
dlgSettings.Document = doc;
if (dlgSettings.ShowDialog() == DialogResult.OK)
{
doc.Print();
}
}
private void LoadData()
{
dt = new DataTable();
// get Data for dt
TransactionBLL transactionBLL = new TransactionBLL();
dt = transactionBLL.getAllTrans();
dgvOrder.DataSource = dt;
}
public void NormalCash(UserO usr, ref bool MaxAmount)
{
WriteLine("Enter the amount of money You want to withdraw");
string amo = ReadLine();
int amount;
if (int.TryParse(amo, out amount))
{
amount = System.Convert.ToInt32(amo);
UserBLL bll = new UserBLL();
if (bll.CheckDate(amount))
{
MaxAmount = true;
return;
}
WriteLine($"Are you sure you want to withdraw Rs.{amount}(Y/N)? ");
char ans = ReadKey().KeyChar;
if (ans.Equals('y') || ans.Equals('Y'))
{
UserBO obj = new UserBO(bll.SearchByObject(usr));
UserBO cop = new UserBO(obj);
if (bll.CheckBalance(obj, amount))
{
obj.Starting_balance = obj.Starting_balance - amount;
bll.Test_Save(obj);
WriteLine("Ammount Withdrawn sucessfully");
DateTime dateTime = DateTime.UtcNow.Date;
string dat = dateTime.ToString("dd/MM/yyyy");
ReportBO repobj = new ReportBO {
Type = "Cash Withdrawl", User_Id = obj.UsrAccNum, Name = obj.Name, Amount = amount.ToString(), Date = dat
};
TransactionBLL tll = new TransactionBLL();
tll.Save_Transaction(repobj);
WriteLine("Do You wish to print a receipt(y/n)");
char ans2 = ReadKey().KeyChar;
if (ans2.Equals('y') || ans2.Equals('Y'))
{
Display_Recipt(amount, obj);
}
}
else
{
bll.Test_Save(cop);
WriteLine("You dont have enough balance in your account");
}
}
else
{
return;
}
}
else
{
WriteLine("Please Enter a valid amount i.e, digits");
}
}
public void FastCash(UserO usr, ref bool MaxAmount)
{
Console.Clear();
WriteLine("1----500");
WriteLine("2----1000");
WriteLine("3----2000");
WriteLine("4----5000");
WriteLine("5----10000");
WriteLine("6----15000");
WriteLine("7----20000");
int opt = System.Convert.ToInt32(ReadLine());
UserBLL bll = new UserBLL();
int amount = Place_Balance(opt);
if (bll.CheckDate(amount))
{
MaxAmount = true;
return;
}
WriteLine($"Are you sure you want to withdraw Rs.{amount}(Y/N)? ");
char ans = ReadKey().KeyChar;
if (ans.Equals('y') || ans.Equals('Y'))
{
UserBO obj = new UserBO(bll.SearchByObject(usr));
UserBO cop = new UserBO(obj);
if (bll.CheckBalance(obj, amount))
{
obj.Starting_balance = obj.Starting_balance - amount;
bll.Test_Save(obj);
WriteLine("Ammount Withdrawn sucessfully");
DateTime dateTime = DateTime.UtcNow.Date;
string dat = dateTime.ToString("dd/MM/yyyy");
ReportBO repobj = new ReportBO {
Type = "Cash Withdrawl", User_Id = obj.UsrAccNum, Name = obj.Name, Amount = amount.ToString(), Date = dat
};
TransactionBLL tll = new TransactionBLL();
tll.Save_Transaction(repobj);
WriteLine("Do You wish to print a receipt(y/n)");
char ans2 = ReadKey().KeyChar;
if (ans2.Equals('y') || ans2.Equals('Y'))
{
Display_Recipt(amount, obj);
}
}
else
{
bll.Test_Save(cop);
WriteLine("You dont have enough balance in your account");
}
}
else
{
WriteLine("GoodLuck");
}
}
private void btnDeliver_Click(object sender, EventArgs e)
{
TransactionBLL transactionBLL = new TransactionBLL();
if (transactionBLL.SetStatus("Delivering", IDTrans))
{
MessageBox.Show("Delevering");
}
this.Close();
}
protected override void OnFormClosing(FormClosingEventArgs e)
{
MedicineBLL med = new MedicineBLL();
TransactionBLL tran = new TransactionBLL();
foreach (Medicine m in medicines)
{
tran.Insert(m);
med.Update(m);
}
}
public string DashBoardTransactionData(ViewTransactionCBE transaction)
{
string result = "";
string strstarttime = Convert.ToDateTime(transaction.StartDate).ToString("dd/MM/yyyy HH:mm:ss");
string strendtime = Convert.ToDateTime(transaction.EndDate).ToString("dd/MM/yyyy HH:mm:ss");
string Det = JsonConvert.SerializeObject(TransactionBLL.TransDeatilsReport(strstarttime, strendtime), Formatting.Indented);
result = Det.Replace("\r", "").Replace("\n", "");
return(result);
}
private void LoadData()
{
dt = new DataTable();
// load dt from database
TransactionBLL transactionBLL = new TransactionBLL();
dt = transactionBLL.getAllTrans(email);
//Khai bao cot IDTrans la khoa chinh
dt.PrimaryKey = new DataColumn[] { dt.Columns[0] };
DataView view = dt.DefaultView;
view.Sort = "CreateDate DESC";
dgvHistory.DataSource = view;
}
public async Task <IHttpActionResult> GetAccountTransactionByAccount(int accountId, int?size = 50)
{
List <OutTransaction> tlist = null;
try
{
TransactionBLL bll = new TransactionBLL(_unit);
tlist = bll.GetTransactionList(accountId, size);
}
catch (Exception ex)
{
LogHelper.Error(_log, ex.ToString());
return(InternalServerError(ex));
}
return(Ok(tlist));
}
public async Task <IHttpActionResult> GetTransactionById(int id)
{
Transaction tr = null;
try
{
TransactionBLL bll = new TransactionBLL(_unit);
tr = bll.GetByID(id);
}
catch (Exception ex)
{
LogHelper.Error(_log, ex.ToString());
return(InternalServerError(ex));
}
return(Ok(tr));
}
private void showButton_Click(object sender, EventArgs e)
{
DateTime fromdate = fromdateTimePicker.Value;
DateTime todate = todateTimePicker.Value;
todate = todate.AddDays(1);
// todate = todate.AddSeconds(-1);
fromdate = fromdate.Date;
todate = todate.Date;
todate = todate.AddSeconds(-1);
List <Transaction> aTransactions = new List <Transaction>();
TransactionBLL aTransactionBll = new TransactionBLL();
aTransactions = aTransactionBll.GetTransactionBetweenDate(fromdate, todate);
// inventoryTransactionDataGridView.DataSource = aTransactions;
ShowReport(aTransactions);
}
private void btnCancel_Click(object sender, EventArgs e)
{
// Cong lai so luong trong bang tree
TreeBLL treeBLL = new TreeBLL();
foreach (DataRow row in dt.Rows)
{
string name = row.Field <string>(2).ToString();
int quantity = int.Parse(row.Field <int>(3).ToString());
treeBLL.IncreaseQuantity(name, quantity);
}
TransactionBLL transactionBLL = new TransactionBLL();
if (transactionBLL.SetStatus("Cancel", IDTrans))
{
MessageBox.Show("Cancel");
}
this.Close();
}
public void Test_UpdateSpanDays()
{
TradePositionBLL bll = new TradePositionBLL(_unit);
TransactionBLL tbll = new TransactionBLL(_unit);
List <TradePosition> aList = bll.GetListByAccount(1060);
foreach (var p in aList)
{
if (p.ExitTransactionId.HasValue)
{
var entryTrans = tbll.GetByID(p.EntryTransactionId);
var exitTrans = tbll.GetByID(p.ExitTransactionId.Value);
p.days = new TickerBLL(_unit).GetTradesDaySpan(p.ShareId, entryTrans.TradingDate, exitTrans.TradingDate);
bll.Update(p);
}
}
}
private void btnCancel_Click(object sender, EventArgs e)
{
int IDTrans = int.Parse(dgvHistory.Rows[RowIndex].Cells[0].Value.ToString());
DataRow row = dt.Rows.Find(IDTrans);
string status = row.Field <string>(4).ToString();
if (status.Equals("Active")) // neu status eq 'Active' means Admin has not approve yet. - > allow cancel
{
if (MessageBox.Show("Are you really want to cancel :( ", "Notice", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
// Cong lai so luong trong bang tree
TreeBLL treeBLL = new TreeBLL();
OrderBLL orderBLL = new OrderBLL();
DataTable dtOrders = new DataTable();
dtOrders = orderBLL.getOrders(IDTrans);
foreach (DataRow r in dtOrders.Rows)
{
string name = r.Field <string>(2).ToString();
int quantity = int.Parse(r.Field <int>(3).ToString());
treeBLL.IncreaseQuantity(name, quantity);
}
// update database and update table
TransactionBLL transactionBLL = new TransactionBLL();
if (transactionBLL.CancelOrdering(IDTrans))
{
MessageBox.Show("Canceled!");
row["Status"] = "Cancel";
dgvHistory.Refresh();
}
}
}
else if (status.Equals("Delivering"))
{
MessageBox.Show("Cannot cancel your order cuz it's delivering");
}
else
{
MessageBox.Show("It's alreadly canceled");
}
}
public bool Insert_Transaction(TransactionBLL t, out int transactionID)
{
bool isSuccess = true;
transactionID = -1;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
string sql = "INSERT INTO tbl_transactions(type,delr_cust_id,grandTotal,transaction_date,tax,discount,added_by) VALUES (@type,@delr_cust_id,@grandTotal,@transaction_date,@tax,@discount,@added_by);SELECT @@IDENTITY;";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@type", t.type);
cmd.Parameters.AddWithValue("@delr_cust_id", t.delr_cust_id);
cmd.Parameters.AddWithValue("@grandTotal", t.grandTotal);
cmd.Parameters.AddWithValue("@transaction_date", t.transaction_date);
cmd.Parameters.AddWithValue("@tax", t.tax);
cmd.Parameters.AddWithValue("@discount", t.discount);
cmd.Parameters.AddWithValue("@added_by", t.added_by);
conn.Open();
object o = cmd.ExecuteScalar();
if (o != null)
{
transactionID = int.Parse(o.ToString());
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool InsertTransaction(TransactionBLL u, out int transactionId)
{
bool isSuccess = false;
transactionId = -1;
//Static Method to Connect Database
SqlConnection con = new SqlConnection(myConnection);
try
{
String sql = "INSERT INTO tbl_transactions (type,customer_id,grandTotal,transaction_date,tax,discount,added_by) VALUES(@type,@customer_id,@grandTotal,@transaction_date,@tax,@discount,@added_by); SELECT @@IDENTITY;";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@type", u.type);
cmd.Parameters.AddWithValue("@customer_id", u.CustomerID);
cmd.Parameters.AddWithValue("@grandTotal", u.grandTotal);
cmd.Parameters.AddWithValue("@transaction_date", u.transaction_date);
cmd.Parameters.AddWithValue("@tax", u.tax);
cmd.Parameters.AddWithValue("@discount", u.discount);
cmd.Parameters.AddWithValue("@added_by", u.added_by);
con.Open();
object o = cmd.ExecuteScalar();
// if the Query is Excuted then the value of the rows will be greater thean zero
if (o != null)
{
isSuccess = true;
transactionId = int.Parse(o.ToString());
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}
return(isSuccess);
}
private void btnSaveAll_Click(object sender, EventArgs e)
{
TransactionBLL transaction = new TransactionBLL();
transaction.type = lblTopPurcSale.Text;
string deaCusName = txtPSDeaCusName.Text;
DeaCusBLL dc = dcdal.GetDeaCusIDFromName(deaCusName);
transaction.delr_cust_id = dc.id;
transaction.grandTotal = Math.Round(decimal.Parse(txtPSCDGrandTotal.Text), 2);
transaction.transaction_date = DateTime.Now;
transaction.tax = decimal.Parse(txtPSCDVat.Text);
transaction.discount = decimal.Parse(txtPSCDDiscount.Text);
string loggeduser = frmLogin.loggedIn;
UserBLL user = udal.GetIdFromUsername(loggeduser);
transaction.added_by = user.id;
transaction.transactionDetails = transactionDT;
bool Success = false;
using (TransactionScope scope = new TransactionScope())
{
int transactionID = -1;
bool X = tdal.Insert_Transaction(transaction, out transactionID);
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
TransactionDetailsBLL td = new TransactionDetailsBLL();
String ProductName = transactionDT.Rows[i][0].ToString();
ProductsBLL p = pdal.GetProductIDFromName(ProductName);
td.product_id = p.id;
td.rate = decimal.Parse(transactionDT.Rows[i][1].ToString());
td.qty = decimal.Parse(transactionDT.Rows[i][2].ToString());
td.total = Math.Round(decimal.Parse(transactionDT.Rows[i][3].ToString()), 2);
td.delr_cust_id = dc.id;
td.added_date = DateTime.Now;
td.added_by = user.id;
string transactionType = lblTopPurcSale.Text;
bool Y = false;
if (transactionType == "PURCHASE")
{
Y = pdal.IncreaseProduct(td.product_id, td.qty);
}
else if (transactionType == "SALES")
{
Y = pdal.DecreaseProduct(td.product_id, td.qty);
}
bool Z = tdDal.Insert_TransactionDetails(td);
Success = X && Y && Z;
}
if (Success == true)
{
scope.Complete();
// CODE TO PRINT BILL
DGVPrinter printer = new DGVPrinter();
printer.Title = "\r\n\r\nEVERYTHING PVT. LTD.\r\n";
printer.SubTitle = "\r\n MAIN ROAD NEAR RAILWAY STATION ,P.O:GHATSILA,\r\nDIST:EAST SINGHBHUM ,JHARKHAND\r\n Mob: 9583340426 \r\n\r\n ";
printer.SubTitleFormatFlags = StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
printer.PageNumbers = true;
printer.PageNumberInHeader = false;
printer.PorportionalColumns = true;
printer.HeaderCellAlignment = StringAlignment.Near;
printer.Footer = "Discount:" + txtPSCDDiscount.Text + "%\r\n" + "TAX:" + txtPSCDVat.Text + "%\r\n" + "Grand-Total:RS" + txtPSCDGrandTotal.Text + "\r\n\r\n" + "THANK YOU FOR BUSINESS WITH US";
printer.FooterSpacing = 15;
printer.PrintDataGridView(dgvPSAddedProduct);
//----------------------------------------------------------------------------------------------------------------------------
MessageBox.Show("Transaction Successfully Done.");
dgvPSAddedProduct.DataSource = null;
dgvPSAddedProduct.Rows.Clear();
txtPSDeaCusSearch.Text = "";
txtPSDeaCusName.Text = "";
txtPSDeaCusEmail.Text = "";
txtPSDeaCusContact.Text = "";
txtPSDeaCusAddress.Text = "";
txtPSPDSearch.Text = "";
txtPSPDName.Text = "";
txtPSPDInventory.Text = "0";
txtPSPDRate.Text = "0";
txtPSPDQty.Text = "";
txtPSCDSubtotal.Text = "0";
txtPSCDDiscount.Text = "0";
txtPSCDVat.Text = "0";
txtPSCDGrandTotal.Text = "0";
txtPSCDpaidamount.Text = "0";
txtPSCDRetAmut.Text = "0";
}
else
{
MessageBox.Show("Failed Transaction,Retry");
}
}
}
public void Test_GetTransactionList()
{
TransactionBLL tBLL = new TransactionBLL(_unit);
var tList = tBLL.GetTransactionList(1039, 50);
}
private void TransactionWhenBusinessPackageIsActive()
{
InventoryItem aItem = new InventoryItem();
aItem = (InventoryItem)itemNamecomboBox.SelectedItem;
InventoryCategory aInventoryCategory = new InventoryCategory();
aInventoryCategory = (InventoryCategory)categoryNamecomboBox.SelectedItem;
Stock aStock = new Stock();
StockBLL aStockBll = new StockBLL();
string transactiontype = transactionTypecomboBox.SelectedItem.ToString();
Transaction aTransaction = new Transaction();
aTransaction.TransactionDate = DateTime.Now;
aTransaction.Item = aItem;
aTransaction.Category = aInventoryCategory;
aTransaction.TransactionType = transactiontype;
CUserInfo aUserInfo = new CUserInfo();
aUserInfo.UserName = RMSGlobal.LogInUserName;
aTransaction.UserInfo = aUserInfo;
string sr = string.Empty;
if (transactiontype == "Stock In")
{
// aStock = aStockBll.GetStockByItemid(aItem.ItemId);
if ((Convert.ToDouble(quantitytextBox.Text) != 0))
{
aStock.Stocks = Convert.ToDouble(quantitytextBox.Text);
aStock.Item = aItem;
aStock.Category = aInventoryCategory;
aTransaction.Stock = aStock;
TransactionBLL aBll = new TransactionBLL();
sr = aBll.SendToKitchen(aTransaction);
ShowAndClear(sr);
}
else
{
MessageBox.Show("Your Quantity Must be Greater than 0 and less than or equal to " + aStock.Stocks + " " + unittypelabel.Text);
}
}
//aStock = aStockBll.GetStockByItemidFrominventory_kitchen_stock(aItem);
if (transactiontype == "Damage_in_kitchen")
{
if (danmagetextBox.Text.Length > 0)
{
aStock = aStockBll.GetStockByItemidFrominventory_kitchen_stock(aItem);
if ((aStock.Stocks >= Convert.ToDouble(quantitytextBox.Text)) &&
(Convert.ToDouble(quantitytextBox.Text) != 0))
{
aStock.Stocks = Convert.ToDouble(quantitytextBox.Text);
aStock.Item = aItem;
aStock.Category = aInventoryCategory;
aTransaction.Stock = aStock;
aTransaction.DamageReport = danmagetextBox.Text.Replace("'", "''");
TransactionBLL aBll = new TransactionBLL();
sr = aBll.DamageInKitchen(aTransaction);
ShowAndClear(sr);
}
else
{
MessageBox.Show("Your Quantity Must be Greater than 0 and less than or equal to " + aStock.Stocks + " " +
unittypelabel.Text);
}
}
else
{
MessageBox.Show("Please Check Your Damage Report Field It's Never Empty");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
//get the values from PurchaseSales from
TransactionBLL transaction = new TransactionBLL();
transaction.type = lblTop.Text;
//Get the Id of the Customer here
//lets get name of the customer first
string CustomerOrSellerName = txtName.Text;
CustomerBLL customerbll = customerdal.GetCustomerOrSellerIDFromName(CustomerOrSellerName);
//getting the transactionID
transaction.CustomerID = customerbll.id;
transaction.grandTotal = Math.Round(decimal.Parse(txtTotalPPrice.Text), 2);
transaction.transaction_date = DateTime.Now;
transaction.tax = decimal.Parse(txtVAT.Text);
transaction.discount = decimal.Parse(txtDiscount.Text);
//Get the userName of loggedin User
string username = frmLogin.LoggedInUserName;
UserBll userbll = userdal.GetIDFromUsername(username);
transaction.added_by = userbll.id;
transaction.transactionDetails = transactionDT;
//lets Create a boolean variable to check if successful
bool success = false;
using (TransactionScope scope = new TransactionScope())
{
int transactionID = -1;
//create bool value and inset transaction
bool w = transDal.InsertTransaction(transaction, out transactionID);
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
//Get all the Details of the Product
TransactionDetailBLL transactionddetilbll = new TransactionDetailBLL();
//Get the productName and Conert it Id
string productname = transactionDT.Rows[i][0].ToString();
ProductBLL producbll = productdal.GetProduuctIDFromName(productname);
transactionddetilbll.product_id = producbll.Id;
transactionddetilbll.rate = decimal.Parse(transactionDT.Rows[i][1].ToString());
transactionddetilbll.qty = decimal.Parse(transactionDT.Rows[i][2].ToString());
transactionddetilbll.total = Math.Round(decimal.Parse(transactionDT.Rows[i][3].ToString()), 2);
//lets get id of the customer firt
transactionddetilbll.Id = customerbll.id;
transactionddetilbll.added_date = DateTime.Now;
transactionddetilbll.added_by = userbll.id;
//now before inserting we need to increasing or decrease Product Quantity Based on Purchase or Sales
string TransactionType = lblTop.Text;
//lets check whether we are on puchase o sales
bool xpursal = false;
if (TransactionType == "Purchase")
{
xpursal = productdal.IncreaseProduct(transactionddetilbll.product_id, transactionddetilbll.qty);
if (xpursal == true)
{
MessageBox.Show("Product Increase is Successful");
}
else
{
MessageBox.Show("Product Increase Falied !!!!!");
}
}
else if (TransactionType == "Sales")
{
xpursal = productdal.DecreaseProduct(transactionddetilbll.product_id, transactionddetilbll.qty);
if (xpursal == true)
{
MessageBox.Show("Product Decrease is Successful");
}
else
{
MessageBox.Show("Product Decrease Falied !!!!!");
}
}
//Finally insert TransactionDetails inside the DataBase
bool y = transDetailDal.InsertTransaction(transactionddetilbll);
success = w && y && xpursal;
}
if (success == true)
{
scope.Complete();
//Code To print Bill
DGVPrinter print = new DGVPrinter();
print.Title = "\r\n\r\n SHADY'S Store Bill";
print.SubTitle = "Yemen,Taiz \r\n Phone:772816006";
print.SubTitleFormatFlags = StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
print.PageNumbers = true;
print.PageNumberInHeader = false;
print.PorportionalColumns = true;
print.HeaderCellAlignment = StringAlignment.Near;
print.Footer = "Discount: " + txtDiscount.Text + "% \r\n ValueAddedTax: " + txtVAT.Text + "%\r\n" + "Total Price: " + txtTotalPPrice.Text + "\r\n Thanks For Your Visit.";
print.FooterSpacing = 7;
print.PrintDataGridView(dgvAddedproducts);
//Transaction Compelte
MessageBox.Show(" Transaction Compeleted Successfully");
//Clear of the DataGrid view
dgvAddedproducts.DataSource = null;
dgvAddedproducts.Rows.Clear();
txtCustomerSearch.Text = "";
txtName.Text = "";
txtEmail.Text = "";
txtContact.Text = "";
txtAddress.Text = "";
txtProductSearch.Text = "";
txtProductName.Text = "";
txtProdcutInventory.Text = "0";
txtProdcutQTY.Text = "0";
txtRowTotal.Text = "0";
txtDiscount.Text = "0";
txtVAT.Text = "0";
txtTotalPPrice.Text = "0";
txtPaidAmount.Text = "";
txtReturnAmount.Text = "";
}
else
{
//Transaction Failed
MessageBox.Show("Transaction Failed");
}
}
}
public string ExportCSVTranscations(ViewTransactionCBE transaction)
{
Int16 IsDataFound = 0;
var filename = "Transaction_Details_Registered_" + DateTime.Now.ToString(Constants.dateTimeFormat24HForFileName) + ".csv";
var filename1 = "Transaction_Details_UnRegistered_" + DateTime.Now.ToString(Constants.dateTimeFormat24HForFileName) + ".csv";
FileInfo file = new FileInfo(Server.MapPath("~/Attachment/ExportFiles/" + filename));
FileInfo file1 = new FileInfo(Server.MapPath("~/Attachment/ExportFiles/" + filename1));
try
{
string strstarttime = Convert.ToDateTime(transaction.StartDate).ToString("dd/MM/yyyy HH:mm:ss");
string strendtime = Convert.ToDateTime(transaction.EndDate).ToString("dd/MM/yyyy HH:mm:ss");
string strQuery = " WHERE 1=1 ";
if (strstarttime != null && strendtime != null)
{
strQuery += " AND TRANSACTION_DATETIME BETWEEN TO_DATE('" + strstarttime + "','DD/MM/YYYY HH24:MI:SS') AND TO_DATE('" + strendtime + "','DD/MM/YYYY HH24:MI:SS')";
}
else if (strstarttime != null)
{
strQuery += " AND TRANSACTION_DATETIME >= TO_DATE('" + strstarttime + "','DD/MM/YYYY HH24:MI:SS')";
}
else if (strendtime != null)
{
strQuery += " AND TRANSACTION_DATETIME <= TO_DATE('" + strendtime + "','DD/MM/YYYY HH24:MI:SS')";
}
DataTable dt = TransactionBLL.TransDeatils(strQuery);
DataView dv = new DataView(dt);
DataTable Charged = dt.AsEnumerable()
.Where(r => r.Field <decimal>("IS_REGISTERED") == 1)
.CopyToDataTable();
//DataTable Charged = (DataTable)(dv.RowFilter = "IS_BALANCE_UPDATED=1").;
if (Charged.Rows.Count > 0)
{
IsDataFound = CSVUtility.CreateCsv(file.FullName, Charged);
if (IsDataFound == 0)
{
filename = string.Empty;
}
}
DataTable UnCharged = dt.AsEnumerable()
.Where(r => r.Field <decimal>("IS_REGISTERED") != 1)
.CopyToDataTable();
if (UnCharged.Rows.Count > 0)
{
IsDataFound = CSVUtility.CreateCsv(file1.FullName, UnCharged);
if (IsDataFound == 0)
{
if (string.IsNullOrEmpty(filename))
{
filename = "No Data to Export.";
}
}
else
{
if (string.IsNullOrEmpty(filename))
{
filename = "No Data to Export.";
}
else
{
filename = filename + ";" + filename1;
}
}
}
}
catch (Exception ex)
{
filename = "No Data to Export. :" + ex.Message;
HelperClass.LogMessage("Failed Export Transaction Details_ CSV " + ex);
}
string Det = JsonConvert.SerializeObject(filename, Formatting.Indented);
return(Det.Replace("\r", "").Replace("\n", ""));
}
public TransactionReport()
{
InitializeComponent();
this.transactions = new TransactionBLL();
this.medicine = new MedicineBLL();
}
public HttpResponseMessage Post()
{
try
{
System.Threading.Tasks.Task <string> content = Request.Content.ReadAsStringAsync();
Object jobj = new object();
var orderId = new TransactionLibrary().GetOrderId();
//dados da operação
jobj = JObject.Parse(content.Result);
JToken client_id = JObject.Parse(jobj.ToString()).SelectToken("client_id");
JToken cart_id = JObject.Parse(jobj.ToString()).SelectToken("cart_id");
JToken client_name = JObject.Parse(jobj.ToString()).SelectToken("client_name");
JToken value_to_pay = JObject.Parse(jobj.ToString()).SelectToken("value_to_pay");
JToken credit_card = JObject.Parse(jobj.ToString()).SelectToken("credit_card");
#region Cartão de Crédito
//dados do cartão de crédito
jobj = JObject.Parse(credit_card.ToString());
JToken number = JObject.Parse(jobj.ToString()).SelectToken("number");
JToken cvv = JObject.Parse(jobj.ToString()).SelectToken("cvv");
JToken exp_date = JObject.Parse(jobj.ToString()).SelectToken("exp_date");
JToken card_holder_name = JObject.Parse(jobj.ToString()).SelectToken("card_holder_name");
CreditCard creditCard = new CreditCard();
creditCard.card_number = number.ToString();
creditCard.cvv = Convert.ToInt32(cvv);
creditCard.exp_date = exp_date.ToString();
creditCard.card_holder_name = card_holder_name.ToString();
//registra o cartão de crédito
CreditCardBLL creditCardBll = new CreditCardBLL();
creditCardBll.Inserir(creditCard);
#endregion
#region Transação
//registra a transação de venda
Transaction transaction = new Transaction();
transaction.client_id = client_id.ToString();
transaction.cart_id = cart_id.ToString();
transaction.client_name = client_name.ToString();
transaction.total_to_pay = Convert.ToInt32(value_to_pay);
transaction.credit_card = creditCard.card_number;
transaction.order_id = orderId;
transaction.date = DateTime.Today.ToString("dd/MM/yyyy");
TransactionBLL transactionBll = new TransactionBLL();
transactionBll.Inserir(transaction);
#endregion
#region Histórico
History history = new History();
history.card_number = creditCard.card_number;
history.client_id = transaction.client_id;
history.value = transaction.total_to_pay;
history.order_id = orderId;
HistoryBLL historyBll = new HistoryBLL();
historyBll.Inserir(history);
#endregion
return(Request.CreateResponse(HttpStatusCode.OK, new { message = "Compra realizada com sucesso!" }));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, new { message = ex.Message.ToString() }));
}
}
public Dashboard()
{
InitializeComponent();
this.transaction = new TransactionBLL();
this.medicine = new MedicineBLL();
}
