Beispiel #1
0
 public UnitOfMeasures isUserExisting(string sizes)
 {
     DataTable dt = new DataTable("Category");
     dt.Clear();
     string query = "SELECT * FROM UnitOfMeasures where UnitOfMeasure='" + sizes + "'";
     dt = DataAccess.DBAdapter.GetRecordSet(query);
     UnitOfMeasures log = null;
     if (dt.Rows.Count > 0)
     {
         log = new UnitOfMeasures(dt.Rows[0]);
     }
     return log;
 }
Beispiel #2
0
        public string insertMeasures(UnitOfMeasures cats)
        {
            string Message = string.Empty;
            int result = 0;
            con.Open();
            SqlCommand cmd = new SqlCommand("INSERT INTO [UnitOfMeasures]([UnitOfMeasure]) VALUES (@UnitOfMeasure)", con);
            cmd.Parameters.AddWithValue("@UnitOfMeasure", cats.UnitOfMeasure);

            result = cmd.ExecuteNonQuery();

            con.Close();
            return Message;
        }
 private bool isUserExisting()
 {
     string userid = this.txtUOM.Text;
     busUnitOfMeasure buscat = new busUnitOfMeasure();
     FrameWork.UnitOfMeasures frmcat = new FrameWork.UnitOfMeasures();
     frmcat = buscat.isUserExisting(userid);
     //FrameWork.Employees log = busemp.isUserExisting(userid);
     if (frmcat == null)
     {
         return false;
     }
     else if (userid.Equals(frmcat.UnitOfMeasure))
     {
         return true;
     }
     else
     {
         return false;
     }
 }
        protected void btnSave_Click(object sender, EventArgs e)
        {
            busUnitOfMeasure busuom = new busUnitOfMeasure();
            FrameWork.UnitOfMeasures frmcat = new FrameWork.UnitOfMeasures();
            frmcat.UnitOfMeasure = this.txtUOM.Text;

            isExisting = isUserExisting();
            if (isExisting.Equals(true))
            {
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Unit Of Measure existing')", true);
            }
            else
            {
                busuom.insertMeasures(frmcat);
            }
            DataTable dt = new DataTable("User");
            dt = busuom.allUOM();
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }
Beispiel #5
0
        private bool isUserExisting()
        {
            string           userid = this.txtUOM.Text;
            busUnitOfMeasure buscat = new busUnitOfMeasure();

            FrameWork.UnitOfMeasures frmcat = new FrameWork.UnitOfMeasures();
            frmcat = buscat.isUserExisting(userid);
            //FrameWork.Employees log = busemp.isUserExisting(userid);
            if (frmcat == null)
            {
                return(false);
            }
            else if (userid.Equals(frmcat.UnitOfMeasure))
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Beispiel #6
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            busUnitOfMeasure busuom = new busUnitOfMeasure();

            FrameWork.UnitOfMeasures frmcat = new FrameWork.UnitOfMeasures();
            frmcat.UnitOfMeasure = this.txtUOM.Text;


            isExisting = isUserExisting();
            if (isExisting.Equals(true))
            {
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Unit Of Measure existing')", true);
            }
            else
            {
                busuom.insertMeasures(frmcat);
            }
            DataTable dt = new DataTable("User");

            dt = busuom.allUOM();
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }