Beispiel #1
0
 private void GetHandle()
 {
     try
     {
         objAttachmentcls = new AttachmentCls();
         objAttachmentcls.AttachmentHandle = Request.QueryString["ATH"];
         DataTable dt = objAttachmentcls.GetALLHandleByID();
         if (dt.Rows.Count > 0)
         {
             txtAttachmentHandle.Text    = dt.Rows[0]["t_hndl"].ToString();
             txtAcessIndex.Text          = dt.Rows[0]["t_indx"].ToString();
             txtTableName.Text           = dt.Rows[0]["t_tabl"].ToString();
             txtDescription.Text         = dt.Rows[0]["t_tdes"].ToString();
             txtRemarks.Text             = dt.Rows[0]["t_rema"].ToString();
             ddlDBID.SelectedValue       = dt.Rows[0]["t_dbid"].ToString();
             btnSaveHandle.Text          = "Update";
             txtAttachmentHandle.Enabled = false;
             divHeader.InnerText         = "Update Attachment Handle";
         }
         else
         {
             btnSaveHandle.Text = "Save";
         }
     }
     catch (Exception ex)
     {
         ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
     }
 }
Beispiel #2
0
 protected void btnDelete_Click(object sender, EventArgs e)
 {
     try
     {
         objAttachmentcls             = new AttachmentCls();
         objAttachmentcls.LibraryCode = Request.QueryString["LibCode"];
         DataTable dtLibCode = objAttachmentcls.GetLibraryCodeFromDataBase();
         if (dtLibCode.Rows.Count > 0)
         {
             ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Library Code already in used so it is not deleted');", true);
         }
         else
         {
             int res = objAttachmentcls.DeleteLibrary();
             if (res > 0)
             {
                 ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Deleted Successfully');", true);
             }
             else
             {
                 ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Not Deleted');", true);
             }
         }
     }
     catch (Exception ex)
     {
         // ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('DBID used somewhere');", true);
     }
 }
 protected void lnkDelete_Click(object sender, EventArgs e)
 {
     try
     {
         objAttachmentcls      = new AttachmentCls();
         objAttachmentcls.DBID = Request.QueryString["DBID"];
         DataTable dtUSedDBID = objAttachmentcls.GetDBIDInHandle();
         if (dtUSedDBID.Rows[0]["Dbidcount"].ToString() == "0")
         {
             int res = objAttachmentcls.DeleteDatabase();
             if (res > 0)
             {
                 ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Deleted Successfully');", true);
             }
             else
             {
                 ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Not Deleted');", true);
             }
         }
         else
         {
             ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('DBID used somewhere');", true);
         }
     }
     catch (Exception ex)
     {
     }
 }
Beispiel #4
0
 protected void btnSystemAttachUpload_Click(object sender, EventArgs e)
 {
     if (Request.QueryString["RefHandle"] != null && Request.QueryString["RefIndex"] != null)
     {
         divTransmittalScreen.Visible = true;
         objAttachmentcls             = new AttachmentCls();
         // objAttachmentcls.IndexValue = Request.QueryString["Index"];
         objAttachmentcls.AttachmentHandle = Request.QueryString["RefHandle"];
         objAttachmentcls.IndexValue       = Request.QueryString["RefIndex"];
         DataTable dt = objAttachmentcls.GetExistingAttachment();
         if (dt.Rows.Count > 0)
         {
             // Session["sDocumentId"] = dt.Rows[0]["t_dcid"].ToString();
             //// Session["sFileName"] = dt.Rows[0]["t_fnam"].ToString();
             // Session["sLibCode"] = dt.Rows[0]["t_lbcd"].ToString();
             // Session["sattachedby"] = dt.Rows[0]["t_atby"].ToString();
             divViewExistingAttachment.Visible  = true;
             divExistingAttachNotExists.Visible = false;
             btnCopyAttachment.Visible          = true;
             gvExistingAttachments.DataSource   = dt;
             gvExistingAttachments.DataBind();
         }
         else
         {
             divExistingAttachNotExists.Visible = true;
             divViewExistingAttachment.Visible  = false;
         }
     }
     {
         // No Attachment exists for the provide reference handle and reference Index
     }
 }
