internal DataTable CheckInvoiceSeries(OfflineSeriesModel ObjOfflineSeriesModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPOfflineSeries";
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjOfflineSeriesModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjOfflineSeriesModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjOfflineSeriesModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@UserName", ObjOfflineSeriesModel.UserName);
ClsCon.cmd.Parameters.AddWithValue("@UserPassword", ObjOfflineSeriesModel.UserPassword);
ClsCon.cmd.Parameters.AddWithValue("@MacAddress", ObjOfflineSeriesModel.MacAddress);
ClsCon.cmd.Parameters.AddWithValue("@SeriesType", ObjOfflineSeriesModel.SeriesType);
ClsCon.cmd.Parameters.AddWithValue("@TblSeries", ObjOfflineSeriesModel.Binding_SeriesList);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtOfflineSeries = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtOfflineSeries);
dtOfflineSeries.TableName = "success";
}
catch (Exception)
{
dtOfflineSeries = new DataTable();
dtOfflineSeries.TableName = "error";
return(dtOfflineSeries);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtOfflineSeries);
}
public string GetData(Data Obj)
{
var DecodedData = Base64Decode(Obj.DetailData);
FormEntry obj = JsonConvert.DeserializeObject <FormEntry>(DecodedData);
if (obj != null)
{
objModel = new OfflineSeriesModel();
objModel.Ind = 1;
objModel.OrgID = obj.OrgID;
objModel.BrID = obj.BrID;
objModel.SeriesType = obj.SeriesType;
objModel.UserName = obj.UserName;
objModel.UserPassword = obj.UserPassword;
objModel.MacAddress = obj.MacAddress;
objModel.Binding_SeriesList = ToDataTable(obj.Binding_SeriesList);
ObjOfflineSeriesDA = new OfflineSeriesDataAccess();
DataTable dt = ObjOfflineSeriesDA.CheckInvoiceSeries(objModel);
if (dt != null && dt.Rows.Count > 0)
{
respInd = Convert.ToInt32(dt.Rows[0][0].ToString());
if (respInd == 1)
{
objMsg = new ClsCommonMsg();
objMsg.Code = 1;
objMsg.Msg = "Successfully Save";
objMsg.DownloadLocation = "";
}
else if (respInd == 2)
{
objMsg = new ClsCommonMsg();
objMsg.Code = 2;
objMsg.Msg = "";
objMsg.DownloadLocation = string.Empty;
}
else if (respInd == 9)
{
objMsg = new ClsCommonMsg();
objMsg.Code = 9;
objMsg.Msg = "";
objMsg.DownloadLocation = string.Empty;
}
jsonString = Newtonsoft.Json.JsonConvert.SerializeObject(objMsg);
resp = Base64Encode(jsonString);
return(resp);
}
else
{
resp = Base64Encode("Error");
}
}
else
{
//error
resp = Base64Encode("Error");
}
return(resp);
}
