public void ทดสอบเพิ่มใบรับเงิน()
{
ReceiptDataController.ReceiptDataController service = new ReceiptDataController.ReceiptDataController();
ReceiptDataModel itemData = new ReceiptDataModel
{
DocumentNumber = "1",
DocumentBookNumber = "1",
DocumentDate = new DateTime(2018, 10, 21),
payerName = "สมาชิก ใจดี",
payerid = "1234567890123",
houseNumber = "123",
soi = "",
moo = "1",
road = "ถนน",
tambon = "ตำบล",
amphur = "อำเภอ",
province = "กรุงเทพฯ",
zipcode = "12345",
asReceiptTo = "ค่าธรรมเนียม",
asReceiptToRemark = "ช่องอื่น ๆ",
receiptAmount = 8000,
receiptPayType = "เงินโอน",
receiptDate = new DateTime(2018, 10, 21),
receiptBank = "ธนาคารกสิกรไทย",
receiptBillNumber = "",
receiptChqBank = "",
receiptChqNumber = "",
receiptOther = ""
};
var result = service.ReceipDataAdd(itemData);
Assert.IsNotNull(result);
}
public IHttpActionResult PK9DataAdd([FromBody] ReceiptDataModel item)
{
DBConnector.DBConnector conn = new DBConnector.DBConnector();
UtilLibs utilLibs = new UtilLibs();
DocumentNumber docNum = new DocumentNumber();
if (conn.OpenConnection())
{
try
{
string SQLString = @"INSERT INTO receiptdata(DocumentBookNumber, DocumentNumber, DocumentDate, PayerType,
PayerRunno, AsReceiptTo, AsReceiptToRemark,
ReceiptAmount, ReceiptPaytype, ReceiptDate, ReceiptBank, ReceiptBillNumber,
ReceiptChqBank, ReceiptChqNumber, ReceiptOther)
VALUES (@DocumentBookNumber, @DocumentNumber, @DocumentDate, @PayerType, @PayerRunno,
@AsReceiptTo, @AsReceiptToRemark, @ReceiptAmount,
@ReceiptPaytype, @ReceiptDate, @ReceiptBank, @ReceiptBillNumber, @ReceiptChqBank,
@ReceiptChqNumber, @ReceiptOther) ";
MySqlCommand qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = SQLString
};
docNum = utilLibs.GetDocumentNo("pk9");
qExe.Parameters.AddWithValue("@documentbooknumber", docNum.BookNo);
qExe.Parameters.AddWithValue("@documentnumber", docNum.DocumentNo);
qExe.Parameters.AddWithValue("@documentdate", Convert.ToDateTime(item.DocumentDate, new CultureInfo("en-US")));
qExe.Parameters.AddWithValue("@PayerType", item.PayerType);
qExe.Parameters.AddWithValue("@PayerRunno", item.PayerRunno);
qExe.Parameters.AddWithValue("@AsReceiptTo", item.AsReceiptTo);
qExe.Parameters.AddWithValue("@AsReceiptToRemark", item.AsReceiptToRemark);
qExe.Parameters.AddWithValue("@ReceiptAmount", item.ReceiptAmount);
qExe.Parameters.AddWithValue("@ReceiptPaytype", item.ReceiptPayType);
qExe.Parameters.AddWithValue("@ReceiptDate", Convert.ToDateTime(item.ReceiptDate, new CultureInfo("en-US")));
qExe.Parameters.AddWithValue("@ReceiptBank", item.ReceiptBank);
qExe.Parameters.AddWithValue("@ReceiptBillNumber", item.ReceiptBillNumber);
qExe.Parameters.AddWithValue("@ReceiptChqBank", item.ReceiptChqBank);
qExe.Parameters.AddWithValue("@ReceiptChqNumber", item.ReceiptChqNumber);
qExe.Parameters.AddWithValue("@ReceiptOther", item.ReceiptOther);
qExe.ExecuteNonQuery();
long returnid = qExe.LastInsertedId;
conn.CloseConnection();
return(Json(new ResultDataModel {
success = true, errorMessage = "", returnRunno = returnid.ToString()
}));
}
catch (Exception e)
{
return(Json(new ResultDataModel {
success = false, errorMessage = e.Message, returnRunno = ""
}));
}
}
else
{
return(Json(new ResultDataModel {
success = false, errorMessage = "Database connect fail!", returnRunno = ""
}));
}
}
public void ทดสอบบันทึกเอกสารPK9()
{
PK9DataController service = new PK9DataController();
ReceiptDataModel item = new ReceiptDataModel();
UtilLibs utilLibs = new UtilLibs();
DocumentNumber docNum = utilLibs.GetDocumentNo("pk9");
item.DocumentBookNumber = docNum.BookNo;
item.DocumentNumber = docNum.DocumentNo;
item.DocumentDate = DateTime.Now;
item.PayerType = "2";
item.PayerRunno = 1;
item.AsReceiptTo = "ค่าจัดกิจกรรมระดมทุน";
item.AsReceiptToRemark = "";
item.ReceiptAmount = 1750;
item.ReceiptPayType = "";
item.ReceiptDate = DateTime.Now;
item.ReceiptBank = "";
item.ReceiptBillNumber = "";
item.ReceiptChqBank = "";
item.ReceiptChqNumber = "";
item.ReceiptOther = "";
var result = service.PK9DataAdd(item);
Assert.IsTrue(result != null);
}
public void ทดสอบแก้ไขPK9()
{
PK9DataController service = new PK9DataController();
ReceiptDataModel item = new ReceiptDataModel();
UtilLibs utilLibs = new UtilLibs();
DocumentNumber docNum = utilLibs.GetDocumentNo("pk9");
item.DocumentRunno = 4;
item.DocumentBookNumber = "1";
item.DocumentNumber = "AC0004";
item.DocumentDate = DateTime.Now;
item.PayerType = "1";
item.PayerRunno = 3;
item.AsReceiptTo = "ค่าบำรุงพรรคการเมืองรายปี";
item.AsReceiptToRemark = "";
item.ReceiptAmount = 6500;
item.ReceiptPayType = "";
item.ReceiptDate = DateTime.Now;
item.ReceiptBank = "";
item.ReceiptBillNumber = "";
item.ReceiptChqBank = "";
item.ReceiptChqNumber = "";
item.ReceiptOther = "";
var result = service.PK9DataEdit(item);
Assert.IsTrue(result != null);
}
public IHttpActionResult ReceipDataDelete([FromBody] ReceiptDataModel item)
{
DBConnector.DBConnector conn = new DBConnector.DBConnector();
if (conn.OpenConnection())
{
string SQLString = @"delete from receiptdata where documentrunno = @documentrunno";
MySqlCommand qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = SQLString
};
if (string.IsNullOrEmpty(item.DocumentRunno))
{
return(BadRequest("Document Key is null!"));
}
qExe.Parameters.AddWithValue("@documentrunno", item.DocumentRunno);
qExe.ExecuteNonQuery();
conn.CloseConnection();
return(Ok());
}
else
{
return(BadRequest("Database connect fail!"));
}
}
public int AddItems(Receipt receipt, string username)
{
UserDataModel userDataModel = context.Set <UserDataModel>()
.FirstOrDefault(x => x.Username.ToLower() == username.ToLower());
if (userDataModel == null)
{
throw new Exception(Properties.Resources.UserNotFound);
}
ShopDataModel shopDataModel;
if (receipt.Shop == null)
{
shopDataModel = null;
}
else
{
var shops = context.Set <ShopDataModel>()
.Select(x => x)
.Where(x => x.Name == receipt.Shop.Name);
if (receipt.Shop.Address == null)
{
shopDataModel = shops.Where(x => x.Address == null).FirstOrDefault();
}
else
{
shopDataModel = shops.Select(x => x)
.Where(x => x.Address == receipt.Shop.Address).FirstOrDefault();
}
}
ReceiptDataModel receiptDataModel = new ReceiptDataModel()
{
ReceiptDate = receipt.ReceiptDate,
UpdateDate = receipt.UpdateDate,
Shop = shopDataModel,
User = userDataModel,
Total = 0
};
receiptDataModel.Items = new List <ItemDataModel>();
foreach (Item item in receipt.ItemsList)
{
receiptDataModel.Items.Add(new ItemDataModel()
{
Receipt = receiptDataModel,
Price = item.Price,
Name = item.Name,
Category = item.Category
});
receiptDataModel.Total += item.Price;
}
context.Set <ReceiptDataModel>().Add(receiptDataModel);
context.SaveChanges();
return(receiptDataModel.ReceiptId);
}
public IHttpActionResult ReceipDataList()
{
List <ReceiptDataModel> result = new List <ReceiptDataModel>();
DBConnector.DBConnector conn = new DBConnector.DBConnector();
if (conn.OpenConnection())
{
string sqlString = @"select * from receiptdata order by documentrunno";
MySqlCommand qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = sqlString
};
MySqlDataReader dataReader = qExe.ExecuteReader();
while (dataReader.Read())
{
ReceiptDataModel detail = new ReceiptDataModel
{
DocumentRunno = dataReader["documentrunno"].ToString(),
DocumentBookNumber = dataReader["documentbooknumber"].ToString(),
DocumentNumber = dataReader["documentnumber"].ToString(),
DocumentDate = Convert.ToDateTime(dataReader["documentdate"].ToString(), new CultureInfo("en-US")),
payerName = dataReader["payername"].ToString(),
payerid = dataReader["payerid"].ToString(),
houseNumber = dataReader["housenumber"].ToString(),
soi = dataReader["soi"].ToString(),
road = dataReader["road"].ToString(),
moo = dataReader["moo"].ToString(),
tambon = dataReader["tambon"].ToString(),
amphur = dataReader["amphur"].ToString(),
province = dataReader["province"].ToString(),
zipcode = dataReader["zipcode"].ToString(),
asReceiptTo = dataReader["asreceiptto"].ToString(),
asReceiptToRemark = dataReader["asreceipttoremark"].ToString(),
receiptAmount = double.Parse(dataReader["receiptamount"].ToString()),
receiptPayType = dataReader["receiptpaytype"].ToString(),
receiptDate = Convert.ToDateTime(dataReader["receiptdate"].ToString(), new CultureInfo("en-US")),
receiptBank = dataReader["receiptbank"].ToString(),
receiptBillNumber = dataReader["receiptbillnumber"].ToString(),
receiptChqBank = dataReader["receiptchqbank"].ToString(),
receiptChqNumber = dataReader["receiptchqnumber"].ToString(),
receiptOther = dataReader["receiptother"].ToString(),
building = dataReader["building"].ToString(),
telephone = dataReader["telephone"].ToString()
};
result.Add(detail);
}
dataReader.Close();
conn.CloseConnection();
return(Json(result));
}
else
{
return(BadRequest("Database connect fail!"));
}
}
public void ทดสอบลบข้อมูลใบรับเงิน()
{
ReceiptDataController.ReceiptDataController service = new ReceiptDataController.ReceiptDataController();
ReceiptDataModel itemData = new ReceiptDataModel {
DocumentRunno = "1"
};
var result = service.ReceipDataDelete(itemData);
Assert.IsNotNull(result);
}
public IHttpActionResult PK9DataEdit([FromBody] ReceiptDataModel item)
{
DBConnector.DBConnector conn = new DBConnector.DBConnector();
if (conn.OpenConnection())
{
try
{
string SQLString = @"UPDATE receiptdata SET DocumentRunno = @DocumentRunno, DocumentBookNumber = @DocumentBookNumber,
DocumentNumber = @DocumentNumber, DocumentDate = @DocumentDate, PayerType = @PayerType,
PayerRunno = @PayerRunno, AsReceiptTo = @AsReceiptTo, AsReceiptToRemark = @AsReceiptToRemark,
ReceiptAmount = @ReceiptAmount, ReceiptPaytype = @ReceiptPaytype, ReceiptDate = @ReceiptDate,
ReceiptBank = @ReceiptBank, ReceiptBillNumber = @ReceiptBillNumber, ReceiptChqBank = @ReceiptChqBank,
ReceiptChqNumber = @ReceiptChqNumber, ReceiptOther = @ReceiptOther WHERE DocumentRunno = @DocumentRunno;";
MySqlCommand qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = SQLString
};
qExe.Parameters.AddWithValue("@documentrunno", item.DocumentRunno);
qExe.Parameters.AddWithValue("@documentbooknumber", item.DocumentBookNumber);
qExe.Parameters.AddWithValue("@documentnumber", item.DocumentNumber);
qExe.Parameters.AddWithValue("@documentdate", item.DocumentDate);
qExe.Parameters.AddWithValue("@PayerType", item.PayerType);
qExe.Parameters.AddWithValue("@PayerRunno", item.PayerRunno);
qExe.Parameters.AddWithValue("@AsReceiptTo", item.AsReceiptTo);
qExe.Parameters.AddWithValue("@AsReceiptToRemark", item.AsReceiptToRemark);
qExe.Parameters.AddWithValue("@ReceiptAmount", item.ReceiptAmount);
qExe.Parameters.AddWithValue("@ReceiptPaytype", item.ReceiptPayType);
qExe.Parameters.AddWithValue("@ReceiptDate", item.ReceiptDate);
qExe.Parameters.AddWithValue("@ReceiptBank", item.ReceiptBank);
qExe.Parameters.AddWithValue("@ReceiptBillNumber", item.ReceiptBillNumber);
qExe.Parameters.AddWithValue("@ReceiptChqBank", item.ReceiptChqBank);
qExe.Parameters.AddWithValue("@ReceiptChqNumber", item.ReceiptChqNumber);
qExe.Parameters.AddWithValue("@ReceiptOther", item.ReceiptOther);
qExe.ExecuteNonQuery();
conn.CloseConnection();
return(Json(new ResultDataModel {
success = true, errorMessage = "", returnRunno = ""
}));
}
catch (Exception e)
{
return(Json(new ResultDataModel {
success = false, errorMessage = e.Message, returnRunno = ""
}));
}
}
else
{
return(Json(new ResultDataModel {
success = false, errorMessage = "Database connect fail!", returnRunno = ""
}));
}
}
public IHttpActionResult ReceipDataAdd([FromBody] ReceiptDataModel item)
{
DBConnector.DBConnector conn = new DBConnector.DBConnector();
if (conn.OpenConnection())
{
string SQLString = @"
insert into receiptdata (documentbooknumber, documentnumber, documentdate, payername, payerid, housenumber, soi,
road, moo, tambon, amphur, province, zipcode, asreceiptto, asreceipttoremark, receiptamount, receiptpaytype,
receiptdate, receiptbank, receiptbillnumber, receiptchqbank, receiptchqnumber, receiptother, building, telephone)
values (@documentbooknumber , @documentnumber, @documentdate,
@payername, @payerid, @housenumber, @soi, @road, @moo, @tambon, @amphur, @province, @zipcode,
@asreceiptto, @asreceipttoremark, @receiptamount, @receiptpaytype, @receiptdate, @receiptbank,
@receiptbillnumber, @receiptchqbank, @receiptchqnumber, @receiptother, @building, @telephone) ";
MySqlCommand qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = SQLString
};
qExe.Parameters.AddWithValue("@documentbooknumber", item.DocumentBookNumber);
qExe.Parameters.AddWithValue("@documentnumber", item.DocumentNumber);
qExe.Parameters.AddWithValue("@documentdate", Convert.ToDateTime(item.DocumentDate, new CultureInfo("en-US")));
qExe.Parameters.AddWithValue("@payername", item.payerName);
qExe.Parameters.AddWithValue("@payerid", item.payerid);
qExe.Parameters.AddWithValue("@housenumber", item.houseNumber);
qExe.Parameters.AddWithValue("@soi", item.soi);
qExe.Parameters.AddWithValue("@road", item.road);
qExe.Parameters.AddWithValue("@moo", item.moo);
qExe.Parameters.AddWithValue("@tambon", item.tambon);
qExe.Parameters.AddWithValue("@amphur", item.amphur);
qExe.Parameters.AddWithValue("@province", item.province);
qExe.Parameters.AddWithValue("@zipcode", item.zipcode);
qExe.Parameters.AddWithValue("@asreceiptto", item.asReceiptTo);
qExe.Parameters.AddWithValue("@asreceipttoremark", item.asReceiptToRemark);
qExe.Parameters.AddWithValue("@receiptamount", item.receiptAmount);
qExe.Parameters.AddWithValue("@receiptpaytype", item.receiptPayType);
qExe.Parameters.AddWithValue("@receiptdate", Convert.ToDateTime(item.receiptDate, new CultureInfo("en-US")));
qExe.Parameters.AddWithValue("@receiptbank", item.receiptBank);
qExe.Parameters.AddWithValue("@receiptbillnumber", item.receiptBillNumber);
qExe.Parameters.AddWithValue("@receiptchqbank", item.receiptChqBank);
qExe.Parameters.AddWithValue("@receiptchqnumber", item.receiptChqNumber);
qExe.Parameters.AddWithValue("@receiptother", item.receiptOther);
qExe.Parameters.AddWithValue("@building", item.building);
qExe.Parameters.AddWithValue("@telephone", item.telephone);
qExe.ExecuteNonQuery();
long returnid = qExe.LastInsertedId;
conn.CloseConnection();
return(Ok(returnid.ToString()));
}
else
{
return(BadRequest("Database connect fail!"));
}
}
public int AddItems(IEnumerable <Item> items, Shop shop, string username)
{
using (DataBaseModel context = new DataBaseModel())
{
ShopDataModel shopDataModel = context.Set <ShopDataModel>()
.Select(x => x)
.Where(x => x.Name == shop.Name && x.Location == shop.Location)
.FirstOrDefault() ?? new ShopDataModel()
{
Location = shop.Location, Name = shop.Name
};
UserDataModel userDataModel = context.Set <UserDataModel>()
.Select(x => x).Where(x => x.Username == username).FirstOrDefault();
if (userDataModel == null)
{
throw new System.Exception(Properties.Resources.UserNotFound);
}
ReceiptDataModel receiptDataModel = new ReceiptDataModel()
{
Shop = shopDataModel, User = userDataModel, Total = 0
};
receiptDataModel.Items = new List <ItemDataModel>();
foreach (Item item in items)
{
receiptDataModel.Items.Add(new ItemDataModel()
{
Receipt = receiptDataModel, Price = item.Price, Name = item.Name, Category = item.Category
});
receiptDataModel.Total += item.Price;
}
context.Set <ReceiptDataModel>().Add(receiptDataModel);
context.SaveChanges();
return(receiptDataModel.ReceiptId);
}
}
public void ทดสอบแก้ไขเอกสารใบรับเงิน()
{
ReceiptDataController.ReceiptDataController service = new ReceiptDataController.ReceiptDataController();
ReceiptDataModel itemData = new ReceiptDataModel
{
DocumentRunno = "1",
DocumentNumber = "1",
DocumentBookNumber = "1",
DocumentDate = new DateTime(2018, 10, 21),
payerName = "สมาชิก คนใหม่มาจ่าย",
payerid = "9534567890123",
houseNumber = "456",
soi = "อยู่ลึก",
moo = "5",
road = "ถนนหน้าบ้าน",
tambon = "ตำบลหลุม",
amphur = "อำเภอบ่อ",
province = "กรุงเทพฯ",
zipcode = "78345",
asReceiptTo = "ค่าบำรุง",
asReceiptToRemark = "ช่องอื่น ๆ",
receiptAmount = 18000,
receiptPayType = "เงินสด",
receiptDate = null,
receiptBank = "",
receiptBillNumber = "",
receiptChqBank = "",
receiptChqNumber = "",
receiptOther = ""
};
var result = service.ReceipDataEdit(itemData);
Assert.IsNotNull(result);
}
public IHttpActionResult ReceipDataEdit([FromBody] ReceiptDataModel item)
{
DBConnector.DBConnector conn = new DBConnector.DBConnector();
if (conn.OpenConnection())
{
string SQLString = @"
update receiptdata set documentrunno = @documentrunno,
documentbooknumber = @documentbooknumber,
documentnumber = @documentnumber,
documentdate = @documentdate,
payername = @payername,
payerid = @payerid,
housenumber = @housenumber,
soi = @soi,
road = @road,
moo = @moo,
tambon = @tambon,
amphur = @amphur,
province = @province,
zipcode = @zipcode,
asreceiptto = @asreceiptto,
asreceipttoremark = @asreceipttoremark,
receiptamount = @receiptamount,
receiptpaytype = @receiptpaytype,
receiptdate = @receiptdate,
receiptbank = @receiptbank,
receiptbillnumber = @receiptbillnumber,
receiptchqbank = @receiptchqbank,
receiptchqnumber = @receiptchqnumber,
receiptother = @receiptother,
building = @building,
telephone = @telephone where documentrunno = @documentrunno";
MySqlCommand qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = SQLString
};
qExe.Parameters.AddWithValue("@documentrunno", item.DocumentRunno);
qExe.Parameters.AddWithValue("@documentbooknumber", item.DocumentBookNumber);
qExe.Parameters.AddWithValue("@documentnumber", item.DocumentNumber);
qExe.Parameters.AddWithValue("@documentdate", item.DocumentDate);
qExe.Parameters.AddWithValue("@payername", item.payerName);
qExe.Parameters.AddWithValue("@payerid", item.payerid);
qExe.Parameters.AddWithValue("@housenumber", item.houseNumber);
qExe.Parameters.AddWithValue("@soi", item.soi);
qExe.Parameters.AddWithValue("@road", item.road);
qExe.Parameters.AddWithValue("@moo", item.moo);
qExe.Parameters.AddWithValue("@tambon", item.tambon);
qExe.Parameters.AddWithValue("@amphur", item.amphur);
qExe.Parameters.AddWithValue("@province", item.province);
qExe.Parameters.AddWithValue("@zipcode", item.zipcode);
qExe.Parameters.AddWithValue("@asreceiptto", item.asReceiptTo);
qExe.Parameters.AddWithValue("@asreceipttoremark", item.asReceiptToRemark);
qExe.Parameters.AddWithValue("@receiptamount", item.receiptAmount);
qExe.Parameters.AddWithValue("@receiptpaytype", item.receiptPayType);
qExe.Parameters.AddWithValue("@receiptdate", item.receiptDate);
qExe.Parameters.AddWithValue("@receiptbank", item.receiptBank);
qExe.Parameters.AddWithValue("@receiptbillnumber", item.receiptBillNumber);
qExe.Parameters.AddWithValue("@receiptchqbank", item.receiptChqBank);
qExe.Parameters.AddWithValue("@receiptchqnumber", item.receiptChqNumber);
qExe.Parameters.AddWithValue("@receiptother", item.receiptOther);
qExe.ExecuteNonQuery();
conn.CloseConnection();
return(Ok());
}
else
{
return(BadRequest("Database connect fail!"));
}
}
public IHttpActionResult ReceipDataListbyRunno(string runno)
{
ReceiptDataModel result = new ReceiptDataModel();
DBConnector.DBConnector conn = new DBConnector.DBConnector();
if (conn.OpenConnection())
{
string sqlString;
if (!string.IsNullOrEmpty(runno))
{
sqlString = @"select * from receiptdata where documentrunno = @documentrunno";
}
else
{
return(Json("Document Number is blank!"));
}
MySqlCommand qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = sqlString
};
qExe.Parameters.AddWithValue("@documentrunno", runno);
MySqlDataReader dataReader = qExe.ExecuteReader();
while (dataReader.Read())
{
result.DocumentRunno = dataReader["documentrunno"].ToString();
result.DocumentBookNumber = dataReader["documentbooknumber"].ToString();
result.DocumentNumber = dataReader["documentnumber"].ToString();
result.DocumentDate = Convert.ToDateTime(dataReader["documentdate"].ToString(), new CultureInfo("en-US"));
result.payerName = dataReader["payername"].ToString();
result.payerid = dataReader["payerid"].ToString();
result.houseNumber = dataReader["housenumber"].ToString();
result.soi = dataReader["soi"].ToString();
result.road = dataReader["road"].ToString();
result.moo = dataReader["moo"].ToString();
result.tambon = dataReader["tambon"].ToString();
result.amphur = dataReader["amphur"].ToString();
result.province = dataReader["province"].ToString();
result.zipcode = dataReader["zipcode"].ToString();
result.asReceiptTo = dataReader["asreceiptto"].ToString();
result.asReceiptToRemark = dataReader["asreceipttoremark"].ToString();
result.receiptAmount = double.Parse(dataReader["receiptamount"].ToString());
result.receiptPayType = dataReader["receiptpaytype"].ToString();
result.receiptDate = Convert.ToDateTime(dataReader["receiptdate"].ToString(), new CultureInfo("en-US"));
result.receiptBank = dataReader["receiptbank"].ToString();
result.receiptBillNumber = dataReader["receiptbillnumber"].ToString();
result.receiptChqBank = dataReader["receiptchqbank"].ToString();
result.receiptChqNumber = dataReader["receiptchqnumber"].ToString();
result.receiptOther = dataReader["receiptother"].ToString();
}
dataReader.Close();
conn.CloseConnection();
return(Json(result));
}
else
{
return(BadRequest("Database connect fail!"));
}
}
private async void processData()
{
var sales = new List <SalesDataModel>();
var saleRep = salesRepData.ElementAt(SelectSellercomboBox.SelectedIndex);
var saleType = salesTypeData.ElementAt(salesTypeComboBox.SelectedIndex);
decimal amtPaid = decimal.Parse(amoutPaidTextBox.Text);
if (string.IsNullOrEmpty(customerComboBox.Text))
{
if (MessageBox.Show("No valid customer selected. Do you wish to continue?", "Warning", MessageBoxButtons.YesNo,
MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.No)
{
return;
}
}
int index = customerComboBox.SelectedIndex;
string custId = "";
if (index != -1)
{
custId = customers.ElementAt(index).id;
}
if (!MessagePrompt.displayPrompt("Process Payment", "process payment of the selected stocks"))
{
return;
}
foreach (var data in selectedStocks)
{
sales.Add(new SalesDataModel
{
stockId = data.id,
lastCostPrice = data.lastCostPrice,
soldPrice = data.unitPrice,
date = DateTime.Now
});
}
var receipt = new ReceiptDataModel
{
invoiceNo = InvoicetextBox.Text,
totalPrice = totalPrice,
discount = discount,
amountPayable = amountPayable,
serviceCharge = _serviceCharge,
date = DateTime.Now,
soldItems = sales,
salesRep = saleRep.name,
repId = saleRep.repId,
salesRepId = saleRep.id,
salesType = saleType.title,
salesTypeId = saleType.id,
customerId = custId,
totalAmtPaid = amtPaid
};
await DatabaseOperations.addReceipt(receipt);
Ticket ticket = new Ticket
{
receiptDate = DateTime.Now,
receiptNo = InvoicetextBox.Text,
stocks = selectedStocks,
amountPayable = amountPayable,
serviceCharge = _serviceCharge,
discount = discount,
totalQuantity = selectedStocks.Count,
totalPrice = totalPrice
};
try
{
await ticket.print();
}
catch (Exception e)
{
MessageBox.Show("Receipt could not be printed. Please try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
clear();
InvoicetextBox.Text = GenerateIDs.invoiceId();
}
public IHttpActionResult PK9GetByID(string id)
{
UtilLibs utilLibs = new UtilLibs();
ReceiptDataModel result = new ReceiptDataModel();
DBConnector.DBConnector conn = new DBConnector.DBConnector();
if (conn.OpenConnection())
{
try
{
string sqlString;
if (!string.IsNullOrEmpty(id))
{
sqlString = @"select tb1.*,
tb2.MemberId PayerID, tb2.MemberPreName PreName,
tb2.MemberName Name, tb2.MemberSurname SurName,
tb2.HouseNumber HouseNum, tb2.Soi, tb2.Road,
tb2.Moo, tb2.Building, tb2.Tambon,
tb2.Amphur, tb2.Province, tb2.Zipcode,
tb2.Telephone, tb2.MemberCitizenId CitizenID
from receiptdata tb1, memberdata tb2
where tb1.PayerRunno = tb2.MemberRunno
and tb1.PayerType = '1'
and tb1.DocumentRunno = @DocumentRunno
union
select tb1.*,
tb2.DonatorId PayerID, tb2.DonatorPreName PreName,
tb2.DonatorName Name, tb2.DonatorSurName SurName,
tb2.HouseNumber, tb2.Soi, tb2.Road,
tb2.Moo, tb2.Building, tb2.Tambon,
tb2.Amphur, tb2.Province, tb2.Zipcode,
tb2.Telephone, tb2.DonatorCitizenId CitizenID
from receiptdata tb1, donatordata tb2
where tb1.PayerRunno = tb2.DonatorRunno
and tb1.PayerType = '2'
and tb1.DocumentRunno = @DocumentRunno";
}
else
{
return(Json("Document Number is blank!"));
}
MySqlCommand qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = sqlString
};
qExe.Parameters.AddWithValue("@DocumentRunno", id);
MySqlDataReader dataReader = qExe.ExecuteReader();
while (dataReader.Read())
{
result.DocumentRunno = int.Parse(dataReader["documentrunno"].ToString());
result.DocumentBookNumber = dataReader["documentbooknumber"].ToString();
result.DocumentNumber = dataReader["documentnumber"].ToString();
result.DocumentDate = Convert.ToDateTime(dataReader["documentdate"].ToString(), new CultureInfo("en-US"));
result.PayerType = dataReader["PayerType"].ToString();
result.PayerRunno = int.Parse(dataReader["PayerRunno"].ToString());
result.AsReceiptTo = dataReader["AsReceiptTo"].ToString();
result.AsReceiptToRemark = dataReader["AsReceiptToRemark"].ToString();
result.ReceiptAmount = double.Parse(dataReader["ReceiptAmount"].ToString());
result.HouseNumber = dataReader["HouseNum"].ToString();
result.Soi = dataReader["Soi"].ToString();
result.Road = dataReader["Road"].ToString();
result.Moo = dataReader["Moo"].ToString();
result.Building = dataReader["Building"].ToString();
result.Tambon = dataReader["Tambon"].ToString();
result.Amphur = dataReader["Amphur"].ToString();
result.Province = dataReader["Province"].ToString();
result.Zipcode = dataReader["Zipcode"].ToString();
result.Telephone = dataReader["Telephone"].ToString();
result.PayerId = dataReader["PayerID"].ToString();
result.PayerName = dataReader["PreName"].ToString() + dataReader["Name"].ToString() + " " + dataReader["SurName"].ToString();
result.ReceiptPayType = dataReader["ReceiptPayType"].ToString();
result.ReceiptDate = Convert.ToDateTime(dataReader["ReceiptDate"].ToString(), new CultureInfo("en-US"));
result.ReceiptBank = dataReader["ReceiptBank"].ToString();
result.BankName = utilLibs.GetBankName(dataReader["ReceiptBank"].ToString());
result.ReceiptBillNumber = dataReader["ReceiptBillNumber"].ToString();
result.ReceiptChqBank = dataReader["ReceiptChqBank"].ToString();
result.ReceiptChqNumber = dataReader["ReceiptChqNumber"].ToString();
result.ReceiptOther = dataReader["ReceiptOther"].ToString();
result.CitizenId = dataReader["CitizenID"].ToString();
result.AmountStr = utilLibs.ThaiBaht(dataReader["ReceiptAmount"].ToString());
}
dataReader.Close();
conn.CloseConnection();
return(Json(result));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
else
{
return(BadRequest("Database connect fail!"));
}
}
public IHttpActionResult PK9ListAll()
{
UtilLibs utilLibs = new UtilLibs();
List <ReceiptDataModel> result = new List <ReceiptDataModel>();
DBConnector.DBConnector conn = new DBConnector.DBConnector();
if (conn.OpenConnection())
{
try
{
string sqlString = @"select tb1.*,
tb2.MemberId PayerID, tb2.MemberPreName PreName,
tb2.MemberName Name, tb2.MemberSurname SurName,
tb2.HouseNumber HouseNum, tb2.Soi, tb2.Road,
tb2.Moo, tb2.Building, tb2.Tambon,
tb2.Amphur, tb2.Province, tb2.Zipcode,
tb2.Telephone, tb2.MemberCitizenId CitizenID
from receiptdata tb1, memberdata tb2
where tb1.PayerRunno = tb2.MemberRunno
and tb1.PayerType = '1'
union
select tb1.*,
tb2.DonatorId PayerID, tb2.DonatorPreName PreName,
tb2.DonatorName Name, tb2.DonatorSurName SurName,
tb2.HouseNumber, tb2.Soi, tb2.Road,
tb2.Moo, tb2.Building, tb2.Tambon,
tb2.Amphur, tb2.Province, tb2.Zipcode,
tb2.Telephone, tb2.DonatorCitizenId CitizenID
from receiptdata tb1, donatordata tb2
where tb1.PayerRunno = tb2.DonatorRunno
and tb1.PayerType = '2'
order by DocumentRunno";
/*
* string sqlString = @"select tb1.*, tb2.* from receiptdata tb1, memberdata tb2
* where tb1.PayerRunno = tb2.MemberRunno
* order by tb1.DocumentRunno";
*/
MySqlCommand qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = sqlString
};
MySqlDataReader dataReader = qExe.ExecuteReader();
while (dataReader.Read())
{
ReceiptDataModel detail = new ReceiptDataModel
{
DocumentRunno = int.Parse(dataReader["documentrunno"].ToString()),
DocumentBookNumber = dataReader["documentbooknumber"].ToString(),
DocumentNumber = dataReader["documentnumber"].ToString(),
DocumentDate = Convert.ToDateTime(dataReader["DocumentDate"].ToString(), new CultureInfo("en-US")),
PayerType = dataReader["PayerType"].ToString(),
PayerRunno = int.Parse(dataReader["PayerRunno"].ToString()),
AsReceiptTo = dataReader["AsReceiptTo"].ToString(),
AsReceiptToRemark = dataReader["AsReceiptToRemark"].ToString(),
ReceiptAmount = double.Parse(dataReader["ReceiptAmount"].ToString()),
HouseNumber = dataReader["HouseNum"].ToString(),
Soi = dataReader["Soi"].ToString(),
Road = dataReader["Road"].ToString(),
Moo = dataReader["Moo"].ToString(),
Building = dataReader["Building"].ToString(),
Tambon = dataReader["Tambon"].ToString(),
Amphur = dataReader["Amphur"].ToString(),
Province = dataReader["Province"].ToString(),
Zipcode = dataReader["Zipcode"].ToString(),
Telephone = dataReader["Telephone"].ToString(),
PayerId = dataReader["PayerID"].ToString(),
PayerName = dataReader["PreName"].ToString() + dataReader["Name"].ToString() + " " + dataReader["SurName"].ToString(),
ReceiptPayType = dataReader["ReceiptPayType"].ToString(),
ReceiptDate = Convert.ToDateTime(dataReader["ReceiptDate"].ToString(), new CultureInfo("en-US")),
ReceiptBank = dataReader["ReceiptBank"].ToString(),
BankName = utilLibs.GetBankName(dataReader["ReceiptBank"].ToString()),
ReceiptBillNumber = dataReader["ReceiptBillNumber"].ToString(),
ReceiptChqBank = dataReader["ReceiptChqBank"].ToString(),
ReceiptChqNumber = dataReader["ReceiptChqNumber"].ToString(),
ReceiptOther = dataReader["ReceiptOther"].ToString(),
CitizenId = dataReader["CitizenID"].ToString(),
AmountStr = utilLibs.ThaiBaht(dataReader["ReceiptAmount"].ToString())
};
result.Add(detail);
}
dataReader.Close();
conn.CloseConnection();
return(Json(result));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
else
{
return(BadRequest("Database connect fail!"));
}
}
public static Mock <DataBaseModel> GetDataBaseMock()
{
var Receipts = new ReceiptDataModel[]
{
new ReceiptDataModel {
ReceiptId = 1
},
new ReceiptDataModel {
ReceiptId = 2
},
new ReceiptDataModel {
ReceiptId = 3
}
};
var Shops = new ShopDataModel[]
{
new ShopDataModel {
Name = "shop1",
Location = new Location(0.0, 0.0),
Address = "1600 Pennsylvania Ave SE, Washington, DC 20003, USA",
ShopId = 1,
Receipts = new ReceiptDataModel[] { Receipts[0], Receipts[2] }
},
new ShopDataModel {
Name = "shop2",
Location = new Location(54.6760394, 25.2738736),
Address = "Naugarduko g. 24, Vilnius 03225, Lithuania",
ShopId = 2,
Receipts = new ReceiptDataModel[] { Receipts[1] }
}
};
var Items = new ItemDataModel[]
{
new ItemDataModel {
Name = "item1", ItemId = 1, Price = 1.00m, Category = "category", Receipt = Receipts[0]
},
new ItemDataModel {
Name = "item2", ItemId = 2, Price = 1.00m, Category = "category", Receipt = Receipts[0]
},
new ItemDataModel {
Name = "item3", ItemId = 3, Price = 1.00m, Category = "category", Receipt = Receipts[1]
},
new ItemDataModel {
Name = "item4", ItemId = 4, Price = 1.00m, Category = "category", Receipt = Receipts[1]
},
new ItemDataModel {
Name = "item5", ItemId = 5, Price = 1.00m, Category = "category", Receipt = Receipts[2]
},
new ItemDataModel {
Name = "item6", ItemId = 6, Price = 1.00m, Category = "category", Receipt = Receipts[2]
},
new ItemDataModel {
Name = "item7", ItemId = 7, Price = 1.00m, Category = "category", Receipt = Receipts[2]
},
};
var Users = new UserDataModel[]
{
new UserDataModel()
{
Username = "******", Password = "******", Email = "email1", FullName = "FullName1", Receipts = new ReceiptDataModel[] { Receipts[0], Receipts[1] }
},
new UserDataModel()
{
Username = "******", Password = "******", Email = "email2", FullName = "FullName2", Receipts = new ReceiptDataModel[] { Receipts[2] }
},
};
Receipts[0].Items = new ItemDataModel[] { Items[0], Items[1] };
Receipts[0].Shop = Shops[0];
Receipts[0].User = Users[0];
Receipts[1].Items = new ItemDataModel[] { Items[2], Items[3] };
Receipts[1].Shop = Shops[1];
Receipts[1].User = Users[0];
Receipts[2].Items = new ItemDataModel[] { Items[4], Items[5], Items[6] };
Receipts[2].Shop = Shops[0];
Receipts[2].User = Users[1];
var mockReceipts = MockDbSet <ReceiptDataModel>(Receipts);
var mockItems = MockDbSet <ItemDataModel>(Items);
var mockUsers = MockDbSet <UserDataModel>(Users);
var mockShops = MockDbSet <ShopDataModel>(Shops);
var mockContext = new Mock <DataBaseModel>();
mockContext.Setup(x => x.Set <ReceiptDataModel>()).Returns(mockReceipts.Object);
mockContext.Setup(x => x.Set <ShopDataModel>()).Returns(mockShops.Object);
mockContext.Setup(x => x.Set <ItemDataModel>()).Returns(mockItems.Object);
mockContext.Setup(x => x.Set <UserDataModel>()).Returns(mockUsers.Object);
mockContext.Setup(x => x.Receipt).Returns(mockReceipts.Object);
mockContext.Setup(x => x.Shop).Returns(mockShops.Object);
mockContext.Setup(x => x.Item).Returns(mockItems.Object);
mockContext.Setup(x => x.User).Returns(mockUsers.Object);
return(mockContext);
}
