public ProviderEDSC.ActivityImageDetailDTDataTable GetImages()
{
if (ImageUploaded != 0)
{
var dt = new ProviderEDSC.ActivityImageDetailDTDataTable();
foreach (DataListItem item in dtImageLib.Items)
{
var dr = dt.NewActivityImageDetailDTRow();
if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem)
{
Image imgUpload = item.FindControl("imgUpload") as Image;
HiddenField hdnImageStream = item.FindControl("hdnImageStream") as HiddenField;
HiddenField hdnImageSize = item.FindControl("hdnImageSize") as HiddenField;
HiddenField hdnID = item.FindControl("hdnID") as HiddenField;
Label lblName = item.FindControl("lblName") as Label;
dr.ID = Convert.ToInt32(hdnID.Value);
dr.ActivityID = 0;
dr.ActivityImageID = 0;
dr.ImageStream = Convert.FromBase64String(hdnImageStream.Value);
dr.Filename = lblName.Text;
dr.ImageTitle = "";
dr.Description = "";
dr.isPrimaryImage = false;
dr.Filesize = Convert.ToInt32(hdnImageSize.Value);
dt.AddActivityImageDetailDTRow(dr);
}
}
return(dt);
}
else
{
return(null);
}
}
protected void lnkSave_Click(object sender, EventArgs e)
{
var dt = new ProviderEDSC.ActivityImageDetailDTDataTable();
ProviderDAC dac = new ProviderDAC();
foreach (DataListItem item in DataList1.Items)
{
SetDataListItemMode(item, false);
Label lblImageDescription = item.FindControl("lblImageDescription") as Label;
Label lblImageTitle = item.FindControl("lblImageTitle") as Label;
TextBox txtImageTitle = item.FindControl("txtImageTitle") as TextBox;
TextBox ckImageDescription = item.FindControl("txtImageDescription") as TextBox;
HiddenField hdnImageID = item.FindControl("hdnImageID") as HiddenField;
HiddenField hdnActvityImageID = item.FindControl("hdnImageInfoID") as HiddenField;
HiddenField hdnFilesize = item.FindControl("hdnFilesize") as HiddenField;
HiddenField hdnFilename = item.FindControl("hdnFilename") as HiddenField;
HiddenField hdnMainImage = item.FindControl("hdnMainImage") as HiddenField;
var dr = dt.NewActivityImageDetailDTRow();
dr.ID = Convert.ToInt32(hdnImageID.Value);
dr.ImageTitle = txtImageTitle.Text;
dr.Filename = hdnFilename.Value;
dr.isPrimaryImage = Convert.ToBoolean(hdnMainImage.Value);
dr.Description = ckImageDescription.Text;
dr.ActivityID = Convert.ToInt32(hdnActivityID.Value);
dr.ActivityImageID = Convert.ToInt32(hdnActvityImageID.Value);
dr.Filesize = Convert.ToInt32(hdnFilesize.Value);
dt.AddActivityImageDetailDTRow(dr);
}
foreach (var dr in dt)
{
dac.UpdateActivityImage(dr);
}
foreach (DataListItem item in DataList1.Items)
{
SetDataListItemMode(item, false);
}
Refresh();
}
private ProviderEDSC.ActivityImageDetailDTRow GetData()
{
int imagesCount = new ProviderDAC().RetrieveActivityImagesCount(ActivityID);
ProviderEDSC.ActivityImageDetailDTRow dr = new ProviderEDSC.ActivityImageDetailDTDataTable().NewActivityImageDetailDTRow();
dr.ActivityID = ActivityID;
dr.ActivityImageID = 0;
dr.Filename = fileUpload1.FileName;
dr.Description = "";
if (imagesCount == 0)
{
dr.isPrimaryImage = true;
}
else
{
dr.isPrimaryImage = false;
}
dr.ImageTitle = "";
dr.Filesize = fileUpload1.PostedFile.ContentLength / 1024;
return(dr);
}
private void SetDataSource(ProviderEDSC.ActivityImageDetailDTDataTable dt)
{
dtImageLib.DataSource = dt;
dtImageLib.DataBind();
}
protected void imgBtnUpload_Click(object sender, EventArgs e)
{
var dt = GetImages();
if (dt == null)
{
dt = new ProviderEDSC.ActivityImageDetailDTDataTable();
}
if (fileUpload1.HasFile) // CHECK IF ANY FILE HAS BEEN SELECTED.
{
if (System.Text.RegularExpressions.Regex.IsMatch(fileUpload1.PostedFile.ContentType, "image/\\S+"))
{
string ext = fileUpload1.PostedFile.ContentType;
if (ext == "bmp" || ext == ".bmp")
{
lblUploadStatus.Text = ".bmp extension is not supported";
}
else
{
int iFailedCnt = 0;
HttpFileCollection hfc = Request.Files;
lblUploadStatus.Text = "Select <b>" + hfc.Count + "</b> file(s)";
if (hfc.Count <= 10) // 10 FILES RESTRICTION.
{
for (int i = 0; i <= hfc.Count - 1; i++)
{
HttpPostedFile hpf = hfc[i];
if (hpf.ContentLength > 0)
{
string sFileName = Path.GetFileName(hpf.FileName);
SizeUploaded = SizeUploaded + Convert.ToInt32(hpf.ContentLength / 1024);
if (SizeUploaded <= SystemConstants.MaxActivityImageStorage)
{
var dr = dt.NewActivityImageDetailDTRow();
dr.ActivityID = 0;
dr.ActivityImageID = 0;
dr.ImageStream = new BCUtility.ImageHandler().ReadFully(hpf.InputStream);
dr.Filename = sFileName;
dr.Filesize = hpf.ContentLength / 1024;
dt.AddActivityImageDetailDTRow(dr);
ImageUploaded += 1;
}
else
{
iFailedCnt += 1;
lblUploadStatus.Text += "</br><b>" + iFailedCnt + "</b> file(s) could not be uploaded. Maximum Size per activity is" + SystemConstants.MaxActivityImageStorage + " Kb";
}
}
}
lblUploadStatus.Text = "<b>" + ImageUploaded + "</b> file(s) uploaded.";
}
else
{
lblUploadStatus.Text = "Max. 10 files allowed.";
}
}
}
else
{
lblUploadStatus.Text = "Only image files are accepted.";
}
}
else
{
lblUploadStatus.Text = "No files selected.";
}
lblUploadStatus.Visible = true;
if (ImageUploaded > 0)
{
SetDataSource(dt);
divUploadSuccessfull.Visible = true;
}
}
/*
* public static void UpdateActivity(ProviderEDSC.ActivityDTRow drDetail, ProviderEDSC.ActivityContactDetailDTRow contactDetails, ProviderEDSC.ActivityGroupingDTRow drActGrouping, ProviderEDSC.ActivityScheduleDTDataTable dtActSchedule)
* {
* ProviderDAC dac = new ProviderDAC();
*
*
* dac.UpdateActivities(drDetail);
* dac.UpdateActivityContactDetail(contactDetails);
* dac.DeleteActivitySchedules(drDetail.ID);
* foreach (var drActSchedule in dtActSchedule)
* dac.CreateActivitySchedule(drActSchedule);
* dac.UpdateActivityGrouping(drActGrouping);
*
*
* }
*
* public static void UpdateActivity(ProviderEDSC.ActivityDTRow drDetail, ProviderEDSC.ActivityContactDetailDTRow contactDetails, ProviderEDSC.ActivityGroupingDTRow drActGrouping)
* {
* ProviderDAC dac = new ProviderDAC();
*
*
* dac.UpdateActivities(drDetail);
* dac.UpdateActivityContactDetail(contactDetails);
* dac.DeleteActivitySchedules(drDetail.ID);
* dac.UpdateActivityGrouping(drActGrouping);
* }
*
* public static void SaveActivity(ProviderEDSC.ActivityDTRow ActivityDetailDR, ProviderEDSC.ActivityContactDetailDTRow contactDetailsDR, ProviderEDSC.ActivityGroupingDTRow ActGroupingDR, ProviderEDSC.ActivityScheduleDTDataTable ActScheduleDT, out int activityID)
* {
* ProviderDAC dac = new ProviderDAC();
*
* using (TransactionScope trans = new TransactionScope())
* {
* activityID = 0;
* dac.CreateActivities(ActivityDetailDR, out activityID);
*
* //Activity was Created, update all foreign key
* contactDetailsDR.ActivityID = activityID;
* ActGroupingDR.ActivityID = activityID;
*
* //CreateContactDetails
* dac.CreateActivityContactDetail(contactDetailsDR);
*
* //Create Schedule
* foreach (var ActScheduleDR in ActScheduleDT)
* {
* ActScheduleDR.ActivityID = activityID;
* dac.CreateActivitySchedule(ActScheduleDR);
* }
* //Create Grouping
* dac.CreateActivityGrouping(ActGroupingDR);
*
* trans.Complete();
*
* }
* }
*
* public static void SaveActivity(ProviderEDSC.ActivityDTRow ActivityDetailDR, ProviderEDSC.ActivityContactDetailDTRow contactDetailsDR, ProviderEDSC.ActivityGroupingDTRow ActGroupingDR, out int activityID)
* {
* ProviderDAC dac = new ProviderDAC();
*
* using (TransactionScope trans = new TransactionScope())
* {
* activityID = 0;
* dac.CreateActivities(ActivityDetailDR, out activityID);
*
* //Activity was Created, update all foreign key
* contactDetailsDR.ActivityID = activityID;
* ActGroupingDR.ActivityID = activityID;
*
* //CreateContactDetails
* dac.CreateActivityContactDetail(contactDetailsDR);
*
* //Create Grouping
* dac.CreateActivityGrouping(ActGroupingDR);
*
* trans.Complete();
*
* }
* }
*/
public static void SaveActivity(ProviderEDSC.ActivityDTRow ActivityDetailDR, ProviderEDSC.ActivityContactDetailDTRow contactDetailsDR, ProviderEDSC.ActivityGroupingDTRow ActGroupingDR, ProviderEDSC.ActivityScheduleDTDataTable ActScheduleDT, ProviderEDSC.ActivityImageDTRow ImageDetail, ProviderEDSC.ActivityImageDetailDTDataTable Images, out int activityID)
{
ProviderDAC dac = new ProviderDAC();
using (TransactionScope trans = new TransactionScope())
{
activityID = 0;
dac.CreateActivities(ActivityDetailDR, out activityID);
//Activity was Created, Creat other
contactDetailsDR.ActivityID = activityID;
ActGroupingDR.ActivityID = activityID;
//CreateContactDetails
dac.CreateActivityContactDetail(contactDetailsDR);
if (ActScheduleDT != null)
{
//Create Schedule
foreach (var ActScheduleDR in ActScheduleDT)
{
ActScheduleDR.ActivityID = activityID;
dac.CreateActivitySchedule(ActScheduleDR);
}
}
//Create Grouping
dac.CreateActivityGrouping(ActGroupingDR);
//Create Images
if (ImageDetail.ImageAmount != 0)
{
ImageDetail.ActivityID = activityID;
int imgDetID = 0;
dac.createActivityImageInformation(ImageDetail, out imgDetID);
int count = 1;
foreach (var drImageDetail in Images)
{
if (count == 1)
{
drImageDetail.isPrimaryImage = true;
}
drImageDetail.ActivityID = activityID;
drImageDetail.ActivityImageID = imgDetID;
dac.CreateActivityImage(drImageDetail);
count++;
}
}
trans.Complete();
}
}
protected void imgBtnUpload_Click(object sender, EventArgs e)
{
ImageUploaded = 0;
var drInfo = new ProviderDAC().RetrieveActivityImageInformation(ActivityID);
CheckActivityImage();
if (fileUpload1.HasFile) // CHECK IF ANY FILE HAS BEEN SELECTED.
{
var dt = new ProviderEDSC.ActivityImageDetailDTDataTable();
if (System.Text.RegularExpressions.Regex.IsMatch(fileUpload1.PostedFile.ContentType, "image/\\S+"))
{
int iFailedCnt = 0;
HttpFileCollection hfc = Request.Files;
lblUploadStatus.Text = "Select <b>" + hfc.Count + "</b> file(s)";
if (hfc.Count <= 10) // 10 FILES RESTRICTION.
{
for (int i = 0; i <= hfc.Count - 1; i++)
{
HttpPostedFile hpf = hfc[i];
if (hpf.ContentLength > 0)
{
string sFileName = Path.GetFileName(hpf.FileName);
string sFileExt = Path.GetExtension(hpf.FileName);
SizeUploaded = SizeUploaded + Convert.ToInt32(hpf.ContentLength / 1024);
if (SizeUploaded <= drInfo.FreeStorage)
{
var dr = dt.NewActivityImageDetailDTRow();
dr.ActivityID = ActivityID;
dr.ActivityImageID = drInfo.ID;
dr.ImageStream = new BCUtility.ImageHandler().ReadFully(hpf.InputStream);
dr.Filename = sFileName;
dr.Filesize = hpf.ContentLength / 1024;
dr.ImageTitle = "";
dr.Description = "";
dt.AddActivityImageDetailDTRow(dr);
ImageUploaded += 1;
}
else
{
iFailedCnt += 1;
lblUploadStatus.Text += "</br><b>" + iFailedCnt + "</b> file(s) could not be uploaded. Maximum Size per activity is" + SystemConstants.MaxActivityImageStorage + " Kb";
}
}
}
lblUploadStatus.Text = "<b>" + ImageUploaded + "</b> file(s) uploaded.";
}
else
{
lblUploadStatus.Text = "Max. 10 files allowed.";
}
if (ImageUploaded > 0)
{
drInfo.ImageAmount = drInfo.ImageAmount + ImageUploaded;
drInfo.StorageUsed = drInfo.StorageUsed + SizeUploaded;
drInfo.FreeStorage = SystemConstants.MaxActivityImageStorage - drInfo.StorageUsed;
divUploadSuccessfull.Visible = true;
new ProviderBFC().CreateActivityImages(ActivityID, drInfo, dt);
}
}
else
{
lblUploadStatus.Text = "Only image files are accepted.";
}
}
else
{
lblUploadStatus.Text = "No files selected.";
}
lblUploadStatus.Visible = true;
Refresh();
}
