//[HttpGet("{dataCollect}")] public FunctionResponse <List <BranchInItem> > LoadBranchInProd([FromBody] BranchInDetail BranchInDetail) { try { List <BranchInItem> BranchInItemList = new List <BranchInItem>(); using (SqlConnection conn = new SqlConnection(GlobalClass.DataConnectionString)) { var found = new List <BranchInDetail>(conn.Query <BranchInDetail>("Select * from RMD_TRNMain where vchrno = '" + BranchInDetail.chalanNo + "' and billTo = '" + BranchInDetail.billToAdd + "' and billToAdd = '" + BranchInDetail.billTo + "'")); if (found.Count != 0) { BranchInItemList = new List <BranchInItem>(conn.Query <BranchInItem>("select * from RMD_TRNPROD where vchrno = '" + BranchInDetail.chalanNo + "' and division = '" + BranchInDetail.billToAdd + "'")); } } return(new FunctionResponse <List <BranchInItem> >() { status = "ok", result = BranchInItemList }); } catch (Exception e) { return(new FunctionResponse <List <BranchInItem> >() { status = "error", Message = e.Message }); } }
public BranchInMaster() { BranchInMain = new BranchInDetail(); BranchInProdList = new List <BranchInItem>(); }