public string GetExistBillingDetails(int ItemNo, string BillNo, out BillingDataTypes.BillingDetailsDataType _ExistData) { _ExistData = new BillingDataTypes.BillingDetailsDataType(); MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Select " + "ItemNo," + "BillNo," + "AccID," + "Description," + "Dr," + "Fdr," + "TrRef," + "Vat" + " from tblpayablebilldetails" + " Where 1=1 " + " and ItemNo=@ItemNo" + " and BillNo=@BillNo"; oSqlCommand.Parameters.AddWithValue("@ItemNo", ItemNo); oSqlCommand.Parameters.AddWithValue("@BillNo", BillNo); DataRow r = Mycommon.GetDataRowAccount(sqlQuery, oSqlCommand, "Get Exist data BillingDetails"); if (r != null) { try { bool resp = false; int inItemNo = 0; resp = int.TryParse(r["ItemNo"].ToString(), out inItemNo); _ExistData.ItemNo = inItemNo; _ExistData.BillNo = r["BillNo"].ToString(); _ExistData.AccID = r["AccID"].ToString(); _ExistData.Description = r["Description"].ToString(); decimal deDr = 0; resp = decimal.TryParse(r["Dr"].ToString(), out deDr); _ExistData.Dr = deDr; decimal deFdr = 0; resp = decimal.TryParse(r["Fdr"].ToString(), out deFdr); _ExistData.Fdr = deFdr; _ExistData.TrRef = r["TrRef"].ToString(); decimal deVat = 0; resp = decimal.TryParse(r["Vat"].ToString(), out deVat); _ExistData.Vat = deVat; return "True"; } catch (Exception ex) { return ex.Message; } } else return "data not found "; }
private string SetPayBillDetails(out List < BillingDataTypes.BillingDetailsDataType> _SaveDetails) { _SaveDetails = new List<BillingDataTypes.BillingDetailsDataType>(); try { foreach (DataGridViewRow r in dgvAccount.Rows) { decimal LKR = 0, vat = 0,USD=0; bool resp = decimal.TryParse(r.Cells["dgvAccount_Amount"].Value.ToString(), out LKR); resp = decimal.TryParse(r.Cells["dgvAccount_Fcr"].Value.ToString(), out USD); resp = decimal.TryParse(r.Cells["dgvAccount_VAT"].Value.ToString(), out vat); BillingDataTypes.BillingDetailsDataType _OneItem = new BillingDataTypes.BillingDetailsDataType(); _OneItem.AccID = r.Cells["dgvAccount_ID"].Value.ToString(); _OneItem.BillNo = cmbGRN.Text; _OneItem.Description = r.Cells["dgvAccount_Memo"].Value.ToString(); _OneItem.Dr = LKR; _OneItem.Fdr = USD; _OneItem.ItemNo = int.Parse(r.Cells["dgvAccount_LineRef"].Value.ToString()); _OneItem.Vat = vat; _SaveDetails.Add(_OneItem); } return "True"; } catch (Exception ex) { return ex.Message; } }
public string GetBillingDetaisList(string Invoice,out List <BillingDataTypes.BillingDetailsDataType> _ExtList) { _ExtList = new List<BillingDataTypes.BillingDetailsDataType>(); string sql1 = "Select ItemNo,BillNo from tblpayablebilldetails where BillNo='" + Invoice + "'"; DataTable tb = Mycommon.GetDataTableAccount(sql1, "get bill details list"); foreach (DataRow item in tb.Rows ) { BillingDataTypes.BillingDetailsDataType _OneItem = new BillingDataTypes.BillingDetailsDataType(); string respond = GetExistBillingDetails(int.Parse( item["ItemNo"].ToString()), Invoice, out _OneItem); if (respond == "True") _ExtList.Add(_OneItem); else return respond; } return "True"; }