public override void FillTheTable(AmbleClient.OfferGui.OfferMgr.Offer offer)
{
offerId = offer.offerId;
base.FillTheTable(offer);
tbVendorName.Text = offer.vendorName;
tbContact.Text = offer.contact;
tbPhone.Text = offer.phone;
tbFax.Text = offer.fax;
tbEmail.Text = offer.email;
}
public Offer GetValue()
{
Offer offer = new Offer();
offer.mpn = tbMpn.Text.Trim();
offer.mfg = tbMfg.Text.Trim();
offer.vendorName = tbVendorName.Text.Trim();
offer.contact = tbContact.Text.Trim();
offer.phone = tbPhone.Text.Trim();
offer.fax = tbFax.Text.Trim();
offer.email = tbEmail.Text.Trim();
if (string.IsNullOrWhiteSpace(tbQuantity.Text.Trim()))
{
offer.amount = null;
}
else
{
offer.amount = int.Parse(tbQuantity.Text.Trim());
}
if (string.IsNullOrWhiteSpace(tbPrice.Text.Trim()))
{
offer.price = null;
}
else
{
offer.price = float.Parse(tbPrice.Text.Trim());
}
if (string.IsNullOrWhiteSpace(tbDeliverTime.Text.Trim()))
{
offer.deliverTime = null;
}
else
{
offer.deliverTime = int.Parse(tbDeliverTime.Text.Trim());
}
offer.timeUnit = cbTimeUnit.SelectedIndex;
offer.buyerId = UserInfo.UserId;
offer.offerDate = DateTime.Now;
offer.offerStates = 0;//new
offer.notes = tbNotes.Text.Trim();
return offer;
}
public Offer GetValue()
{
Offer offer = new Offer();
offer.mpn = tbMpn.Text.Trim().ToUpper();
offer.mfg = tbMfg.Text.Trim().ToUpper();
offer.vendorName = tbVendorName.Text.Trim();
offer.contact = tbContact.Text.Trim();
offer.phone = tbPhone.Text.Trim();
offer.fax = tbFax.Text.Trim();
offer.email = tbEmail.Text.Trim();
offer.packing = tbPacking.Text.Trim();
offer.quantity = int.Parse(tbQuantity.Text.Trim());
offer.price = float.Parse(tbPrice.Text.Trim());
offer.LT = tbDeliverTime.Text.Trim();
offer.buyerId = UserInfo.UserId;
offer.offerDate = DateTime.Now;
offer.offerStates = 0;//new
offer.notes = tbNotes.Text.Trim();
return offer;
}
public static void UpdateOffer(Offer offer)
{
string strSql = string.Format("update offer set mpn='{0}',mfg='{1}',vendorName='{2}',contact='{3}',phone='{4}',fax='{5}',email='{6}',quantity={7},price={8},LT='{9}',buyerId={10},notes='{11}',packing='{12}', where offerId={13} ",
offer.mpn, offer.mfg, offer.vendorName, offer.contact,offer.phone, offer.fax, offer.email, offer.quantity, offer.price, offer.LT,offer.buyerId, offer.notes,offer.packing,offer.offerId);
db.ExecDataBySql(strSql);
}
public static bool SaveOffer(Offer offer)
{
string strSql = "insert into offer(rfqNo,mpn,mfg,vendorName,contact,phone,fax,email,quantity,price,LT,buyerId,offerDate,offerStates,notes,packing) " +
string.Format(" values({0},'{1}','{2}','{3}','{4}','{5}','{6}','{7}',{8},{9},'{10}',{11},'{12}',{13},'{14}','{15}')", offer.rfqNo, offer.mpn, offer.mfg, offer.vendorName, offer.contact,
offer.phone, offer.fax, offer.email, offer.quantity, offer.price, offer.LT,offer.buyerId, offer.offerDate.ToShortDateString(), offer.offerStates,offer.notes,offer.packing);
int row = db.ExecDataBySql(strSql);
if (row == 1)
return true;
else
return false;
}
public void UpdateOffer(Offer offer)
{
string strSql = string.Format("update offer set mpn='{0}',mfg='{1}',vendorName='{2}',contact='{3}',phone='{4}',fax='{5}',email='{6}',amount={7},price={8},deliverTime='{9}',timeUnit={10},buyerId={11},notes='{12}' where offerId={13} ",
offer.mpn, offer.mfg, offer.vendorName, offer.contact,offer.phone, offer.fax, offer.email, offer.amount.HasValue ? offer.amount.Value.ToString() : "null", offer.price.HasValue ? offer.price.ToString() : "null", offer.deliverTime.HasValue ? offer.deliverTime.Value.ToString() : "null", offer.timeUnit, offer.buyerId, offer.notes,offer.offerId);
db.ExecDataBySql(strSql);
}
public bool SaveOffer(Offer offer)
{
string strSql = "insert into offer(rfqNo,mpn,mfg,vendorName,contact,phone,fax,email,amount,price,deliverTime,timeUnit,buyerId,offerDate,offerStates,notes) " +
string.Format(" values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}',{9},{10},{11},{12},'{13}',{14})", offer.rfqNo, offer.mpn, offer.mfg, offer.vendorName, offer.contact,
offer.phone, offer.fax, offer.email, offer.amount.HasValue?offer.amount.Value.ToString():"null", offer.price.HasValue?offer.price.ToString():"null", offer.deliverTime.HasValue? offer.deliverTime.Value.ToString():"null", offer.timeUnit, offer.buyerId, offer.offerDate.ToShortDateString(), offer.offerStates,offer.notes);
int row = db.ExecDataBySql(strSql);
if (row == 1)
return true;
else
return false;
}
public virtual void FillTheTable(Offer offer)
{
this.tbMpn.Text = offer.mpn;
this.tbMfg.Text = offer.mfg;
this.tbQuantity.Text = offer.quantity.ToString();
this.tbPrice.Text = offer.price.ToString();
this.tbDeliverTime.Text = offer.LT;
this.tbPacking.Text = offer.packing;
this.tbOfferDate.Text = offer.offerDate.ToShortDateString();
this.tbOfferState.Text = Enum.GetName(typeof(OfferState), (OfferState)offer.offerStates); //(offer.offerStates == 0 ? "New" : "Routed");
this.tbNotes.Text = offer.notes;
}
