public List<SharingInfo> Sharing_GetByAll() { List<SharingInfo> list = new List<SharingInfo>(); using (SqlConnection Conn = new SqlConnection(Common.GetConnectString())) { try { Conn.Open(); using (SqlCommand dbCmd = new SqlCommand("DDV_GetSharingInfo", Conn)) { dbCmd.CommandType = CommandType.StoredProcedure; SharingInfo obj = new SharingInfo(); SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.CustomerIDataReader(dr)); } } dr.Close(); obj = null; } } catch (Exception ex) { throw ex; } finally { Conn.Close(); } } return list; }
public void DeleteFiles() { try { logger.Info("Begin WS DeleteFiles from Webservice"); List<SharingInfo> listSharingInfo = new List<SharingInfo>(); SharingInfo objSharingInfo = new SharingInfo(); using (SqlConnection cnn = new SqlConnection(Common.GetConnectString())) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "select * from TD_SHARING_INFO where Expiration_date < getdate() and delete_flag = 0"; cmd.Connection = cnn; cnn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { listSharingInfo.Add(objSharingInfo.CustomerIDataReader(dr)); } } cnn.Close(); } if (listSharingInfo.Count > 0) { if (Common.AppSettingKey(Constant.STORAGE_CONNECT_STRING) != "") { BlobManager blobManger = new BlobManager(); for (int i = 0; i < listSharingInfo.Count; i++) { blobManger.DeleteBlobDirectory(listSharingInfo[i].customer_id); UpdateSharingInfo(listSharingInfo[i].ID); } } else { string hostPath = GetMapPath(); for (int i = 0; i < listSharingInfo.Count; i++) { string pathCustomerID = System.IO.Path.Combine(hostPath, Constant.UPLOAD_STORAGE + "\\" + listSharingInfo[i].customer_id); if (Directory.Exists(pathCustomerID)) Directory.Delete(pathCustomerID, true); UpdateSharingInfo(listSharingInfo[i].ID); } } } logger.Info("End DeleteFiles from Webservice"); } catch (Exception ex) { logger.Error("Error in DeleteFiles " , ex); throw ex; } }