public string GetInvoiceDetailList(string InvoiceNO, out List<InvoiceDataTypes.InvoiceDetailsDataType> _ExistDataList)
{
_ExistDataList = new List<InvoiceDataTypes.InvoiceDetailsDataType>();
try
{
MySqlCommand oSqlCommand = new MySqlCommand();
string sqlQuery = "Select ItemNo, InvoiceNO from tblrecievebleinvoicedetails"
+ " Where 1=1 "
+ " and InvoiceNO=@InvoiceNO";
oSqlCommand.Parameters.AddWithValue("@InvoiceNO", InvoiceNO);
DataTable tb = Mycommon.GetDataTableAccount(sqlQuery, oSqlCommand, "get Invoice List");
if (tb != null)
{
foreach (DataRow r in tb.Rows)
{
InvoiceDataTypes.InvoiceDetailsDataType _ExOneData = new InvoiceDataTypes.InvoiceDetailsDataType();
int i = 0;
bool resp = int.TryParse(r["ItemNo"].ToString(), out i);
string respond = "";
respond = GetExistInvoiceDetails(i, InvoiceNO, out _ExOneData);
if (respond == "True")
_ExistDataList.Add(_ExOneData);
}
return "True";
}
return "No data Found";
}
catch (Exception ex)
{
return ex.Message;
}
}
public string GetExistInvoiceDetails(int ItemNo, string InvoiceNO, out InvoiceDataTypes.InvoiceDetailsDataType _ExistData)
{
_ExistData = new InvoiceDataTypes.InvoiceDetailsDataType();
MySqlCommand oSqlCommand = new MySqlCommand();
string sqlQuery = "Select "
+ "ItemNo,"
+ "InvoiceNO,"
+ "AccID,"
+ "Description,"
+ "Cr,"
+ "FCr,"
+ "TrRef,"
+ "Vat"
+ " from tblrecievebleinvoicedetails"
+ " Where 1=1 "
+ " and ItemNo=@ItemNo"
+ " and InvoiceNO=@InvoiceNO";
oSqlCommand.Parameters.AddWithValue("@ItemNo", ItemNo);
oSqlCommand.Parameters.AddWithValue("@InvoiceNO", InvoiceNO);
DataRow r = Mycommon.GetDataRowAccount(sqlQuery, oSqlCommand, "Get Exist data InvoiceDetails");
if (r != null)
{
try
{
bool resp = false;
int inItemNo = 0;
resp = int.TryParse(r["ItemNo"].ToString(), out inItemNo);
_ExistData.ItemNo = inItemNo;
_ExistData.InvoiceNO = r["InvoiceNO"].ToString();
_ExistData.AccID = r["AccID"].ToString();
_ExistData.Description = r["Description"].ToString();
decimal deCr = 0;
resp = decimal.TryParse(r["Cr"].ToString(), out deCr);
_ExistData.Cr = deCr;
decimal deFCr = 0;
resp = decimal.TryParse(r["FCr"].ToString(), out deFCr);
_ExistData.FCr = deFCr;
_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 SetDetailsToClass(out List<InvoiceDataTypes.InvoiceDetailsDataType> _DetailList)
{
_DetailList = new List<InvoiceDataTypes.InvoiceDetailsDataType>();
try
{
if (dgvAccount.Rows.Count > 0)
{
foreach (DataGridViewRow r in dgvAccount.Rows)
{
InvoiceDataTypes.InvoiceDetailsDataType _OneDAta = new InvoiceDataTypes.InvoiceDetailsDataType();
decimal TotalLKR = 0, TotalUSD = 0,Vat=0;
bool resp = decimal.TryParse(r.Cells["dgvAccount_Amount"].Value.ToString(), out TotalLKR);
resp = decimal.TryParse(r.Cells["dgvAccount_Fcr"].Value.ToString(), out TotalUSD);
resp = decimal.TryParse(r.Cells["dgvAccount_VAT"].Value.ToString(), out Vat);
int i = 0;
resp = int.TryParse(r.Cells["dgvAccount_LineRef"].Value.ToString(), out i);
_OneDAta.AccID = r.Cells["dgvAccount_ID"].Value.ToString();
_OneDAta.Cr = TotalLKR;
_OneDAta.Description = r.Cells["dgvAccount_Memo"].Value.ToString();
_OneDAta.FCr = TotalUSD;
_OneDAta.InvoiceNO = cmbGRN.Text;
_OneDAta.ItemNo = i;
_OneDAta.Vat = Vat;
_DetailList.Add(_OneDAta);
}
return "True";
}
else
{
return "No Data To Save";
}
}
catch (Exception ex)
{
return ex.Message;
}
}