public void setDefault()
 {
     btnSave.Visible = true;
     btnEdit.Visible = false;
     txtVariName.Focus();
     txtVariName.Text = "";
     Ob = SetValue();
     grdSearchResult.DataSource = BAL.BALFactory.Instance.BAL_Variation.BindGrid(Ob);
     grdSearchResult.DataBind();
 }
 public DTO.Variation SetValue()
 {
     Ob = new DTO.Variation();
     Ob.VariationName = txtVariName.Text.ToUpper();
     Ob.Active        = 1;
     Ob.DateModified  = Globals.date[0].ToString();
     Ob.BranchId      = Globals.BranchID;
     Ob.VariationId   = lblvariation.Text;
     return(Ob);
 }
Exemple #3
0
        public string Deletevariation(DTO.Variation Ob)
        {
            SqlCommand cmd = new SqlCommand();
            string     res = string.Empty;

            cmd.CommandText = "Sp_Variation";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@VariationId", Ob.VariationId);
            cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
            cmd.Parameters.AddWithValue("@Flag", 6);
            res = PrjClass.ExecuteNonQuery(cmd);
            return(res);
        }
Exemple #4
0
        public DataSet BindGridView(DTO.Variation Ob)
        {
            SqlCommand cmd = new SqlCommand();
            DataSet    ds  = new DataSet();

            cmd.CommandText = "Sp_Variation";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@VariationName", Ob.VariationName);
            cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
            cmd.Parameters.AddWithValue("@Flag", 5);
            ds = PrjClass.GetData(cmd);
            return(ds);
        }
Exemple #5
0
        public DataSet BindGrid(DTO.Variation Ob)
        {
            ArrayList  date = DAL.DALFactory.Instance.DAL_DateAndTime.getDateAndTimeAccordingToZoneTime(Ob.BranchId);
            DataSet    ds   = new DataSet();
            SqlCommand cmd  = new SqlCommand();

            cmd.CommandText = "Sp_Variation";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
            cmd.Parameters.AddWithValue("@Flag", 4);
            ds = PrjClass.GetData(cmd);
            return(ds);
        }
Exemple #6
0
        public string SaveVariation(DTO.Variation Ob)
        {
            string     res = "";
            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = "Sp_Variation";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@VariationName", Ob.VariationName);
            cmd.Parameters.AddWithValue("@Active", Ob.Active);
            cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
            cmd.Parameters.AddWithValue("@Flag", 1);
            res = PrjClass.ExecuteNonQuery(cmd);
            return(res);
        }
 public string SaveVariation(DTO.Variation Ob)
 {
     return(DAL.DALFactory.Instance.DAL_Variation.SaveVariation(Ob));
 }
 public string Deletevariation(DTO.Variation Ob)
 {
     return(DAL.DALFactory.Instance.DAL_Variation.Deletevariation(Ob));
 }
 public DataSet BindGridView(DTO.Variation Ob)
 {
     return(DAL.DALFactory.Instance.DAL_Variation.BindGridView(Ob));
 }
 protected void btnSearch_Click(object sender, EventArgs e)
 {
     Ob = SetValue();
     grdSearchResult.DataSource = BAL.BALFactory.Instance.BAL_Variation.BindGridView(Ob);
     grdSearchResult.DataBind();
 }