Beispiel #5
0
 protected void lnkDelete_Click(object sender, EventArgs e)
 {
     try
     {
         objAttachmentcls             = new AttachmentCls();
         objAttachmentcls.PurposeCode = Request.QueryString["PurposeCode"];
         DataTable dt = objAttachmentcls.GetPurposeCodeCount();
         if (dt.Rows[0]["PurposeCodeCount"].ToString() == "0")
         {
             int res = objAttachmentcls.DeletePurpose();
             if (res > 0)
             {
                 ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Deleted Successfully');", true);
             }
             else
             {
                 ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Not Deleted');", true);
             }
         }
         else
         {
             ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Purpose Code used somewhere');", true);
         }
     }
     catch (Exception ex)
     {
     }
 }
 protected void lnkDownload_Click(object sender, EventArgs e)
 {
     try
     {
         LinkButton    lnkbtn           = (LinkButton)sender;
         string[]      values           = lnkbtn.CommandArgument.Split('&');
         AttachmentCls objAttachmentcls = new AttachmentCls();
         objAttachmentcls.IndexValue = values[2];
         DataTable    dt         = objAttachmentcls.GetPath();
         string       ServerPath = dt.Rows[0]["t_path"].ToString() + "\\" + values[0];// Server.MapPath("~/Files/") + values[0]; // "\\\\" + dt.Rows[0]["ServerName"].ToString() + dt.Rows[0]["Path"].ToString() + values[0];
         WebClient    req        = new WebClient();
         HttpResponse response   = HttpContext.Current.Response;
         response.Clear();
         response.ClearContent();
         response.ClearHeaders();
         response.Buffer = true;
         response.AddHeader("Content-Disposition", "attachment;filename=\"" + values[1] + "\"");
         byte[] data = req.DownloadData(ServerPath);
         response.BinaryWrite(data);
         response.End();
     }
     catch (Exception ex)
     {
         //ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Some Technical issue Data Not Uploaded');", true);
     }
 }
 private void GetDatabase()
 {
     try
     {
         objAttachmentcls      = new AttachmentCls();
         objAttachmentcls.DBID = Request.QueryString["DBID"];
         DataTable dt = objAttachmentcls.GetDBID();
         if (dt.Rows.Count > 0)
         {
             txtDBID.Text                = dt.Rows[0]["t_dbid"].ToString();
             txtDBServerName.Text        = dt.Rows[0]["t_serv"].ToString();
             txtDatabaseName.Text        = dt.Rows[0]["t_dbnm"].ToString();
             txtDBDesc.Text              = dt.Rows[0]["t_desc"].ToString();
             ddlLibrary.SelectedValue    = dt.Rows[0]["t_lbcd"].ToString();
             btnSaveDatabaseDetails.Text = "Update";
             txtDBID.Enabled             = false;
             divHeader.InnerText         = "Update Database";
         }
         else
         {
             btnSaveDatabaseDetails.Text = "Save";
         }
     }
     catch (Exception ex)
     {
         ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
     }
 }
Beispiel #8
0
 protected void lnkDelete_Click(object sender, EventArgs e)
 {
     try
     {
         objAttachmentcls = new AttachmentCls();
         objAttachmentcls.AttachmentHandle = Request.QueryString["ATH"];
         DataTable dtHandle = objAttachmentcls.GetHandleId();
         if (dtHandle.Rows.Count == 0)
         {
             int res = objAttachmentcls.DeleteHandle();
             if (res > 0)
             {
                 ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Deleted Successfully');", true);
             }
             else
             {
                 ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Not Deleted');", true);
             }
         }
         else
         {
             ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Attachment Handle used somewhere');", true);
         }
     }
     catch (Exception ex)
     {
         ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
     }
 }
