internal DataSet BindAll(OfflineSalesVoucherModel ObjOfflineSalesModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPOfflineSaleVoucher"; ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjOfflineSalesModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjOfflineSalesModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjOfflineSalesModel.BrID); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dsSales = new DataSet(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dsSales); dsSales.DataSetName = "success"; } catch (Exception) { dsSales = new DataSet(); dsSales.DataSetName = "error"; return(dsSales); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dsSales); }
public string GetSalesData(SalesData ObjSalesData) { var DecodedData = Base64Decode(ObjSalesData.DetailData); OfflineSalesVoucherModel obj = JsonConvert.DeserializeObject <OfflineSalesVoucherModel>(DecodedData); if (obj != null) { ObjOfflineSalesModel = new OfflineSalesVoucherModel(); ObjOfflineSalesModel.Ind = 1; ObjOfflineSalesModel.OrgID = obj.OrgID; ObjOfflineSalesModel.BrID = obj.BrID; DataSet dsBindAll = ObjOfflineSalesDA.BindAll(ObjOfflineSalesModel); if (dsBindAll.Tables != null && dsBindAll.Tables.Count > 0) { dsBindAll.Tables[0].TableName = "OfflineUserInfo"; dsBindAll.Tables[1].TableName = "WarehouseInfo"; dsBindAll.Tables[2].TableName = "MstAccountInfo"; dsBindAll.Tables[3].TableName = "MstAccountPOSInfo"; dsBindAll.Tables[4].TableName = "MstAccountGSTINInfo"; dsBindAll.Tables[5].TableName = "TblSeriesInfo"; dsBindAll.Tables[6].TableName = "MstItemInfo"; dsBindAll.Tables[7].TableName = "MstItemUnitInfo"; dsBindAll.Tables[8].TableName = "MstTransportModeInfo"; jsonString = Newtonsoft.Json.JsonConvert.SerializeObject(dsBindAll); resp = Base64Encode(jsonString); return(resp); } else { resp = Base64Encode("Error"); } } else { resp = Base64Encode("Error"); } return(resp); //string test = Newtonsoft.Json.JsonConvert.SerializeObject(resp); //string demo = Base64Decode(test); }