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);
}
