internal void save(BuyerObj obj)
{
string txtQuery = string.Empty;
if (obj.id == 0)
{
txtQuery = string.Format("INSERT INTO {0} (name,tax_id,phone_no,phone_ext,zipcode,address1,email,contact_person,is_branch,branch_id"
+ ",province_name,province_code,district_name,district_code,subdistrict_name,subdistrict_code,house_no) VALUES ", this.tableName);
string values = string.Format("(@name,@tax_id,@phone_no,@phone_ext,@zipcode,@address1,@email,@contact_person,@is_branch,@branch_id"
+ ",@province_name,@province_code,@district_name,@district_code,@subdistrict_name,@subdistrict_code,@house_no)");
txtQuery = txtQuery + values;
}
else
{
txtQuery = string.Format("UPDATE {0} SET ", this.tableName);
string values = string.Format("name=@name,tax_id=@tax_id,phone_no=@phone_no,phone_ext=@phone_ext,zipcode=@zipcode,address1=@address1"
+ ",email=@email,contact_person=@contact_person,is_branch=@is_branch,branch_id=@branch_id"
+ ",province_name=@province_name,province_code=@province_code,district_name=@district_name,district_code=@district_code"
+ ",subdistrict_name=@subdistrict_name,subdistrict_code=@subdistrict_code,house_no=@house_no ");
string condition = string.Format("WHERE id=@id");
txtQuery = txtQuery + values + condition;
}
using (SQLiteConnection c = new SQLiteConnection(sqlite.ConnectionString))
{
c.Open();
using (SQLiteCommand cmd = new SQLiteCommand(txtQuery, c))
{
cmd.Parameters.AddWithValue("@name", obj.name);
cmd.Parameters.AddWithValue("@tax_id", obj.taxId);
cmd.Parameters.AddWithValue("@phone_no", obj.phoneNo);
cmd.Parameters.AddWithValue("@phone_ext", obj.phoneExt);
cmd.Parameters.AddWithValue("@zipcode", obj.zipCode);
cmd.Parameters.AddWithValue("@address1", obj.address1);
cmd.Parameters.AddWithValue("@email", obj.email);
cmd.Parameters.AddWithValue("@contact_person", obj.contactPerson);
cmd.Parameters.AddWithValue("@is_branch", (obj.isBranch) ? 1 : 0);
cmd.Parameters.AddWithValue("@branch_id", obj.branchId);
cmd.Parameters.AddWithValue("@province_name", obj.provinceName);
cmd.Parameters.AddWithValue("@province_code", obj.provinceCode);
cmd.Parameters.AddWithValue("@district_name", obj.districtName);
cmd.Parameters.AddWithValue("@district_code", obj.districtCode);
cmd.Parameters.AddWithValue("@subdistrict_name", obj.subdistrictName);
cmd.Parameters.AddWithValue("@subdistrict_code", obj.subdistrcitCode);
cmd.Parameters.AddWithValue("@house_no", obj.houseNo);
if (obj.id != 0)
{
cmd.Parameters.AddWithValue("@id", obj.id);
}
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
}
}
}
private int saveContact(BuyerObj obj)
{
ContactObj contact = new ContactObj();
contact.name = obj.name;
contact.taxId = obj.taxId;
contact.taxType = obj.taxType;
contact.branchId = obj.branchId;
contact.email = obj.email;
contact.zipCode = obj.zipCode;
contact.address1 = obj.address1;
contact.country = "TH";
contact.phoneNo = obj.phoneNo;
contact.phoneExt = obj.phoneExt;
contact.contactPerson = obj.contactPerson;
contact.provinceCode = obj.provinceCode;
contact.provinceName = obj.provinceName;
contact.districtCode = obj.districtCode;
contact.districtName = obj.districtName;
contact.subdistrcitCode = obj.subdistrcitCode;
contact.subdistrictName = obj.subdistrictName;
contact.houseNo = obj.houseNo;
return(new ContactDao().save(contact));
}
internal List <BuyerObj> list()
{
string txtQuery = string.Format("SELECT * FROM {0}", this.tableName);
try
{
List <BuyerObj> items = new List <BuyerObj>();
using (SQLiteConnection c = new SQLiteConnection(sqlite.ConnectionString))
{
c.Open();
using (SQLiteCommand cmd = new SQLiteCommand(txtQuery, c))
{
using (SQLiteDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
BuyerObj obj = new BuyerObj();
obj.id = Convert.ToInt32(dr["id"]);
obj.name = dr["name"].ToString();
obj.address1 = dr["address1"].ToString();
//obj.address2 = dr["address2"].ToString();
obj.zipCode = dr["zipcode"].ToString();
obj.taxId = dr["tax_id"].ToString();
obj.isBranch = Convert.ToBoolean(dr["is_branch"]);
obj.branchId = dr["branch_id"].ToString();
//obj.website = dr["website"].ToString();
obj.email = dr["email"].ToString();
obj.contactPerson = dr["contact_person"].ToString();
obj.phoneNo = dr["phone_no"].ToString();
obj.phoneExt = dr["phone_ext"].ToString();
//obj.faxNo = dr["fax_no"].ToString();
//obj.faxExt = dr["fax_ext"].ToString();
obj.provinceCode = dr["province_code"].ToString();
obj.provinceName = dr["province_name"].ToString();
obj.districtCode = dr["district_code"].ToString();
obj.districtName = dr["district_name"].ToString();
obj.subdistrcitCode = dr["subdistrict_code"].ToString();
obj.subdistrictName = dr["subdistrict_name"].ToString();
obj.houseNo = dr["house_no"].ToString();
items.Add(obj);
}
}
}
}
return(items);
}
catch (Exception ex)
{
throw ex;
}
}
internal BuyerObj select(int id)
{
string txtQuery = string.Format("SELECT * FROM {0} WHERE id = @id", this.tableName);
try
{
BuyerObj data = new BuyerObj();
using (SQLiteConnection c = new SQLiteConnection(sqlite.ConnectionString))
{
c.Open();
using (SQLiteCommand cmd = new SQLiteCommand(txtQuery, c))
{
cmd.Parameters.AddWithValue("@id", id);
using (SQLiteDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
data.id = Convert.ToInt32(dr["id"]);
data.name = dr["name"].ToString();
data.taxId = dr["tax_id"].ToString();
data.phoneNo = dr["phone_no"].ToString();
data.phoneExt = dr["phone_ext"].ToString();
data.zipCode = dr["zipcode"].ToString();
data.address1 = dr["address1"].ToString();
//data.address2 = dr["address2"].ToString();
data.email = dr["email"].ToString();
//data.website = dr["website"].ToString();
data.contactPerson = dr["contact_person"].ToString();
//data.faxNo = dr["fax_no"].ToString();
//data.faxExt = dr["fax_ext"].ToString();
data.isBranch = Convert.ToBoolean(dr["is_branch"]);
data.branchId = dr["branch_id"].ToString();
data.provinceName = dr["province_name"].ToString();
data.provinceCode = dr["province_code"].ToString();
data.districtName = dr["district_name"].ToString();
data.districtCode = dr["district_code"].ToString();
data.subdistrictName = dr["subdistrict_name"].ToString();
data.subdistrcitCode = dr["subdistrict_code"].ToString();
data.houseNo = dr["house_no"].ToString();
}
}
}
}
return(data);
}
catch (Exception ex)
{
throw ex;
}
}
private bool saveData()
{
try
{
validateData();
BuyerObj obj = new BuyerObj();
obj.id = this.id;
obj.name = nameTb.Text;
obj.taxType = getTaxTypeSchemaID(taxIdType.SelectedIndex);
obj.address1 = address1Tb.Text;
obj.houseNo = houseNoTb.Text;
obj.zipCode = zipcodeTb.Text;
obj.taxId = taxIdTb.Text;
if (is_branch.IsChecked.Value)
{
obj.isBranch = true;
obj.branchId = branchNoTb.Text;
}
else
{
obj.isBranch = false;
obj.branchId = "00000";
}
obj.email = emailTb.Text;
obj.contactPerson = contactTb.Text;
obj.phoneNo = phoneNoTb.Text;
obj.phoneExt = phoneExtTb.Text;
obj.provinceCode = ((AddressCodeListObj)provinceCbb.SelectedItem).code.Substring(0, 2);
obj.provinceName = ((AddressCodeListObj)provinceCbb.SelectedItem).changwat_th;
obj.districtCode = ((AddressCodeListObj)districtCbb.SelectedItem).code.Substring(0, 4);
obj.districtName = ((AddressCodeListObj)districtCbb.SelectedItem).amphoe_th;
obj.subdistrcitCode = ((AddressCodeListObj)subDistrictCbb.SelectedItem).code.Substring(0, 6);
obj.subdistrictName = ((AddressCodeListObj)subDistrictCbb.SelectedItem).tambon_th;
new BuyerDao().save(obj);
new AlertBox("บันทึกข้อมูลผู้ซื้อเรียบร้อยแล้ว").ShowDialog();
this.Close();
return(true);
}
catch (Exception ex)
{
new AlertBox(ex.Message).ShowDialog();
return(false);
}
}
private void showData(BuyerObj obj)
{
try
{
taxIdType.SelectedIndex = getTaxTypeSchemaIndex(obj.taxType);
nameCbb.SelectedItem = obj;
address1Tb.Text = obj.address1;
houseNoTb.Text = obj.houseNo;
zipcodeTb.Text = obj.zipCode;
taxIdTb.Text = obj.taxId;
this.taxType = obj.taxType;
if (obj.isBranch)
{
is_branch.IsChecked = true;
branchNoTb.Text = obj.branchId;
}
if (obj.isBranch == false && obj.taxType == "TXID")
{
is_main.IsChecked = true;
}
emailTb.Text = obj.email;
contactTb.Text = obj.contactPerson;
phoneExtTb.Text = ""; phoneNoTb.Text = "";
phoneNoTb.Text = obj.phoneNo;
phoneExtTb.Text = obj.phoneExt;
if (obj.provinceCode != null && obj.provinceCode != "")
{
provinceCbb.SelectedValue = obj.provinceCode + "000000";
if (obj.districtCode != null && obj.districtCode != "")
{
districtCbb.SelectedValue = obj.districtCode + "0000";
if (obj.subdistrcitCode != null && obj.subdistrcitCode != "")
{
subDistrictCbb.SelectedValue = obj.subdistrcitCode + "00";
}
}
}
nameCbb.Focus();
}
catch (Exception ex)
{
new AlertBox(ex.Message).ShowDialog();
}
}
private void showData(BuyerObj obj)
{
try
{
nameCbb.SelectedItem = obj;
address1Tb.Text = obj.address1;
houseNoTb.Text = obj.houseNo;
zipcodeTb.Text = obj.zipCode;
taxIdTb.Text = obj.taxId;
if (obj.isBranch)
{
is_branch.IsChecked = true;
branchNoTb.Text = obj.branchId;
}
else
{
is_main.IsChecked = true;
}
emailTb.Text = obj.email;
contactTb.Text = obj.contactPerson;
phoneExtTb.Text = ""; phoneNoTb.Text = "";
phoneNoTb.Text = obj.phoneNo;
phoneExtTb.Text = obj.phoneExt;
if (obj.provinceCode != null && obj.provinceCode != "")
{
provinceCbb.SelectedValue = obj.provinceCode + "000000";
if (obj.districtCode != null && obj.districtCode != "")
{
amphoeCbb.SelectedValue = obj.districtCode + "0000";
if (obj.subdistrcitCode != null && obj.subdistrcitCode != "")
{
tambonCbb.SelectedValue = obj.subdistrcitCode + "00";
}
}
}
nameCbb.Focus();
}
catch (Exception ex)
{
new AlertBox(ex.Message).ShowDialog();
}
}
private bool saveData()
{
try
{
setRef1();
validateData();
bool isNew = false;
InvoiceObj obj = new InvoiceDao().find(this.invoiceID);
if (obj == null)
{
obj = new InvoiceObj();
obj.invoiceId = this.invoiceID;
isNew = true;
}
obj.invoiceName = INVOICE_NAME;
if (purposeCbb.SelectedValue.ToString() == "DBNG99" || purposeCbb.SelectedValue.ToString() == "DBNS99")
{
obj.purpose = otherPurposeTb.Text;
}
else
{
obj.purpose = purposeCbb.Text;
}
obj.purposeCode = purposeCbb.SelectedValue.ToString();
obj.taxCode = "VAT";
obj.taxRate = Convert.ToDouble(vatTb.Text);
obj.lineTotal = Convert.ToDouble(lineTotalTb.Text);
obj.discount = 0.0;
obj.taxTotal = Convert.ToDouble(taxTotalTb.Text);
obj.grandTotal = Convert.ToDouble(grandTotalTb.Text);
obj.remark = remarkTb.Text;
obj.difference = Convert.ToDouble(diffValueTb.Text);
obj.basisAmount = obj.difference;
obj.original = Convert.ToDouble(originalValueTotal.Text);
obj.issueDate = DateTime.Now.ToString("dd/MM/yyyy", new System.Globalization.CultureInfo("en-US"));
BuyerObj buyer = (BuyerObj)nameCbb.SelectedItem;
if (buyer == null)
{
buyer = new BuyerObj();
}
buyer.name = nameCbb.Text;
buyer.address1 = address1Tb.Text;
buyer.houseNo = houseNoTb.Text;
buyer.zipCode = zipcodeTb.Text;
buyer.taxId = taxIdTb.Text;
buyer.taxType = getTaxTypeSchemaID(taxIdType.SelectedIndex);
if (is_branch.IsChecked.Value)
{
buyer.isBranch = true;
buyer.branchId = branchNoTb.Text;
}
else
{
buyer.isBranch = false;
buyer.branchId = "00000";
}
buyer.email = emailTb.Text;
buyer.contactPerson = contactTb.Text;
buyer.phoneNo = phoneNoTb.Text;
buyer.phoneExt = phoneExtTb.Text;
buyer.provinceCode = ((AddressCodeListObj)provinceCbb.SelectedItem).code.Substring(0, 2);
buyer.provinceName = ((AddressCodeListObj)provinceCbb.SelectedItem).changwat_th;
buyer.districtCode = ((AddressCodeListObj)districtCbb.SelectedItem).code.Substring(0, 4);
buyer.districtName = ((AddressCodeListObj)districtCbb.SelectedItem).amphoe_th;
buyer.subdistrcitCode = ((AddressCodeListObj)subDistrictCbb.SelectedItem).code.Substring(0, 6);
buyer.subdistrictName = ((AddressCodeListObj)subDistrictCbb.SelectedItem).tambon_th;
obj.sellerId = saveContact(seller);
obj.buyerId = saveContact(buyer);
saveReferece();
saveInvoiceItem();
new InvoiceDao().save(obj, isNew);
return(true);
}
catch (Exception ex)
{
createBtn.IsEnabled = true;
new AlertBox(ex.Message).ShowDialog();
return(false);
}
}
private bool saveData()
{
try
{
setRef1();
validateData();
bool isNew = false;
InvoiceObj obj = new InvoiceDao().find(this.invoiceID);
if (obj == null)
{
obj = new InvoiceObj();
obj.invoiceId = this.invoiceID;
isNew = true;
}
if (is_replace.IsChecked.Value)
{
obj.purpose = purposeCbb.Text;
obj.issueDate = docDateTb.Text;
obj.purposeCode = purposeCbb.SelectedValue.ToString();
if (purposeCbb.SelectedValue.ToString() == "TIVC99")
{
obj.purpose = otherPurposeTb.Text;
}
else
{
obj.purpose = purposeCbb.Text;
}
}
else
{
obj.issueDate = DateTime.Now.ToString("dd/MM/yyyy", new CultureInfo("en-US"));
}
obj.invoiceName = "ใบกำกับภาษี";
obj.taxCode = "VAT";
obj.taxRate = Convert.ToDouble(vatTb.Text);
obj.basisAmount = Convert.ToDouble(basisAmountTb.Text);
obj.lineTotal = Convert.ToDouble(lineTotalTb.Text);
obj.discount = Convert.ToDouble(extraDiscountTb.Text);
obj.discount_rate = Convert.ToDouble(extraDiscountRateTb.Text);
obj.taxTotal = Convert.ToDouble(taxTotalTb.Text);
obj.grandTotal = Convert.ToDouble(grandTotalTb.Text);
obj.service_charge = Convert.ToDouble(serviceChargeTb.Text);
obj.service_charge_rate = Convert.ToDouble(serviceChargeRateTb.Text);
//obj.issueDate = DateTime.Now.ToString();
obj.remark = remarkTb.Text;
BuyerObj buyer = (BuyerObj)nameCbb.SelectedItem;
if (buyer == null)
{
buyer = new BuyerObj();
}
buyer.name = nameCbb.Text;
buyer.address1 = address1Tb.Text;
buyer.houseNo = houseNoTb.Text;
buyer.zipCode = zipcodeTb.Text;
buyer.taxId = taxIdTb.Text;
if (is_branch.IsChecked.Value)
{
buyer.isBranch = true;
buyer.branchId = branchNoTb.Text;
}
else
{
buyer.isBranch = false;
buyer.branchId = "00000";
}
buyer.email = emailTb.Text;
buyer.contactPerson = contactTb.Text;
buyer.phoneNo = phoneNoTb.Text;
buyer.phoneExt = phoneExtTb.Text;
buyer.provinceCode = ((AddressCodeListObj)provinceCbb.SelectedItem).code.Substring(0, 2);
buyer.provinceName = ((AddressCodeListObj)provinceCbb.SelectedItem).changwat_th;
buyer.districtCode = ((AddressCodeListObj)amphoeCbb.SelectedItem).code.Substring(0, 4);
buyer.districtName = ((AddressCodeListObj)amphoeCbb.SelectedItem).amphoe_th;
buyer.subdistrcitCode = ((AddressCodeListObj)tambonCbb.SelectedItem).code.Substring(0, 6);
buyer.subdistrictName = ((AddressCodeListObj)tambonCbb.SelectedItem).tambon_th;
obj.sellerId = saveContact(seller);
obj.buyerId = saveContact(buyer);
saveReferece();
saveInvoiceItem();
new InvoiceDao().save(obj, isNew);
return(true);
}
catch (Exception ex)
{
createBtn.IsEnabled = true;
new AlertBox(ex.Message).ShowDialog();
return(false);
}
}
