コード例 #1
0
 /// <summary>
 /// To edit content developer details in grid
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void lnkEdit_Click(object sender, EventArgs e)
 {
     LinkButton  lnk       = sender as LinkButton;
     GridViewRow row       = (GridViewRow)lnk.Parent.Parent;
     int         Idx       = row.RowIndex;
     int         IntResult = 0;
     bool        Status;
     int         VenID;
     VendorBAL   VendorBAL   = new VendorBAL();
     LinkButton  lblIsActive = (GrdVendor.Rows[Idx].FindControl("lnkEdit") as LinkButton);
     Label       lblStatus   = (GrdVendor.Rows[Idx].FindControl("lnkStatus") as Label);
     {
         if (lblStatus.Text == "Active" || lblStatus.Text == "True")
         {
             Status           = false;
             lblStatus.Text   = "InActive";
             lblIsActive.Text = "Activate";
         }
         else
         {
             Status           = true;
             lblStatus.Text   = "Active";
             lblIsActive.Text = "Deactivate";
         }
         VenID            = Convert.ToInt32(lnk.CommandArgument.ToString());
         lblSelectID.Text = VenID.ToString();
         Session["VenID"] = lblSelectID.Text;
         IntResult        = VendorBAL.UpdateVendor(VenID, Status, LoginUser, Ret);
     }
 }
コード例 #2
0
    /// <summary>
    /// To get specific Vendor details
    /// </summary>
    /// <param name="VenID"></param>
    /// <returns></returns>
    protected DataTable GetUserDetails(int VenID)
    {
        VendorBAL VendorBAL = new VendorBAL();
        DataTable DtGetUser = new DataTable();

        try
        {
            DtGetUser = VendorBAL.SelectVendorID(VenID, LoginUser, Ret);
        }
        catch
        {
            throw;
        }
        finally
        {
            VendorBAL = null;
        }
        return(DtGetUser);
    }
コード例 #3
0
    /// <summary>
    ///  To bind Vendor of 'Active' and 'InActive' Status
    /// </summary>
    /// <returns></returns>
    protected DataTable VenDetails()
    {
        VendorBAL VendorBAL = new VendorBAL();
        DataTable DtVenDet  = new DataTable();

        try
        {
            DtVenDet = VendorBAL.LoadAllVendor(LoginUser, Ret);
        }
        catch
        {
            throw;
        }
        finally
        {
            VendorBAL = null;
        }
        return(DtVenDet);
    }
コード例 #4
0
    /// <summary>
    /// To Load Active Status Vedor details from 'Vendor Business Access Layer'
    /// </summary>
    /// <param name="IsActive"></param>
    /// <returns></returns>
    protected DataTable VenActiveDetails(bool IsActive)
    {
        VendorBAL VendorBAL   = new VendorBAL();
        DataTable DtVenActDet = new DataTable();

        try
        {
            DtVenActDet = VendorBAL.LoadActiveVendor(LoginUser, Ret, IsActive);
        }
        catch
        {
            throw;
        }
        finally
        {
            VendorBAL = null;
        }

        return(DtVenActDet);
    }
コード例 #5
0
    /// <summary>
    /// To save Vendor details
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnSave_Click(object sender, EventArgs e)
    {
        VendorBAL VendorBAL = new VendorBAL();
        int       UserID    = Convert.ToInt32(ddlVenUser.SelectedValue.ToString());
        string    Status    = ddlVenStatus.SelectedValue.ToString();
        bool      IsActive  = true;

        if (Status == "Active")
        {
            IsActive = true;
        }
        else if (Status == "InActive")
        {
            IsActive = false;
        }
        if (btnSave.Text == "Save")
        {
            try
            {
                int Result = VendorBAL.InsertVendor(UserID, IsActive, LoginUser, Ret);
                DtVen = VenDetails();
                ViewState["DtVen"] = DtVen;
                BindVen(DtVen);
                MsgVen.Msg = "Record added successfully";
                MsgVen.showmsg();
            }
            catch (Exception ee)
            {
                if (ee.Message == "Duplicate Entry")
                {
                    MsgVen.Msg = "Duplicate Entry!";
                    MsgVen.showmsg();
                    ClearVen();
                }
            }
            finally
            {
                VendorBAL = null;
            }
        }
    }
