public void AddUpdateAsset()
//**********AddUpdateAsset**********
//NAME : AddUpdateAsset
//PURPOSE : This function is used to Add or update asset info.
//PARAMETERS :
//RETURN VALUE : void
//USAGE :
//CREATED ON : 16-04-2007
//CHANGE HISTORY :Auth Date Description
//***********************************************************************
{
try
{
XmlHttpHandler AssetDocs = new XmlHttpHandler();
string strproducts;
string splitcharater;
splitcharater = ",";
string[] ProductArray;
string PID;
//string calendarSql;
string strIncludeExclude;
DataLibrary.Database oSiteWideDB = null;
SqlDataReader assetDataReader = null;
strproducts = Request.Form["products"];
ProductArray = strproducts.Split(splitcharater.ToCharArray()[0]);
PID = AssetDocs.CreateModifyAsset(Convert.ToBoolean(Request.Form["isclone"]), Request.Form["assetpid"],
Request.Form["title"], Request.Form["description"], Request.Form["Filename"], Request.Form["FileSize"],
Convert.ToDateTime(Request.Form["begindate"]), ProductArray, Request.Form["language"],
Request.Form["operation"], Request.Form["Category_Type"], Request.Form["oraclenumber"],
Request.Form["access"], Request.Form["industry"], Request.Form["IncludeExclude"],
Convert.ToBoolean(Request.Form["status"]), Request.Form["oldLanguage"], Request.Form["oldItemNumber"],
Convert.ToInt64(Request.Form["AssetId"]));
try
{
oSiteWideDB = DataLibrary.DatabaseFactory.CreateDatabase("FlukeSitewide");
assetDataReader = (SqlDataReader)oSiteWideDB.ExecuteReader(System.Data.CommandType.Text, "PCAT_FNET_ASSETCLONES_SEL " + Site_Id + "," + Request.Form["calendarId"].ToString());
}
catch (Exception connectionEx)
{
if (ExceptionPolicy.HandleException(DanaherTM.Framework.ExceptionHandling.ExceptionInstance.FlukeNetworks.WebPages, connectionEx))
{
//throw;
}
}
if (assetDataReader != null)
{
while (assetDataReader.Read())
{
if (assetDataReader.GetValue(16).ToString().StartsWith("0") == true)
{
strIncludeExclude = assetDataReader.GetValue(16).ToString();
}
else if (assetDataReader.GetValue(16).ToString() == "none")
{
strIncludeExclude = "none";
}
else
{
strIncludeExclude = "1" + assetDataReader.GetValue(16).ToString();
}
XmlDocument xmlDomDocument = new XmlDocument();
string productId;
xmlDomDocument.LoadXml(PID);
productId = xmlDomDocument.DocumentElement.InnerText.ToString();
xmlDomDocument = null;
string strFilePathName = "";
if (Convert.ToInt32(assetDataReader.GetValue(17)) <= 0)
{
strFilePathName = assetDataReader.GetValue(6).ToString();
if (strFilePathName.LastIndexOf(@"\") > 1)
{
strFilePathName = strFilePathName.Substring(strFilePathName.LastIndexOf(@"\") + 1);
}
if (strFilePathName.LastIndexOf("/") > 1)
{
strFilePathName = strFilePathName.Substring(strFilePathName.LastIndexOf("/") + 1);
}
PID = AssetDocs.CreateModifyAsset(Convert.ToBoolean(assetDataReader.GetValue(11)),
productId, assetDataReader.GetValue(0).ToString(),
assetDataReader.GetValue(4).ToString(), strFilePathName,
assetDataReader.GetValue(7).ToString(),
Convert.ToDateTime(assetDataReader.GetValue(8).ToString()), ProductArray,
assetDataReader.GetValue(5).ToString(), "U", assetDataReader.GetValue(1).ToString(),
assetDataReader.GetValue(14).ToString(), assetDataReader.GetValue(2).ToString(),
Request.Form["industry"], strIncludeExclude, Convert.ToBoolean(Request.Form["status"])
, assetDataReader.GetValue(5).ToString(), assetDataReader.GetValue(14).ToString()
, Convert.ToInt64(assetDataReader.GetValue(15)));
}
strIncludeExclude = "";
}
}
Response.ContentType = "text/xml";
Response.Charset = "utf-16";
Response.BinaryWrite(StringToBytes(PID));
AssetDocs = null;
}
catch (Exception ex)
{
if (ExceptionPolicy.HandleException(DanaherTM.Framework.ExceptionHandling.ExceptionInstance.FlukeNetworks.WebPages, ex))
{
//throw;
}
}
}