Beispiel #9
0
 private void GetLibrary()
 {
     try
     {
         objAttachmentcls             = new AttachmentCls();
         objAttachmentcls.LibraryCode = Request.QueryString["LibCode"];
         DataTable dt = objAttachmentcls.GetLibCode();
         if (dt.Rows.Count > 0)
         {
             txtLibraryCode.Text       = dt.Rows[0]["t_lbcd"].ToString();
             txtLibDesc.Text           = dt.Rows[0]["t_desc"].ToString();
             txtPath.Text              = dt.Rows[0]["t_path"].ToString();
             txtServerName.Text        = dt.Rows[0]["t_serv"].ToString();
             ddlIsActive.SelectedValue = dt.Rows[0]["t_acti"].ToString();
             btnSaveLibrary.Text       = "Update";
             txtLibraryCode.Enabled    = false;
             divHeader.InnerText       = "Update Library";
             btnDelete.Visible         = true;
         }
         else
         {
             btnSaveLibrary.Text = "Save";
             btnDelete.Visible   = false;
         }
     }
     catch (Exception ex)
     {
         ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
     }
 }
Beispiel #10
0
 private void BindAllAttachments()
 {
     try
     {
         DataTable dt = new DataTable();
         if (HttpContext.Current.Cache["ALLATHData"] == null)
         {
             objAttachmentcls = new AttachmentCls();
             dt = objAttachmentcls.GetAllAttachments();
             HttpContext.Current.Cache.Insert("ALLATHData", dt, null, DateTime.Now.AddMinutes(20), TimeSpan.Zero);
         }
         else
         {
             dt = (DataTable)HttpContext.Current.Cache["ALLATHData"];
         }
         if (dt.Rows.Count > 0)
         {
             gvAttachment.DataSource = dt;
             gvAttachment.DataBind();
             divNoRecord.Visible       = false;
             divViewAttachment.Visible = true;
         }
         else
         {
             divNoRecord.Visible       = true;
             divViewAttachment.Visible = false;
         }
     }
     catch (System.Exception ex)
     {
         ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
     }
 }
Beispiel #11
0
 protected void lnkDelete_Click(object sender, EventArgs e)
 {
     try
     {
         LinkButton lnkUpdate = (LinkButton)sender;
         objAttachmentcls            = new AttachmentCls();
         objAttachmentcls.DocumentId = lnkUpdate.CommandArgument;
         int res = objAttachmentcls.DeleteAttachment();
         if (res > 0)
         {
             //  File.Delete(Path);
             HttpContext.Current.Cache.Remove("ATHData");
             BindData();
             ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Deleted Successfully');", true);
         }
         else
         {
             ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Not Deleted');", true);
         }
     }
     catch (System.Exception ex)
     {
         // ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('DBID used somewhere');", true);
     }
 }
Beispiel #12
0
        protected void ddlDBID_SelectedIndexChanged(object sender, EventArgs e)
        {
            objAttachmentcls      = new AttachmentCls();
            objAttachmentcls.DBID = ddlDBID.SelectedValue;
            DataTable dt = objAttachmentcls.GetDBID();

            txtDBDescription.Text    = dt.Rows[0]["t_desc"].ToString();
            txtDBDescription.Visible = true;
        }
Beispiel #13
0
 protected void btnSaveDatabaseDetails_Click(object sender, EventArgs e)
 {
     try
     {
         int res = 0;
         if (txtDBID.Text != "" && txtDBServerName.Text != "" && txtDatabaseName.Text != "" && txtDBDesc.Text != "")
         {
             objAttachmentcls               = new AttachmentCls();
             objAttachmentcls.LibraryCode   = ddlLibrary.SelectedValue;
             objAttachmentcls.DBID          = txtDBID.Text.Trim();
             objAttachmentcls.DBServer      = txtDBServerName.Text.Trim();
             objAttachmentcls.DatabaseName  = txtDatabaseName.Text.Trim();
             objAttachmentcls.DBDescription = txtDBDesc.Text.Trim();
             if (btnSaveDatabaseDetails.Text == "Save")
             {
                 DataTable dt = objAttachmentcls.GetDBID();
                 if (dt.Rows.Count == 0)
                 {
                     res = objAttachmentcls.InsertDBdetails();
                     if (res > 0)
                     {
                         ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Saved Successfully');", true);
                     }
                     else
                     {
                         ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Not Saved');", true);
                     }
                 }
                 else
                 {
                     ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('DBID already exist');", true);
                 }
             }
             else
             {
                 res = objAttachmentcls.UpdateDatabase();
                 if (res > 0)
                 {
                     ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Updated Successfully');", true);
                 }
                 else
                 {
                     ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Not Updated');", true);
                 }
             }
         }
         else
         {
             ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Please enter all data');", true);
         }
     }
     catch (Exception ex)
     {
         ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
     }
 }
Beispiel #14
0
        private void BindLibrary()
        {
            objAttachmentcls = new AttachmentCls();
            DataTable dt = objAttachmentcls.GetAllActiveLibrary();

            ddlLibrary.DataSource     = dt;
            ddlLibrary.DataTextField  = "t_lbcd";
            ddlLibrary.DataValueField = "t_lbcd";
            ddlLibrary.DataBind();
        }
Beispiel #15
0
        private void BindPurpose()
        {
            objAttachmentcls = new AttachmentCls();
            DataTable dt = objAttachmentcls.GetALLPurpose();

            ddlPurpose.DataSource     = dt;
            ddlPurpose.DataTextField  = "PurposeDescription";
            ddlPurpose.DataValueField = "PurposeCode";
            ddlPurpose.DataBind();
        }
Beispiel #16
0
        protected void ddlHandle_SelectedIndexChanged(object sender, EventArgs e)
        {
            objAttachmentcls = new AttachmentCls();
            DataTable dt = objAttachmentcls.GetIndexByHandle(ddlHandle.SelectedValue);

            ddlIndex.DataSource     = dt;
            ddlIndex.DataTextField  = "AccessIndex";
            ddlIndex.DataValueField = "AccessIndex";
            ddlIndex.DataBind();
        }
Beispiel #17
0
        private void BindDBID()
        {
            objAttachmentcls = new AttachmentCls();
            DataTable dt = objAttachmentcls.GetALLDBID();

            ddlDBID.DataSource     = dt;
            ddlDBID.DataTextField  = "t_dbid";
            ddlDBID.DataValueField = "t_dbid";
            ddlDBID.DataBind();
            ddlDBID.Items.Insert(0, "Select");
        }
Beispiel #18
0
        //private void BindLibrary()
        //{
        //    objAttachmentcls = new AttachmentCls();
        //    DataTable dt = objAttachmentcls.GetAllActiveLibrary();
        //    ddlLibrary.DataSource = dt;
        //    ddlLibrary.DataTextField = "LibraryCode";
        //    ddlLibrary.DataValueField = "LibraryCode";
        //    ddlLibrary.DataBind();
        //}
        private void BindHandle()
        {
            objAttachmentcls = new AttachmentCls();
            DataTable dt = objAttachmentcls.GetALLHandle();

            ddlHandle.DataSource     = dt;
            ddlHandle.DataTextField  = "Attachment_Handle";
            ddlHandle.DataValueField = "Attachment_Handle";
            ddlHandle.DataBind();
            ddlHandle.Items.Insert(0, "Select");
        }
