private void DeleteData(int EventCode)
{
try
{
tbl_EventMasterProp Objtbl_EventMasterProp = new tbl_EventMasterProp();
Objtbl_EventMasterProp.EventCode = EventCode;
tbl_EventMasterBAL Objtbl_EventMasterBAL = new tbl_EventMasterBAL();
Objtbl_EventMasterBAL.Delete_Data(Objtbl_EventMasterProp);
FillData();
}
catch (Exception ex)
{
throw ex;
}
}
private void EditData(int EventCode)
{
try
{
tbl_EventMasterProp Objtbl_EventMasterProp = new tbl_EventMasterProp();
Objtbl_EventMasterProp.EventCode = EventCode;
int PageCount = 0;
tbl_EventMasterBAL Objtbl_EventMasterBAL = new tbl_EventMasterBAL();
DataSet dsData = Objtbl_EventMasterBAL.Select_Data(Objtbl_EventMasterProp, ref PageCount);
txtEventName.Text = Convert.ToString(dsData.Tables[0].Rows[0]["EventName"]);
ViewState["EditCode"] = EventCode;
}
catch (Exception ex)
{
throw ex;
}
}
private void FillData()
{
try
{
int PageCount = 0;
tbl_EventMasterProp Objtbl_EventMasterProp = new tbl_EventMasterProp();
Objtbl_EventMasterProp.EventCode = 0;
Objtbl_EventMasterProp.PageNo = Convert.ToInt32(txtCurPage.Text);
Objtbl_EventMasterProp.RecordCount = Convert.ToInt32(20);
tbl_EventMasterBAL Objtbl_EventMasterBAL = new tbl_EventMasterBAL();
DataSet dsData = Objtbl_EventMasterBAL.Select_Data(Objtbl_EventMasterProp, ref PageCount);
lblTotalPage.Text = Convert.ToString(PageCount);
grdData.DataSource = dsData.Tables[0];
grdData.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
protected void imgbtnSave_Click(object sender, ImageClickEventArgs e)
{
string sSavePath = "";
string sFilename = "";
try
{
if (chkDeleteFilePath.Checked == false)
{
// Set constant values
sSavePath = "../EventsFiles/";
// If file field isn’t empty
if (flFilePath.PostedFile != null && flFilePath.PostedFile.ContentLength > 0)
{
// Check file size (mustn’t be 0)
HttpPostedFile myFile = flFilePath.PostedFile;
int nFileLen = myFile.ContentLength;
if (nFileLen == 0)
{
ShowGuidMessage(0, new Exception("No file was uploaded."));
return;
}
// Check file extension (must be JPG or pdf)
if (System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".jpg" || System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".pdf")
{
ShowGuidMessage(0, new Exception("The file must have an extension of JPG or pdf"));
return;
}
// Read file into a data stream
byte[] myData = new Byte[nFileLen];
myFile.InputStream.Read(myData, 0, nFileLen);
// Make sure a duplicate file doesn’t exist. If it does, keep on appending an
// incremental numeric until it is unique
sFilename = System.IO.Path.GetFileName(myFile.FileName);
int file_append = 0;
while (System.IO.File.Exists(Server.MapPath(sSavePath + sFilename)))
{
file_append++;
sFilename = System.IO.Path.GetFileNameWithoutExtension(myFile.FileName)
+ file_append.ToString() + System.IO.Path.GetExtension(myFile.FileName).ToLower();
}
// Save the stream to disk
System.IO.FileStream newFile = new System.IO.FileStream(Server.MapPath(sSavePath + sFilename),
System.IO.FileMode.Create);
newFile.Write(myData, 0, myData.Length);
newFile.Close();
// Check whether the file is really a JPEG by opening it
System.Drawing.Image.GetThumbnailImageAbort myCallBack =
new System.Drawing.Image.GetThumbnailImageAbort(ThumbnailCallback);
Bitmap myBitmap;
try
{
myBitmap = new Bitmap(Server.MapPath(sSavePath + sFilename));
tdUploadedFile.Visible = true;
tdUploadedFile.InnerHtml = "<a href=\"..\\EventsFiles\\" + "\"" + sSavePath + sFilename + ">Download Attachment</a>";
// Displaying success information
//tdError.InnerText = "File uploaded successfully!";
// Destroy objects
myBitmap.Dispose();
}
catch
{
// The file wasn't a valid jpg file
System.IO.File.Delete(Server.MapPath(sSavePath + sFilename));
ShowGuidMessage(0, new Exception("The file wasn't a valid jpg file"));
return;
}
}
}
if (sFilename == "" && Convert.ToInt32(ViewState["EditCode"]) > 0)
{
sFilename = Convert.ToString(ViewState["FilePath"]);
}
else if (sFilename == "" && Convert.ToInt32(ViewState["EditCode"]) <= 0)
{
sFilename = "-";
}
else if (chkDeleteFilePath.Checked == true)
{
if (Convert.ToInt32(ViewState["EditCode"]) > 0)
{
System.IO.File.Delete(Server.MapPath(sSavePath + Convert.ToString(ViewState["FilePath"])));
}
sFilename = "-";
}
tbl_EventMasterProp Objtbl_EventMasterProp = new tbl_EventMasterProp();
Objtbl_EventMasterProp.EventCode = Convert.ToInt32(ViewState["EditCode"]);
Objtbl_EventMasterProp.EventName = txtEventName.Text;
Objtbl_EventMasterProp.EventStartDate = Convert.ToDateTime(txtEventStartDate.Text);
Objtbl_EventMasterProp.EventEndDate = Convert.ToDateTime(txtEventEndDate.Text);
Objtbl_EventMasterProp.EventDescription = txtEventDescription.Text;
Objtbl_EventMasterProp.Charges = Convert.ToDouble(txtCharges.Text);
Objtbl_EventMasterProp.FilePath = sFilename;
tbl_EventMasterBAL Objtbl_EventMasterBAL = new tbl_EventMasterBAL();
Objtbl_EventMasterBAL.InsertUpdate_Data(Objtbl_EventMasterProp);
ShowGuidMessage(1, null);
mdlPopupNewEntry.Hide();
FillData();
}
catch (Exception ex)
{
ShowGuidMessage(0, ex); //MessageBox.Show(ex.Message);
}
}
