public DataSet Select_Data(tbl_EventMasterProp Objtbl_EventMasterProp, ref int PageCount)
{
try {
if (Objtbl_EventMasterProp.EventCode != 0)
{
Objtbl_EventMasterProp.PageNo = 1;
Objtbl_EventMasterProp.RecordCount = 1;
}
int RecordCount = 0;
tbl_EventMasterDAL Objtbl_EventMasterDAL = new tbl_EventMasterDAL();
DataSet dsData = Objtbl_EventMasterDAL.Select_Data(Objtbl_EventMasterProp, ref RecordCount);
double Page = Convert.ToDouble(RecordCount) / Convert.ToDouble(Objtbl_EventMasterProp.RecordCount);
if (dsData.Tables[0].Rows.Count > 0)
{
string[] PageDecimal = Page.ToString().Split('.');
if (PageDecimal.Length > 1 && Convert.ToInt32(PageDecimal[1]) > 0)
{
PageCount = Convert.ToInt32(Page.ToString().Split('.')[0]) + 1;
}
else
{
PageCount = Convert.ToInt32(Page);
}
}
else
{
PageCount = 0;
}
return(dsData);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Search_Data(tbl_EventMasterProp Objtbl_EventMasterProp)
{
try {
tbl_EventMasterDAL Objtbl_EventMasterDAL = new tbl_EventMasterDAL();
return(Objtbl_EventMasterDAL.Search_Data(Objtbl_EventMasterProp));
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete_Data(tbl_EventMasterProp Objtbl_EventMasterProp)
{
try {
tbl_EventMasterDAL Objtbl_EventMasterDAL = new tbl_EventMasterDAL();
return(Objtbl_EventMasterDAL.Delete_Data(Objtbl_EventMasterProp));
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete_Data(tbl_EventMasterProp Objtbl_EventMasterProp)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("Delete_tbl_EventMaster");
DB.AddInParameter(DBCmd, "@EventCode", DbType.Int32, Objtbl_EventMasterProp.EventCode);
return(DB.ExecuteNonQuery(DBCmd));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Search_Data(tbl_EventMasterProp Objtbl_EventMasterProp)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("Search_tbl_EventMaster");
DB.AddInParameter(DBCmd, "@SearchBy", DbType.String, Objtbl_EventMasterProp.SearchBy);
DB.AddInParameter(DBCmd, "@SearchVal", DbType.String, Objtbl_EventMasterProp.SearchVal);
return(DB.ExecuteDataSet(DBCmd));
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
}
public DataSet Select_Data(tbl_EventMasterProp Objtbl_EventMasterProp, ref int TotalCount)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("Select_tbl_EventMaster");
DB.AddInParameter(DBCmd, "@EventCode", DbType.Int32, Objtbl_EventMasterProp.EventCode);
DB.AddInParameter(DBCmd, "@PageNo", DbType.Int32, Objtbl_EventMasterProp.PageNo);
DB.AddInParameter(DBCmd, "@RecordCount", DbType.Int32, Objtbl_EventMasterProp.RecordCount);
DB.AddOutParameter(DBCmd, "@TotalCount", DbType.Int32, 18);
DataSet dsData = DB.ExecuteDataSet(DBCmd);
TotalCount = Convert.ToInt32(DBCmd.Parameters["@TotalCount"].Value);
return(dsData);
}
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;
}
}
public int InsertUpdate_Data(tbl_EventMasterProp Objtbl_EventMasterProp)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("InsertUpdate_tbl_EventMaster");
DB.AddInParameter(DBCmd, "@EventCode", DbType.Int32, Objtbl_EventMasterProp.EventCode);
DB.AddInParameter(DBCmd, "@EventName", DbType.String, Objtbl_EventMasterProp.EventName);
DB.AddInParameter(DBCmd, "@EventStartDate", DbType.DateTime, Objtbl_EventMasterProp.EventStartDate);
DB.AddInParameter(DBCmd, "@EventEndDate", DbType.DateTime, Objtbl_EventMasterProp.EventEndDate);
DB.AddInParameter(DBCmd, "@EventDescription", DbType.String, Objtbl_EventMasterProp.EventDescription);
DB.AddInParameter(DBCmd, "@Charges", DbType.Int32, Objtbl_EventMasterProp.Charges);
DB.AddInParameter(DBCmd, "@FilePath", DbType.String, Objtbl_EventMasterProp.FilePath);
DB.AddOutParameter(DBCmd, "@RetVal", DbType.Int32, 18);
DB.ExecuteNonQuery(DBCmd);
return(Convert.ToInt32(DBCmd.Parameters["@RetVal"].Value));
}
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);
}
}