Beispiel #19
0
 protected void btnSaveHandle_Click(object sender, EventArgs e)
 {
     try
     {
         if (txtAttachmentHandle.Text != "" && txtAcessIndex.Text != "" && txtTableName.Text != "" && ddlDBID.SelectedValue != "Select")
         {
             objAttachmentcls                  = new AttachmentCls();
             objAttachmentcls.DBID             = ddlDBID.SelectedValue;
             objAttachmentcls.AttachmentHandle = txtAttachmentHandle.Text.Trim();
             objAttachmentcls.IndexValue       = txtAcessIndex.Text.Trim();
             objAttachmentcls.TableName        = txtTableName.Text.Trim();
             objAttachmentcls.TableDesc        = txtDescription.Text.Trim();
             objAttachmentcls.Remarks          = txtRemarks.Text.Trim();
             if (btnSaveHandle.Text == "Save")
             {
                 int res = objAttachmentcls.InsertHandle();
                 if (res > 0)
                 {
                     txtAttachmentHandle.Text = "";
                     txtAcessIndex.Text       = "";
                     txtTableName.Text        = "";
                     txtDescription.Text      = "";
                     txtRemarks.Text          = "";
                     ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Saved Successfully');", true);
                 }
                 else
                 {
                     ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Not Saved');", true);
                 }
             }
             else
             {
                 int res = objAttachmentcls.UpdateHandle();
                 if (res > 0)
                 {
                     ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Updated Successfully');", true);
                 }
                 else
                 {
                     ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Not Updated');", true);
                 }
             }
         }
         else
         {
             ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Please enter all data');", true);
         }
     }
     catch (Exception ex)
     {
         ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
     }
 }
Beispiel #20
0
 protected void btnUpload_Click(object sender, EventArgs e)
 {
     if (ddlHandle.SelectedValue != "Select" && ddlIndex.SelectedValue != "")
     {
         objAttachmentcls            = new AttachmentCls();
         objAttachmentcls.IndexValue = ddlIndex.SelectedValue;        // Request.QueryString["Index"];
         DataTable dt         = objAttachmentcls.GetPath();
         string    ServerPath = dt.Rows[0]["Path"].ToString() + "\\"; // "\\\\" + dt.Rows[0]["ServerName"].ToString() + "\\" + dt.Rows[0]["Path"].ToString() + "\\"; // Server.MapPath("~/Files/");//
         if (FileUpload.HasFile)
         {
             int filecount = 0;
             filecount = FileUpload.PostedFiles.Count();
             if (filecount > 0)
             {
                 foreach (HttpPostedFile PostedFile in FileUpload.PostedFiles)
                 {
                     string fileName      = Path.GetFileNameWithoutExtension(PostedFile.FileName);
                     string fileExtension = Path.GetExtension(PostedFile.FileName);
                     try
                     {
                         AttachmentCls objAttachmentcls = new AttachmentCls();
                         objAttachmentcls.AttachmentHandle = ddlHandle.SelectedValue;  // Request.QueryString["AthHandle"];
                         objAttachmentcls.IndexValue       = ddlIndex.SelectedValue;   // Request.QueryString["Index"];
                         objAttachmentcls.PurposeCode      = ddlPurpose.SelectedValue; // Request.QueryString["PurposeCode"];
                         objAttachmentcls.AttachedBy       = "0";                      //Request.QueryString["AttachedBy"];
                         objAttachmentcls.FileName         = fileName + fileExtension;
                         objAttachmentcls.LibraryCode      = dt.Rows[0]["LibCode"].ToString();
                         int nRecord = new Random(Guid.NewGuid().GetHashCode()).Next();
                         objAttachmentcls.RunningId  = nRecord;
                         objAttachmentcls.DocumentId = "AAA" + nRecord.ToString();
                         //DataTable dtDocID = objAttachmentcls.InsertAttachmentdata();
                         DataTable dtDocID = objAttachmentcls.InsertAttachmentdata();  //Change- 27-08-2018 Insert Attachment error related change
                         if (dtDocID.Rows.Count > 0)
                         {
                             PostedFile.SaveAs(ServerPath + dtDocID.Rows[0][0]);
                             ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Successfully Uploaded');", true);
                         }
                     }
                     catch (Exception ex)
                     {
                         ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('" + ex.Message + "');", true);
                     }
                 }
             }
         }
     }
     else
     {
         ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Please select all fields');", true);
     }
 }
