public List <MediaModel> MediaSearch(string name,
DateTime?dateFrom,
DateTime?dateTo)
{
var result = new List <MediaModel>();
XElement listItems;
var queryXML = new StringBuilder();
queryXML.Append("<Query><Where>");
if (!string.IsNullOrEmpty(name))
{
queryXML.Append("<Contains><FieldRef Name='Title'/><Value Type='Text'>");
queryXML.Append(name);
queryXML.Append("</Value></Contains>");
}
if (dateFrom.HasValue)
{
queryXML.Append("<Geq><FieldRef Name='ImageCreateDate'/><Value Type='DateTime'>");
queryXML.Append(dateFrom.ToString());
queryXML.Append("</Value></Geq>");
}
if (dateTo.HasValue)
{
queryXML.Append("<Lt><FieldRef Name='ImageCreateDate'/><Value Type='DateTime'>");
queryXML.Append(dateTo.ToString());
queryXML.Append("</Value></Lt>");
}
queryXML.Append("</Where></Query>");
var servicePath = string.Format("{0}/_vti_bin/lists.asmx",
IntegrationHelper.SPOperationURL);
var mediaPath = Globals.GetSetting("SPMediaPath");
string viewFieldsXml =
@"<ViewFields>
<FieldRef Name='Title'/>
<FieldRef Name='DocIcon'/>
<FieldRef Name='EncodedAbsUrl'/>
<FieldRef Name='CreatedDate'/>
</ViewFields>" ;
string queryOptionsXml =
"<QueryOptions>" +
"<IncludeMandatoryColumns>TRUE</IncludeMandatoryColumns>" +
"<DateInUtc>TRUE</DateInUtc>" +
"</QueryOptions>";
var endPoint = new EndpointAddress(servicePath);
var binding = GetSharepointBinding();
string userWebConf = ConfigurationManager.AppSettings["CyberArk:SPServiceAccount_login"];
string user = userWebConf.Split('|')[0];
string password = PasswordStorage.GetPasswordStorage().GetPassword(userWebConf);
using (var factory = new ChannelFactory <ListsSoap>(binding, endPoint))
{
using (var proxy = new ListsSoapClient(binding, endPoint))
{
if (proxy.ClientCredentials != null)
{
proxy.ClientCredentials.Windows.ClientCredential = CredentialCache.DefaultNetworkCredentials;
proxy.ClientCredentials.Windows.AllowedImpersonationLevel = TokenImpersonationLevel.Impersonation;
proxy.Endpoint.Address = endPoint;
proxy.ClientCredentials.UserName.UserName = user;
proxy.ClientCredentials.UserName.Password = password;
}
listItems = proxy.GetListItems(
mediaPath,
null,
XElement.Parse(queryXML.ToString()),
XElement.Parse(viewFieldsXml),
null,
XElement.Parse(queryOptionsXml),
null);
}
}
var responseDocument = new XmlDocument();
responseDocument.LoadXml(listItems.ToString());
XmlNodeList elementList = responseDocument.GetElementsByTagName("z:row");
foreach (XmlNode element in elementList)
{
result.Add(new MediaModel()
{
MediaId = -1,
Name = GetXMLStringValue(element.Attributes["ows_Title"]),
Content = GetXMLStringValue(element.Attributes["ows__Comments"]),
Year = GetXMLIntValue(element.Attributes["ows_Created_x0020_Date"]),
Location = GetXMLStringValue(element.Attributes["ows_Keywords"]),
MediaUrl = GetXMLStringValue(element.Attributes["ows_EncodedAbsUrl"]),
});
}
return(result);
}
public string AddMediaFile(HttpPostedFileBase file)
{
var imageTypes = new string[] { "png", "jpg", "jpeg", "gif", "bpm" };
var videoTypes = new string[] { "avi", "wmf", "mp4", "flv" };
byte[] fileBytes;
var fileExtension = Path.GetExtension(file.FileName)
.ToLower()
.Trim('.');
if (!videoTypes.Any(vt => vt == fileExtension) &&
!imageTypes.Any(it => it == fileExtension))
{
throw new Exception("Invalid file type");
}
if (file.ContentLength > 0xf00000)
{
IDBContext.Current.ErrorMessage("Max allowed size is 15 MB");
}
var isImage = imageTypes.Any(it => it == fileExtension);
if (isImage)
{
ImageHelper.ResizeImage(file.InputStream, out fileBytes, fileExtension);
}
else
{
fileBytes = new byte[file.InputStream.Length];
file.InputStream.Read(fileBytes, 0, (int)file.InputStream.Length);
}
var business = new VisualizationBusinessContext();
try
{
var fileName = file.FileName;
var spUrl = string.Format("{0}/{1}/{2}",
IntegrationHelper.SPOperationURL,
Globals.GetSetting("SPMediaPath"),
fileName);
var servicePath = string.Format("{0}/_vti_bin/copy.asmx",
IntegrationHelper.SPOperationURL);
var endPoint = new EndpointAddress(servicePath);
var binding = GetSharepointBinding();
string userWebConf = ConfigurationManager.AppSettings["CyberArk:SPServiceAccount_login"];
string user = userWebConf.Split('|')[0];
string password = PasswordStorage.GetPasswordStorage().GetPassword(userWebConf);
using (var factory = new ChannelFactory <ListsSoap>(binding, endPoint))
{
using (var proxy = new CopySoapClient(binding, endPoint))
{
proxy.Endpoint.Address = new EndpointAddress(servicePath);
proxy.ClientCredentials.Windows.ClientCredential = CredentialCache.DefaultNetworkCredentials;
proxy.ClientCredentials.Windows.AllowedImpersonationLevel = TokenImpersonationLevel.Impersonation;
proxy.ClientCredentials.UserName.UserName = user;
proxy.ClientCredentials.UserName.Password = password;
proxy.Open();
FieldInformation myFieldInfo = new FieldInformation()
{
DisplayName = string.Empty,
InternalName = string.Empty,
Type = FieldType.Text,
Value = fileName
};
CopyResult[] result;
proxy.CopyIntoItems(spUrl,
new string[] { spUrl },
new FieldInformation[] { myFieldInfo },
fileBytes,
out result);
if (result == null || result.Length == 0)
{
throw new Exception("Error calling copy.asmx service");
}
if (result[0].ErrorCode != CopyErrorCode.Success)
{
throw new Exception(string.Format("ErrorCode:{0}. ErrorMessage: {1}",
result[0].ErrorCode,
result[0].ErrorMessage));
}
}
}
return(spUrl);
}
catch (Exception ex)
{
Architecture.Logging.Logger.GetLogger()
.WriteError(GetType().Name, ex.Message, ex);
throw;
}
}