コード例 #6
0
 /// <summary>
 ///  To bind Vendor of 'Active' and 'InActive' Status
 /// </summary>
 /// <returns></returns>
 protected DataTable VenDetails()
 {
     VendorBAL VendorBAL = new VendorBAL();
     DataTable DtVenDet = new DataTable();
     try
     {
         DtVenDet = VendorBAL.LoadAllVendor(LoginUser, Ret);
     }
     catch
     {
         throw;
     }
     finally
     {
         VendorBAL = null;
     }
     return DtVenDet;
 }
コード例 #7
0
    /// <summary>
    /// To Load Active Status Vedor details from 'Vendor Business Access Layer'
    /// </summary>
    /// <param name="IsActive"></param>
    /// <returns></returns>
    protected DataTable VenActiveDetails(bool IsActive)
    {
        VendorBAL VendorBAL = new VendorBAL();
        DataTable DtVenActDet = new DataTable();
        try
        {
            DtVenActDet = VendorBAL.LoadActiveVendor(LoginUser, Ret, IsActive);
        }
        catch
        {
            throw;
        }
        finally
        {
            VendorBAL = null;
        }

        return DtVenActDet;
    }
コード例 #8
0
 /// <summary>
 /// To edit content developer details in grid
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void lnkEdit_Click(object sender, EventArgs e)
 {
     LinkButton lnk = sender as LinkButton;
     GridViewRow row = (GridViewRow)lnk.Parent.Parent;
     int Idx = row.RowIndex;
     int IntResult = 0;
     bool Status;
     int VenID;
     VendorBAL VendorBAL = new VendorBAL();
     LinkButton lblIsActive = (GrdVendor.Rows[Idx].FindControl("lnkEdit") as LinkButton);
     Label lblStatus = (GrdVendor.Rows[Idx].FindControl("lnkStatus") as Label);
     {
         if (lblStatus.Text == "Active" || lblStatus.Text == "True")
         {
             Status = false;
             lblStatus.Text = "InActive";
             lblIsActive.Text = "Activate";
         }
         else
         {
             Status = true;
             lblStatus.Text = "Active";
             lblIsActive.Text = "Deactivate";
         }
         VenID = Convert.ToInt32(lnk.CommandArgument.ToString());
         lblSelectID.Text = VenID.ToString();
         Session["VenID"] = lblSelectID.Text;
         IntResult = VendorBAL.UpdateVendor(VenID, Status, LoginUser, Ret);
     }
 }
コード例 #9
0
 /// <summary>
 /// To get specific Vendor details 
 /// </summary>
 /// <param name="VenID"></param>
 /// <returns></returns>
 protected DataTable GetUserDetails(int VenID)
 {
     VendorBAL VendorBAL = new VendorBAL();
     DataTable DtGetUser = new DataTable();
     try
     {
         DtGetUser = VendorBAL.SelectVendorID(VenID, LoginUser, Ret);
     }
     catch
     {
         throw;
     }
     finally
     {
         VendorBAL = null;
     }
     return DtGetUser;
 }
コード例 #10
0
 /// <summary>
 /// To save Vendor details 
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void btnSave_Click(object sender, EventArgs e)
 {
     VendorBAL VendorBAL = new VendorBAL();
     int UserID = Convert.ToInt32(ddlVenUser.SelectedValue.ToString());
     string Status = ddlVenStatus.SelectedValue.ToString();
     bool IsActive = true;
     if (Status == "Active")
     {
         IsActive = true;
     }
     else if (Status == "InActive")
     {
         IsActive = false;
     }
     if (btnSave.Text == "Save")
     {
         try
         {
             int Result = VendorBAL.InsertVendor(UserID, IsActive, LoginUser, Ret);
             DtVen = VenDetails();
             ViewState["DtVen"] = DtVen;
             BindVen(DtVen);
             MsgVen.Msg = "Record added successfully";
             MsgVen.showmsg();
         }
         catch (Exception ee)
         {
             if (ee.Message == "Duplicate Entry")
             {
                 MsgVen.Msg = "Duplicate Entry!";
                 MsgVen.showmsg();
                 ClearVen();
             }
         }
         finally
         {
             VendorBAL = null;
         }
     }
 }