Beispiel #21
0
        private void BindGrid()
        {
            objAttachmentcls = new AttachmentCls();
            DataTable dt = objAttachmentcls.GetALLDBID();

            if (dt.Rows.Count > 0)
            {
                gvData.DataSource = dt;
                gvData.DataBind();
            }
            else
            {
                ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data not found');", true);
            }
        }
Beispiel #22
0
 protected void btnSavePurpose_Click(object sender, EventArgs e)
 {
     try
     {
         if (txtPurposeCode.Text != "" && txtPDescription.Text != "")
         {
             objAttachmentcls             = new AttachmentCls();
             objAttachmentcls.PurposeCode = txtPurposeCode.Text.Trim();
             objAttachmentcls.PurposeDesc = txtPDescription.Text.Trim();
             if (btnSavePurpose.Text == "Save")
             {
                 int res = objAttachmentcls.InsertPurpose();
                 if (res > 0)
                 {
                     ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Saved Successfully');", true);
                 }
                 else
                 {
                     ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Not Saved');", true);
                 }
             }
             else
             {
                 int res = objAttachmentcls.UpdatePurpose();
                 if (res > 0)
                 {
                     ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Updated Successfully');", true);
                 }
                 else
                 {
                     ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Not Updated');", true);
                 }
             }
         }
         else
         {
             ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Please enter all data');", true);
         }
     }
     catch (Exception ex)
     {
         ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
     }
 }
Beispiel #23
0
        private void GetPurpose()
        {
            objAttachmentcls             = new AttachmentCls();
            objAttachmentcls.PurposeCode = Request.QueryString["PurposeCode"];
            DataTable dt = objAttachmentcls.GetALLPurposeByID();

            if (dt.Rows.Count > 0)
            {
                txtPurposeCode.Text    = dt.Rows[0]["t_prcd"].ToString();
                txtPDescription.Text   = dt.Rows[0]["t_desc"].ToString();
                btnSavePurpose.Text    = "Update";
                txtPurposeCode.Enabled = false;
                divHeader.InnerText    = "Update Purpose";
            }
            else
            {
                btnSavePurpose.Text = "Save";
            }
        }
Beispiel #24
0
 private void BindGrid()
 {
     try
     {
         objAttachmentcls = new AttachmentCls();
         DataTable dt = objAttachmentcls.GetALLPurpose();
         if (dt.Rows.Count > 0)
         {
             gvData.DataSource = dt;
             gvData.DataBind();
         }
         else
         {
             ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data not found');", true);
         }
     }
     catch (Exception ex)
     {
         ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
     }
 }
Beispiel #25
0
 private void BindData()
 {
     try
     {
         //if (Request.QueryString["AthHandle"] != null)
         //{
         objAttachmentcls = new AttachmentCls();
         objAttachmentcls.AttachmentHandle = ddlHandle.SelectedValue; //Request.QueryString["AthHandle"];
         objAttachmentcls.IndexValue       = ddlIndex.SelectedValue;  // Request.QueryString["Index"];
         DataTable dt = objAttachmentcls.GetAttachments();
         gvAttachment.DataSource = dt;
         gvAttachment.DataBind();
         //}
         //else
         //{
         //    ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('No record found');", true);
         //}
     }
     catch (Exception ex)
     {
         ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
     }
 }
