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";
}
