public AgentParty()
{
PartyIdentification = new PartyIdentification();
PartyName = new PartyName();
PostalAddress = new PostalAddress();
PartyLegalEntity = new PartyLegalEntity();
}
/// <summary>
/// The function updates the party details.
/// </summary>
/// <returns></returns> Returns if the update succseed or not
public string UpdateParty()
{
con.sqlCommand("UpdatePartyDetails");
con.InsertValstring("@partyName", PartyName.Trim());
con.InsertValint("@member_size", membersSize);
con.InsertValstring("@platform", platform.Trim());
return(con.getVal("@Result"));
}
public string UpdateMemberParty()
{
con.sqlCommand("UpdateMemberParty");
con.InsertValint("@member_code", MemberCode);
con.InsertValstring("@party_name", PartyName.Trim());
con.InsertValstring("@f_name", FName.Trim());
con.InsertValstring("@l_name", LName.Trim());
con.InsertValstring("@birth_date", GetDob().ToString());
con.InsertValint("@list_place", ListPlace);
con.InsertValstring("@education", Education.Trim());
con.InsertValstring("@experience", Experience.Trim());
return(con.getVal("@Result").ToString());
}
/// <summary>
/// Gets the hash code
/// </summary>
/// <returns>Hash code</returns>
public override int GetHashCode()
{
unchecked // Overflow is fine, just wrap
{
var hashCode = 41;
// Suitable nullity checks etc, of course :)
if (PartyName != null)
{
hashCode = hashCode * 59 + PartyName.GetHashCode();
}
if (Email != null)
{
hashCode = hashCode * 59 + Email.GetHashCode();
}
return(hashCode);
}
}
/// <summary>
/// Returns true if InboxesCreateRequest instances are equal
/// </summary>
/// <param name="other">Instance of InboxesCreateRequest to be compared</param>
/// <returns>Boolean</returns>
public bool Equals(InboxesCreateRequest other)
{
if (other is null)
{
return(false);
}
if (ReferenceEquals(this, other))
{
return(true);
}
return
((
PartyName == other.PartyName ||
PartyName != null &&
PartyName.Equals(other.PartyName)
) &&
(
Email == other.Email ||
Email != null &&
Email.Equals(other.Email)
));
}
public SignatoryParty()
{
PartyIdentification = new PartyIdentification();
PartyName = new PartyName();
}
public void UpdateInvoiceMaster()
{
string FilePath = @"D:\DONT DELETE\Desktop\Invoietoday\invoice (188).xlsx";
string con = @"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + FilePath + ";Extended Properties ='Excel 8.0;HDR=Yes';";
using (OleDbConnection OleDbCon = new OleDbConnection(con))
{
OleDbCon.Open();
OleDbCommand oleDbCommand = new OleDbCommand("Select * From [Invoicing$]", OleDbCon);
OleDbDataReader dr = oleDbCommand.ExecuteReader();
SqlConnection sqlCon = new SqlConnection(GetConnectionString());
while (dr.Read())
{
int invoiceNo = 0;
string orderID = string.Empty;
DateTime invoiceDate = new DateTime();
string productID = "";
string ErrorMsg = string.Empty;
int Result = 0;
int quantity = 0;
decimal rate = 0M, unitPrice = 0M, netSales = 0M, total = 0.00M;
decimal CST = 0.00M, VAT = 0.00M, ShippingHandling = 0.00M;
DateTime orderDate = new DateTime();
string TaxGroup = string.Empty, PartyName, Address, EmailID, MobNo, Vendor;
orderID = Converter.ToString(dr["Order ID"].ToString());
if (string.IsNullOrEmpty(orderID))
{
continue;
}
productID = Converter.ToString(dr["SKU"]).ToUpper();
quantity = Converter.ToInt(dr["Quantity"]);
rate = Converter.ToDecimal(dr["Rate"]);
//TaxGroup = Converter.ToString(dr["Tax Group"]);
PartyName = Converter.ToString(dr["Party's Name"]);
Address = Converter.ToString(dr["Address"]);
EmailID = Converter.ToString(dr["Email ID"]);
MobNo = Converter.ToString(dr["Mobile No"]);
ShippingHandling = Math.Round((Converter.ToDecimal(dr["Shipping & Handling"])), 2);
//Vendor = Converter.ToString(dr["Sales Group"]);
netSales = unitPrice * quantity;
total = (rate * quantity) + Math.Round((Converter.ToDecimal(dr["Shipping & Handling"])), 2);
string query = "Update InvoiceMaster Set";
if (!string.IsNullOrEmpty(PartyName))
{
query += " PartyName = '" + PartyName.Replace("'", "''") + "'";
}
if (!string.IsNullOrEmpty(Address))
{
query += " Address = '" + Address.Replace("'", "''") + "'";
}
if (!string.IsNullOrEmpty(EmailID))
{
query += " EmailID = '" + PartyName + "'";
}
if (!string.IsNullOrEmpty(MobNo))
{
query += " MobilNo = '" + MobNo + "'";
}
if (quantity > 0)
{
query += " Quantity = " + quantity;
}
if (ShippingHandling > 0)
{
query += " PackagingAndForwarding = " + ShippingHandling;
}
int DbQuantity = 0;
decimal DbCST = 0M;
decimal DbShippingHandling = 0M;
SqlCommand cmd = null;
if (rate > 0 || quantity > 0)
{
cmd = new SqlCommand("Select CST, Quantity From InvoiceMaster Where OrderID = '" + orderID + "' ProductID = '" + productID + "'");
using (SqlDataReader dr1 = cmd.ExecuteReader())
{
if (dr1.HasRows)
{
while (dr1.Read())
{
DbCST = Convert.ToDecimal(dr["CST"]);
DbQuantity = Convert.ToInt32(dr["Quantity"]);
if (DbCST > 0)
{
TaxGroup = "CST";
}
break;
}
}
}
if (quantity == 0)
{
quantity = DbQuantity;
}
decimal VatCstRate = 0M;
if (TaxGroup == "CST")
{
VatCstRate = FindVatCstRate(productID, false) + 100;
unitPrice = Math.Round(((rate / VatCstRate) * 100), 2);
CST = (rate - unitPrice) * quantity;
}
else
{
VatCstRate = FindVatCstRate(productID, true) + 100;
unitPrice = Math.Round(((rate / VatCstRate) * 100), 2);
VAT = (rate - unitPrice) * quantity;
}
netSales = unitPrice * quantity;
if (ShippingHandling == 0)
{
ShippingHandling = DbShippingHandling;
}
total = (rate * quantity) + ShippingHandling;
query += " Rate = " + rate + ", UnitPrice = " + unitPrice + ",NetSale=" + netSales + ", VAT=" + VAT + ", CST=" + CST + ", Total=" + total;
}
query += " Where ProductID = '" + productID + "' And OrderID = '" + orderID + "'";
cmd = new SqlCommand(query, sqlCon);
}
}
}
public Party()
{
PartyName = new PartyName();
PostalAddress = new PostalAddress();
PartyLegalEntity = new PartyLegalEntity();
}
