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 ContactObj select() { string txtQuery = string.Format("SELECT * FROM {0} LIMIT 1", this.tableName); try { ContactObj data = new ContactObj(); using (SQLiteConnection c = new SQLiteConnection(sqlite.ConnectionString)) { c.Open(); using (SQLiteCommand cmd = new SQLiteCommand(txtQuery, c)) { 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.branchId = dr["branch_id"].ToString(); //data.website = dr["website"].ToString(); data.email = dr["email"].ToString(); data.zipCode = dr["zipcode"].ToString(); data.address1 = dr["address1"].ToString(); //data.address2 = dr["address2"].ToString(); data.country = dr["country"].ToString(); data.contactPerson = dr["contact_person"].ToString(); data.phoneNo = dr["phone_no"].ToString(); data.phoneExt = dr["phone_ext"].ToString(); //data.faxNo = dr["fax_no"].ToString(); //data.faxExt = dr["fax_ext"].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; } }
internal int save(ContactObj obj) { int id = 0; string txtQuery = string.Empty; if (obj.id == 0) { txtQuery = string.Format("INSERT INTO {0} (name,tax_id,branch_id,email,zipcode,address1,country,contact_person,phone_no,phone_ext" + ",province_name,province_code,district_name,district_code,subdistrict_name,subdistrict_code,house_no,tax_type) VALUES ", this.tableName); string values = string.Format("(@name,@tax_id,@branch_id,@email,@zipcode,@address1,@country,@contact_person,@phone_no,@phone_ext" + ",@province_name,@province_code,@district_name,@district_code,@subdistrict_name,@subdistrict_code,@house_no,@tax_type)"); txtQuery = txtQuery + values; } else { txtQuery = string.Format("UPDATE {0} SET ", this.tableName); string values = string.Format("name=@name,tax_id=@tax_id,branch_id=@branch_id,email=@email,zipcode=@zipcode,address1=@address1" + ",country=@country,contact_person=@contact_person,phone_no=@phone_no,phone_ext=@phone_ext" + ",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,tax_type=@tax_type"); 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("@tax_type", obj.taxType); cmd.Parameters.AddWithValue("@branch_id", obj.branchId); cmd.Parameters.AddWithValue("@email", obj.email); cmd.Parameters.AddWithValue("@zipcode", obj.zipCode); cmd.Parameters.AddWithValue("@address1", obj.address1); cmd.Parameters.AddWithValue("@country", obj.country); cmd.Parameters.AddWithValue("@contact_person", obj.contactPerson); cmd.Parameters.AddWithValue("@phone_no", obj.phoneNo); cmd.Parameters.AddWithValue("@phone_ext", obj.phoneExt); 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; } } string getLastId = "SELECT last_insert_rowid()"; using (SQLiteCommand cmd = new SQLiteCommand(getLastId, c)) { id = Convert.ToInt32(cmd.ExecuteScalar()); } } return(id); }