public static async Task <string> GetMergeTableAsync(string Destination, List <string> Mergings)
{
try
{
MergeTransfer mergeTransfer = new MergeTransfer()
{
DestinationTableNo = Destination, MergingTables = Mergings
};
String url = GenerateMergeTableURL();
var JsonObject = JsonConvert.SerializeObject(mergeTransfer);
string ContentType = "application/json"; // or application/xml
using (HttpClient client = new HttpClient())
{
var response = await client.PostAsync(url, new StringContent(JsonObject.ToString(), Encoding.UTF8, ContentType));
var json = await response.Content.ReadAsStringAsync();
return(json);
}
}
catch (Exception e)
{
return(e.Message);
}
}
//private void ExecutemergeTableCommand(object obj)
//{
// try
// {
// string InsertQueryForKotProd = "INSERT INTO RMD_KOTPROD(KOTID,TABLENO,TRNDATE,MCODE,UNIT,Quantity,RealQty,AltQty,RATE,AMOUNT,DISCOUNT,VAT,REALRATE,IDIS,ALTUNIT,WAREHOUSE,KOT,SNO,ItemDesc,DIVISION,SERVICETAX,NAMNT,KOTTIME,KitchenDispatch,DispatchTime,DispatchUser,Remarks,ISBOT,ComboItem,ComboItemQty, WaiterName, REFSNO,RECEIPES,TAKEAWAY) VALUES(@KOTID,@TABLENO,@TRNDATE,@MCODE,@UNIT,@Quantity,@RealQty,@AltQty,@RATE,@AMOUNT,@DISCOUNT,@VAT,@REALRATE,@IDIS,@ALTUNIT,@WAREHOUSE,@KOT,@SNO,@ItemDesc,@DIVISION,@SERVICETAX,@NAMNT,@KOTTIME,@KitchenDispatch,@DispatchTime,@DispatchUser,@Remarks,@ISBOT,@ComboItem,@ComboItemQty, @WaiterName, @REFSNO,@RECEIPES,@TAKEAWAY)";
// var list = (popup.DataContext as MergeTableViewModel).TableListForMerge;
// List<KOTProd> kpMergedListForSave = new List<KOTProd>();
// using (SqlConnection con = new SqlConnection(ConnectionDbInfo.ConnectionString))
// {
// con.Open();
// SqlTransaction tran = con.BeginTransaction();
// try
// {
// foreach (var o in list.Where(x => x.IsTableChecked))
// {
// var kotprodLis = new List<KOTProd>(con.Query<KOTProd>("select kp.* from rmd_kotprod kp join rmd_kotmain_status kms on kp.kotid=kms.kotid where kms.status='ACTIVE' AND kp.TableNo='" + o.TableNo + "'", null, tran));
// if (kotprodLis.Count() == 0) { tran.Rollback(); MessageBox.Show("Error on merging Table.Sorry could not find KOT Items"); return; }
// kotprodLis.ForEach(x => x.Remarks = "MERGE FROM KOTID:" + x.KOTID);
// kpMergedListForSave.AddRange(kotprodLis);
// con.Execute("UPDATE RMD_KOTMAIN_STATUS SET STATUS='MERGE',REMARKS='MERGE TO: " + KotMainObj.KOTID + "' WHERE KOTID=" + kotprodLis.FirstOrDefault().KOTID, transaction: tran);
// }
// foreach (var t in kpMergedListForSave)
// {
// t.TABLENO = TableId;
// t.KOTID = KotMainObj.KOTID;
// }
// con.Execute(InsertQueryForKotProd, kpMergedListForSave, tran);
// tran.Commit(); //MessageBox.Show("Table Merging Successfull...");
// // DialogResult = true;
// }
// catch (Exception ex) {
// //tran.Rollback(); MessageBox.Show("Error on merging table..." + ex);
// }
// }
// }
// }
// }
// catch (Exception ex) { MessageBox.Show("Error Message..." + ex); }
//}
public string MergeTable(MergeTransfer mergeTransfer)
{
try
{
string DestinationTableNo = mergeTransfer.DestinationTableNo;
var list = mergeTransfer.MergingTables;
string InsertQueryForKotProd = "INSERT INTO RMD_KOTPROD(KOTID,TABLENO,TRNDATE,MCODE,UNIT,Quantity,RealQty,AltQty,RATE,AMOUNT,DISCOUNT,VAT,REALRATE,IDIS,ALTUNIT,WAREHOUSE,KOT,SNO,ItemDesc,DIVISION,SERVICETAX,NAMNT,KOTTIME,KitchenDispatch,DispatchTime,DispatchUser,Remarks,ISBOT,ComboItem,ComboItemQty, WaiterName, REFSNO,RECEIPES,TAKEAWAY) VALUES(@KOTID,@TABLENO,@TRNDATE,@MCODE,@UNIT,@Quantity,@RealQty,@AltQty,@RATE,@AMOUNT,@DISCOUNT,@VAT,@REALRATE,@IDIS,@ALTUNIT,@WAREHOUSE,@KOT,@SNO,@ItemDesc,@DIVISION,@SERVICETAX,@NAMNT,@KOTTIME,@KitchenDispatch,@DispatchTime,@DispatchUser,@Remarks,@ISBOT,@ComboItem,@ComboItemQty, @WaiterName, @REFSNO,@RECEIPES,@TAKEAWAY)";
List <KOTProd> kpMergedListForSave = new List <KOTProd>();
KotMain KotMainObj = new KotMain();
using (SqlConnection con = new SqlConnection(ConnectionDbInfo.ConnectionString))
{
con.Open();
SqlTransaction tran = con.BeginTransaction();
try
{
KotMainObj = con.Query <KotMain>("Select * from RMD_KOTMAIN kp JOIN RMD_KOTMAIN_STATUS KMS ON KP.KOTID=KMS.KOTID where KMS.STATUS='ACTIVE' and kp.TableNo='" + DestinationTableNo + "'", transaction: tran).FirstOrDefault();
foreach (var o in list)
{
var kotprodLis = new List <KOTProd>(con.Query <KOTProd>("select kp.* from rmd_kotprod kp join rmd_kotmain_status kms on kp.kotid=kms.kotid where kms.status='ACTIVE' AND kp.TableNo='" + o + "'", transaction: tran));
if (kotprodLis.Count() == 0)
{
tran.Rollback(); return("Error on merging Table.Sorry could not find KOT Items");
}
kotprodLis.ForEach(x => x.Remarks = "MERGE FROM KOTID:" + x.KOTID);
kpMergedListForSave.AddRange(kotprodLis);
con.Execute("UPDATE RMD_KOTMAIN_STATUS SET STATUS='MERGE',REMARKS='MERGE TO: " + KotMainObj.KOTID + "' WHERE KOTID=" + kotprodLis.FirstOrDefault().KOTID, transaction: tran);
}
foreach (var t in kpMergedListForSave)
{
t.TABLENO = DestinationTableNo;
t.KOTID = KotMainObj.KOTID;
}
con.Execute(InsertQueryForKotProd, kpMergedListForSave, transaction: tran);
tran.Commit();
return("success");
}
catch (Exception ex)
{
return("Error on merging table..." + ex.Message);
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string MergeTable([FromBody] MergeTransfer mergeTransfer)
{
return(new TableTransferMethods().MergeTable(mergeTransfer));
}
