public string DeleteChallan(string strPartyName, string strChallanNo, string strLCNo, string strReason)
{
try
{
deleteChallanOutDataTableAdapter adp = new deleteChallanOutDataTableAdapter();
sprDeleteFromStockRegisterTableAdapter adp2 = new sprDeleteFromStockRegisterTableAdapter();
getTableTableAdapter adp3 = new getTableTableAdapter();
tblDeletedChallanTableAdapter adp4 = new tblDeletedChallanTableAdapter();
foreach (var x in adp3.GetTableData(strPartyName, Convert.ToInt32(strChallanNo), strLCNo))
{
adp2.DeleteStockData(Convert.ToInt32(strChallanNo), strPartyName, x.strDetails, Convert.ToInt32(x.intQuantity));
}
adp.DeleteChallanOutData(Convert.ToInt32(strChallanNo), strPartyName, strLCNo);
adp4.InsertDeleteReason(Convert.ToInt32(strChallanNo), strReason);
return("Delete Successfully");
}
catch (Exception e)
{
return("The Challan is not delete Successfully !!!");
}
}
public DataTable GetTableData(string strPartyName, string strChallanNo, string strLCNo)
{
getTableTableAdapter adp = new getTableTableAdapter();
DataTable dt = adp.GetTableData(strPartyName, Convert.ToInt32(strChallanNo), strLCNo);
return(dt);
}