internal DataTable UpdateRecord(ClsDownloadSuccess obj) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPOfflineSeries"; ClsCon.cmd.Parameters.AddWithValue("@Ind", obj.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", obj.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", obj.BrID); ClsCon.cmd.Parameters.AddWithValue("@UserName", obj.UserName); ClsCon.cmd.Parameters.AddWithValue("@UserPassword", obj.UserPassword); ClsCon.cmd.Parameters.AddWithValue("@DowinloadSuccessInd", obj.DowinloadSuccessInd); 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 UpdateRecord(Data Obj) { var DecodedData = Base64Decode(Obj.DetailData); ClsDownloadSuccess obj = JsonConvert.DeserializeObject <ClsDownloadSuccess>(DecodedData); if (obj != null) { objUpdateModel = new ClsDownloadSuccess(); objUpdateModel.Ind = 2; objUpdateModel.OrgID = obj.OrgID; objUpdateModel.BrID = obj.BrID; objUpdateModel.UserName = obj.UserName; objUpdateModel.UserPassword = obj.UserPassword; objUpdateModel.DowinloadSuccessInd = obj.DowinloadSuccessInd; ObjOfflineSeriesDA = new OfflineSeriesDataAccess(); DataTable dt = ObjOfflineSeriesDA.UpdateRecord(obj); if (dt != null && dt.Rows.Count > 0) { respInd = Convert.ToInt32(dt.Rows[0][0].ToString()); if (respInd == 8) { objMsg = new ClsCommonMsg(); objMsg.Code = 8; objMsg.Msg = "Successfully Update"; objMsg.DownloadLocation = ""; } jsonString = Newtonsoft.Json.JsonConvert.SerializeObject(objMsg); resp = Base64Encode(jsonString); return(resp); } else { resp = Base64Encode("Error"); } } else { //error resp = Base64Encode("Error"); } return(resp); }