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