Beispiel #26
0
 protected void btnUpload_Click(object sender, EventArgs e)
 {
     if (Request.QueryString["AthHandle"] != null && Request.QueryString["Index"] != null && Request.QueryString["AttachedBy"] != null)
     {
         objAttachmentcls = new AttachmentCls();
         // objAttachmentcls.IndexValue = Request.QueryString["Index"];
         objAttachmentcls.AttachmentHandle = Request.QueryString["AthHandle"];
         DataTable dt = objAttachmentcls.GetPath();
         if (dt.Rows.Count > 0)
         {
             //string ServerPath = "\\\\" + dt.Rows[0]["ServerName"].ToString() + "\\" + dt.Rows[0]["Path"].ToString() + "\\";  //dt.Rows[0]["Path"].ToString() + "\\";//      // Server.MapPath("~/Files/");//
             string ServerPath = "D:\\" + dt.Rows[0]["t_path"].ToString() + "\\";  //dt.Rows[0]["Path"].ToString() + "\\";//      // Server.MapPath("~/Files/");//
             string LocalPath  = Server.MapPath("~/Files/");
             if (FileUpload.HasFile)
             {
                 int filecount = 0;
                 filecount = FileUpload.PostedFiles.Count();
                 if (filecount > 0)
                 {
                     foreach (HttpPostedFile PostedFile in FileUpload.PostedFiles)
                     {
                         string fileName      = Path.GetFileNameWithoutExtension(PostedFile.FileName);
                         string fileExtension = Path.GetExtension(PostedFile.FileName);
                         try
                         {
                             AttachmentCls objAttachmentcls = new AttachmentCls();
                             objAttachmentcls.AttachmentHandle = Request.QueryString["AthHandle"];
                             objAttachmentcls.IndexValue       = Request.QueryString["Index"];
                             objAttachmentcls.PurposeCode      = "Dmisg134_1_vendor";// Request.QueryString["PurposeCode"];
                             objAttachmentcls.AttachedBy       = Request.QueryString["AttachedBy"];
                             objAttachmentcls.FileName         = fileName + fileExtension;
                             objAttachmentcls.LibraryCode      = dt.Rows[0]["LibCode"].ToString();
                             // DataTable dtFile = objAttachmentcls.GetFileName();
                             //  if (dtFile.Rows.Count == 0)
                             //  {
                             DataTable dtDocID = objAttachmentcls.Insertdata();
                             if (dtDocID.Rows[0][0].ToString() != "0")
                             {
                                 try
                                 {
                                     FileUpload.SaveAs(ServerPath + dtDocID.Rows[0][0]);
                                 }
                                 catch (Exception ex)
                                 {// err.Text = ex.Message;
                                 }
                                 // FileUpload.SaveAs(LocalPath + fileName + fileExtension);
                                 HttpContext.Current.Cache.Remove("ATHData");
                                 BindData();
                                 ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Successfully Uploaded');", true);
                             }
                             else
                             {
                                 //objAttachmentcls = new AttachmentCls();
                                 //objAttachmentcls.DocumentId = dtDocID.Rows[0][0].ToString();
                                 //int res = objAttachmentcls.DeleteAttachment();
                                 ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Attachment Handle does not exist');", true);
                             }
                             //  }
                             //  else
                             //  {
                             //    ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('This file name already exist please change your file name');", true);
                             // }
                         }
                         catch (System.Exception ex)
                         {
                             ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('" + ex.Message + "');", true);
                         }
                     }
                 }
                 else
                 {
                 }
             }
             else
             {
             }
         }
         else
         {
             ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Attachment Handle does not exist');", true);
         }
     }
     else
     {
         ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data not found Properly');", true);
     }
 }
