private void btnSave_Click(object sender, EventArgs e) { ELUnit objELUnit = new ELUnit(); DLUnit objDLUnit = new DLUnit(); int newID = 0; if (lblUnitID.Text.Length > 0) { objELUnit.ID = Convert.ToInt32(lblUnitID.Text); } else { newID = Common.GetNewID(tableName); objELUnit.ID = newID; } objELUnit.Code = txtCode.Text; objELUnit.Name = txtName.Text; objELUnit.Creator = 0; objELUnit.Created = DateTime.Now; objELUnit.IsActive = false; if (chkIsActive.Checked) objELUnit.IsActive = true; if (Validations()) { if (objDLUnit.Add(objELUnit) > 0) { MessageBox.Show("Record Inserted"); // ClearControls(); } else { MessageBox.Show("Record not Inserted"); } } }
public ELUnit FetchUnitsByID(int ID) { SqlCommand cmd; string qry = ""; ELUnit ObjELUnit = new ELUnit(); SqlDataReader dr; try { conn.CreatConnection(); qry = "SELECT * FROM Unit WHERE ID =@ID"; cmd = new SqlCommand(qry, conn.con); SqlParameter param; param = new SqlParameter("@id", SqlDbType.Int); param.Direction = ParameterDirection.Input; param.Value = ID; cmd.Parameters.Add(param); foreach (SqlParameter Parameter in cmd.Parameters) { if (Parameter.Value == null) { Parameter.Value = DBNull.Value; } } dr = cmd.ExecuteReader(); if (dr.HasRows) { dr.Read(); ObjELUnit.ID = Convert.ToInt32(dr["id"]); ObjELUnit.Code = dr["Code"].ToString(); ObjELUnit.Name = dr["Name"].ToString(); ObjELUnit.IsActive = Convert.ToBoolean(dr["IsActive"]); ObjELUnit.Creator = Convert.ToInt32(dr["Creator"]); ObjELUnit.Created = Convert.ToDateTime(dr["Created"]); } dr.Close(); return ObjELUnit; } catch (Exception ex) { UtilityLayer.Common.ErrorLog(DateTime.Now.ToString() + ex.Message + " " + ex.StackTrace + " " + "DLUnit - FetchUnitsByID"); return null; } finally { conn.CloseConnection(); } }
private void gvUnit_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex > 0) { string strCode = gvUnit.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); string unitID = gvUnit.Rows[e.RowIndex].Cells[0].Value.ToString(); ELUnit objELUnit = new ELUnit(); DLUnit objDLUnit = new DLUnit(); objELUnit = objDLUnit.FetchUnitsByID(Convert.ToInt32(unitID)); if (objELUnit != null) { lblUnitID.Text = objELUnit.ID.ToString(); txtCode.Text = objELUnit.Code; txtName.Text = objELUnit.Name; chkIsActive.Checked = Convert.ToBoolean(objELUnit.IsActive); } } gvUnit.Visible = false; }
public int Add(ELUnit objELUnit) { int retValue = 0; SqlCommand cmd; string qry = ""; object value; try { conn.CreatConnection(); qry = ""; qry = "SELECT COUNT(ID) FROM Unit WHERE ID =@ID "; cmd = new SqlCommand(qry, conn.con); SqlParameter param; param = new SqlParameter("@ID", SqlDbType.Int); param.Direction = ParameterDirection.Input; param.Value = objELUnit.ID; cmd.Parameters.Add(param); foreach (SqlParameter Parameter in cmd.Parameters) { if (Parameter.Value == null) { Parameter.Value = DBNull.Value; } } value = cmd.ExecuteScalar(); if (value != null && value.ToString() != "0") { qry = ""; qry = "UPDATE Unit SET Code=@Code, Name =@Name,IsActive=@IsActive WHERE ID=@ID"; cmd = new SqlCommand(qry, conn.con); param = new SqlParameter("@ID", SqlDbType.Int); param.Direction = ParameterDirection.Input; param.Value = objELUnit.ID; cmd.Parameters.Add(param); param = new SqlParameter("@Code", SqlDbType.NVarChar); param.Direction = ParameterDirection.Input; param.Value = objELUnit.Code; cmd.Parameters.Add(param); param = new SqlParameter("@Name", SqlDbType.NVarChar); param.Direction = ParameterDirection.Input; param.Value = objELUnit.Name; cmd.Parameters.Add(param); param = new SqlParameter("@isActive", SqlDbType.Bit); param.Direction = ParameterDirection.Input; param.Value = objELUnit.IsActive; cmd.Parameters.Add(param); foreach (SqlParameter Parameter in cmd.Parameters) { if (Parameter.Value == null) { Parameter.Value = DBNull.Value; } } retValue = cmd.ExecuteNonQuery(); } else { qry = ""; qry = "INSERT INTO Unit (ID, CODE, NAME, CREATOR , CREATED, ISACTIVE) " + " VALUES(@ID, @Code, @Name, @Creator, @Created, @IsActive) "; cmd = new SqlCommand(qry, conn.con); param = new SqlParameter("@ID", SqlDbType.Int); param.Direction = ParameterDirection.Input; param.Value = objELUnit.ID; cmd.Parameters.Add(param); param = new SqlParameter("@Code", SqlDbType.NVarChar); param.Direction = ParameterDirection.Input; param.Value = objELUnit.Code; cmd.Parameters.Add(param); param = new SqlParameter("@Name", SqlDbType.NVarChar); param.Direction = ParameterDirection.Input; param.Value = objELUnit.Name; cmd.Parameters.Add(param); param = new SqlParameter("@Creator", SqlDbType.Int); param.Direction = ParameterDirection.Input; param.Value = objELUnit.Creator; cmd.Parameters.Add(param); param = new SqlParameter("@Created", SqlDbType.DateTime); param.Direction = ParameterDirection.Input; param.Value = objELUnit.Created; cmd.Parameters.Add(param); param = new SqlParameter("@isActive", SqlDbType.Bit); param.Direction = ParameterDirection.Input; param.Value = objELUnit.IsActive; cmd.Parameters.Add(param); foreach (SqlParameter Parameter in cmd.Parameters) { if (Parameter.Value == null) { Parameter.Value = DBNull.Value; } } retValue = cmd.ExecuteNonQuery(); } } catch (Exception ex) { UtilityLayer.Common.ErrorLog(DateTime.Now.ToString() + ex.Message + " " + ex.StackTrace + " " + "DLUnit - Add"); return 0; } finally { conn.CloseConnection(); } return retValue; }