protected void btnAddURL_Click(object sender, EventArgs e)
{
lblURLError.Text = "";
if (txtURL.Text.Trim() == "" || txtURLName.Text.Trim() == "")
{
lblURLError.Text = "URL and URL Name cannot be empty";
}
//else if (!System.Text.RegularExpressions.Regex.IsMatch(txtURL.Text, "^(ht|f)tp(s?)/://[0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*(:(0-9)*)*(\/?)([a-zA-Z0-9\-\.\?\,\'\/\\\+&%\$#_]*)?$"))
//{
// lblURLError.Text = "Invalid URL";
//}
else
{
if (hWebinarID.Value != "0" || hWebinarID.Value != "")
{
WebinarResource objWebinarResource = new WebinarResource();
objWebinarResource.WebinarID = Convert.ToInt32(hWebinarID.Value);
objWebinarResource.DocID = 0;
objWebinarResource.ResourceType = "URL";
objWebinarResource.ResourceTitle = txtURLName.Text;
objWebinarResource.ResourceValue = txtURL.Text;
objWebinarResource.IsBriefcase = true;
if (objWebinarDA.InsertWebinarResources(objWebinarResource) == 0)
lblURLError.Text = "URL and URL Name already exist.";
else
{
txtURL.Text = "";
txtURLName.Text = "";
popResource();
}
}
}
}
public void aupPresentation_FileUploaded(object sender, FileUploadedEventArgs e)
{
Session["FolderType"] = "PRESENTATION";
telerikAsyncUploadResult result = e.UploadResult as telerikAsyncUploadResult;
if (result != null)
{
if (result.DocumentID > 0)
{
WebinarResource objWebinarResource = new WebinarResource();
objWebinarResource.WebinarID = Convert.ToInt32(hWebinarID.Value);
objWebinarResource.DocID = result.DocumentID;
objWebinarResource.ResourceType = "Presentation";
objWebinarResource.ResourceTitle = e.File.FileName;
objWebinarResource.ResourceValue = "";
objWebinarResource.IsBriefcase = false; //chkAddtoBC.Checked;
if (objWebinarDA.InsertWebinarResources(objWebinarResource) == 0)
{
DocAccess objDocAccess = new DocAccess();
objDocAccess.removeDocumentFromRepositary(result.DocumentID,Convert.ToInt32(Session["ClientID"]),"WebinarDocs");
}
//if (chkAddtoBC.Checked && !chkConfig8.Checked)
//{
// objWebinarDA.SaveWebinarAudience(Convert.ToInt32(hWebinarID.Value), "Content", (Convert.ToInt32(ClientConfigMaster.Audi_Component_Content)).ToString());
// chkConfig8.Checked = true;
//}
// popResource(); // popPresentation();
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
WebinarResource objWebinarResource = new WebinarResource();
objWebinarResource.WebinarID = Convert.ToInt32(hWebinarID.Value);
objWebinarResource.DocID = Convert.ToInt32(hDocId.Value);
objWebinarResource.LogoUrlName = txtURLName.Text;
objWebinarResource.LogoUrl = txtURL.Text;
objWebinarDA.UpdateWebinarResources(objWebinarResource);
hModalStatusFlg.Value = "1";
}
public void aupLogo_FileUploaded(object sender, FileUploadedEventArgs e)
{
telerikAsyncUploadResult result = e.UploadResult as telerikAsyncUploadResult;
if (result != null)
{
if (result.DocumentID > 0)
{
WebinarResource objWebinarResource = new WebinarResource();
objWebinarResource.WebinarID = Convert.ToInt32(hWebinarID.Value);
objWebinarResource.DocID = result.DocumentID;
objWebinarResource.ResourceType = (rcmbHeader.SelectedValue == "BANNER" ? "BANNER" : "Logo");
objWebinarResource.ResourceTitle = e.File.FileName;
objWebinarResource.ResourceValue = "";
objWebinarResource.IsBriefcase = false;
objWebinarDA.InsertWebinarResources(objWebinarResource);
}
}
}
public void aupContent_FileUploaded(object sender, FileUploadedEventArgs e)
{
telerikAsyncUploadResult result = e.UploadResult as telerikAsyncUploadResult;
if (result != null)
{
if (result.DocumentID > 0)
{
WebinarResource objWebinarResource = new WebinarResource();
objWebinarResource.WebinarID = Convert.ToInt32(hWebinarID.Value);
objWebinarResource.DocID = result.DocumentID;
objWebinarResource.ResourceType = "Content Doc";
objWebinarResource.ResourceTitle = e.File.FileName;
objWebinarResource.ResourceValue = "";
objWebinarResource.IsBriefcase = true;
objWebinarDA.InsertWebinarResources(objWebinarResource);
popResource();
}
}
}
public int UpdateWebinarResources(WebinarResource objWebinarResource)
{
int rtnVal = 0;
try
{
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
MySqlCommand sqlCmd = new MySqlCommand("spWebinarResourceUpdate", sqlCon);
sqlCon.Open();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(new MySqlParameter("pWebinarID", objWebinarResource.WebinarID));
sqlCmd.Parameters.Add(new MySqlParameter("pDocId", objWebinarResource.DocID));
sqlCmd.Parameters.Add(new MySqlParameter("pLogoUrlName", objWebinarResource.LogoUrlName));
sqlCmd.Parameters.Add(new MySqlParameter("pLogoUrl", objWebinarResource.LogoUrl));
MySqlDataReader reader = sqlCmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
rtnVal = Convert.ToInt32(reader[0]);
}
reader.Close();
reader = null;
sqlCon.Close();
}
}
catch (Exception ex)
{
throw;
}
return rtnVal;
}
public void InsertRegFormResources(WebinarResource objWebinarResource)
{
try
{
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
MySqlCommand sqlCmd = new MySqlCommand(DBQuery.sqlWebinarResourceInsert, sqlCon);
sqlCon.Open();
sqlCmd.CommandType = CommandType.Text;
sqlCmd.Parameters.Add(new MySqlParameter("@webinarID", objWebinarResource.WebinarID));
sqlCmd.Parameters.Add(new MySqlParameter("@docID", objWebinarResource.DocID));
sqlCmd.Parameters.Add(new MySqlParameter("@resourceType", objWebinarResource.ResourceType));
sqlCmd.Parameters.Add(new MySqlParameter("@resourceOrder", objWebinarResource.ResourceOrder));
sqlCmd.Parameters.Add(new MySqlParameter("@ResourceTitle", objWebinarResource.ResourceTitle));
sqlCmd.Parameters.Add(new MySqlParameter("@resourceValue", objWebinarResource.ResourceValue));
sqlCmd.ExecuteNonQuery();
sqlCon.Close();
}
}
catch (Exception ex)
{
throw;
}
}
//protected void aupLogo_FileUploaded(object sender, FileUploadedEventArgs e)
//{
// RadBinaryImage rimg = (RadBinaryImage)this.FindControl("Thumbnail" + hCurrentImg.Value);
// if (rimg != null)
// {
// rimg.Width = Unit.Pixel(200);
// rimg.Height = Unit.Pixel(150);
// using (Stream stream = e.File.InputStream)
// {
// byte[] imageData = new byte[stream.Length];
// stream.Read(imageData, 0, (int)stream.Length);
// rimg.DataValue = imageData;
// }
// int curr = Convert.ToInt32(hCurrentImg.Value);
// if (curr < 4)
// {
// hCurrentImg.Value = (curr + 1).ToString();
// if (curr >= 4)
// aupLogo.Visible = false;
// }
// }
//}
public void aupLogo_FileUploaded(object sender, FileUploadedEventArgs e)
{
telerikAsyncUploadResult result = e.UploadResult as telerikAsyncUploadResult;
if (result != null)
{
if (result.DocumentID > 0)
{
int idx = Convert.ToInt32(hCurrentImg.Value);
if (rcmbHeader.SelectedIndex != 1)
idx = 1;
WebinarResource objWebinarResource = new WebinarResource();
objWebinarResource.WebinarID = Convert.ToInt32(hWebinarID.Value);
objWebinarResource.DocID = result.DocumentID;
objWebinarResource.ResourceType = rcmbHeader.SelectedValue;
objWebinarResource.ResourceOrder = idx;
objWebinarDA.InsertRegFormResources(objWebinarResource);
++idx;
hCurrentImg.Value = idx.ToString();
}
}
}