Beispiel #27
0
        private void BindData()
        {
            try
            {
                DataTable dt = new DataTable();
                if (Request.QueryString["RefHandle"] != null && Request.QueryString["RefIndex"] != null)
                {
                    objAttachmentcls = new AttachmentCls();
                    objAttachmentcls.AttachmentHandle = Request.QueryString["AthHandle"];
                    objAttachmentcls.IndexValue       = Request.QueryString["Index"];
                    dt = objAttachmentcls.GetAllExistingAttachments();
                    // HttpContext.Current.Cache.Insert("ATHData", dt, null, DateTime.Now.AddMinutes(20), TimeSpan.Zero);
                    if (dt.Rows.Count > 0)
                    {
                        gvAttachment.DataSource = dt;
                        gvAttachment.DataBind();
                        divNoRecord.Visible = false;
                        //  gvExistingAttachments.Visible = true;
                        divViewAttachment.Visible = true;
                        //  divExistingAttachNotExists.Visible = false;
                    }
                    else
                    {
                        divNoRecord.Visible = true;
                        // divExistingAttachNotExists.Visible = true;
                        divViewAttachment.Visible = false;
                    }
                }

                else if (Request.QueryString["AthHandle"] != null && Request.QueryString["Index"] != null && Request.QueryString["AttachedBy"] != null)
                {
                    if (HttpContext.Current.Cache["ATHData"] == null)
                    {
                        objAttachmentcls = new AttachmentCls();
                        objAttachmentcls.AttachmentHandle = Request.QueryString["AthHandle"];
                        objAttachmentcls.IndexValue       = Request.QueryString["Index"];
                        dt = objAttachmentcls.GetAttachments();
                        HttpContext.Current.Cache.Insert("ATHData", dt, null, DateTime.Now.AddMinutes(20), TimeSpan.Zero);
                    }
                    else
                    {
                        dt = (DataTable)HttpContext.Current.Cache["ATHData"];
                    }
                    if (dt.Rows.Count > 0)
                    {
                        gvAttachment.DataSource = dt;
                        gvAttachment.DataBind();
                        divNoRecord.Visible       = false;
                        divViewAttachment.Visible = true;
                    }
                    else
                    {
                        divNoRecord.Visible       = true;
                        divViewAttachment.Visible = false;
                    }
                }
                // else
                // {

                else
                {
                    ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('No Data found');", true);
                }

                // }
            }
            catch (System.Exception ex)
            {
                ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
            }
        }
Beispiel #28
0
        protected void btnSaveLibrary_Click(object sender, EventArgs e)
        {
            try
            {
                int res = 0;
                if (txtLibraryCode.Text != "" && txtLibDesc.Text != "" && txtPath.Text != "" && txtServerName.Text != "")
                {
                    objAttachmentcls                    = new AttachmentCls();
                    objAttachmentcls.LibraryCode        = txtLibraryCode.Text.Trim();
                    objAttachmentcls.LibraryDescription = txtLibDesc.Text.Trim();
                    objAttachmentcls.Path               = txtPath.Text.Trim();
                    objAttachmentcls.IsActive           = ddlIsActive.SelectedValue;
                    objAttachmentcls.ServerName         = txtServerName.Text.Trim();

                    if (btnSaveLibrary.Text == "Save")
                    {
                        DataTable dt = objAttachmentcls.GetLibCode();
                        if (dt.Rows.Count == 0)
                        {
                            res = objAttachmentcls.InsertLibrary();
                            if (res > 0)
                            {
                                ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Saved Successfully');", true);
                            }
                            else
                            {
                                ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Not Saved');", true);
                            }
                        }
                        else
                        {
                            ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Library Code already exist');", true);
                        }
                    }
                    else
                    {
                        if (ddlIsActive.SelectedValue == "N")
                        {
                            DataTable dtLibCode = objAttachmentcls.GetLibraryCodeFromDataBase();
                            if (dtLibCode.Rows.Count > 0)
                            {
                                ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Library Code Already in used so it is not Deactivated');", true);
                            }
                            else
                            {
                                res = objAttachmentcls.UpdateLibrary();
                            }
                        }
                        else
                        {
                            res = objAttachmentcls.UpdateLibrary();
                        }

                        if (res > 0)
                        {
                            ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Updated Successfully');", true);
                        }
                        else
                        {
                            ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Data Not Updated');", true);
                        }
                    }
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Please enter all data');", true);
                }
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
            }
        }