private void btnSave_Click(object sender, EventArgs e) { ELCompany objEL = new ELCompany(); int newID = 0; if (lblID.Text.Length > 0) { objEL.ID = Convert.ToInt32(lblID.Text); } else { newID = Common.GetNewID(tableName); objEL.ID = newID; } objEL.Code = txtCode.Text; objEL.Name = txtName.Text; objEL.Creator = 0; objEL.Created = DateTime.Now; objEL.IsActive = false; if (chkIsActive.Checked) objEL.IsActive = true; if (Validations()) { if (DLCompany.Add(objEL) > 0) { MessageBox.Show("Record Inserted"); ClearControls(); } else { MessageBox.Show("Record not Inserted"); } } }
public static ELCompany FetchByID(int ID = 0, string Code = "") { SqlCommand cmd; string qry = ""; ELCompany ObjEL = new ELCompany(); SqlDataReader dr; try { conn.CreatConnection(); qry = "SELECT * FROM Company WHERE "; if (Code != "") qry = qry + " code =@Code "; else if (ID > 0) qry = qry + " ID =@ID"; else qry = qry + " 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); param = new SqlParameter("@Code", SqlDbType.Int); param.Direction = ParameterDirection.Input; param.Value = Code; 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(); ObjEL.ID = Convert.ToInt32(dr["id"]); ObjEL.Code = dr["Code"].ToString(); ObjEL.Name = dr["Name"].ToString(); ObjEL.IsActive = Convert.ToBoolean(dr["IsActive"]); ObjEL.Creator = Convert.ToInt32(dr["Creator"]); ObjEL.Created = Convert.ToDateTime(dr["Created"]); } dr.Close(); return ObjEL; } catch (Exception ex) { UtilityLayer.Common.ErrorLog(DateTime.Now.ToString() + ex.Message + " " + ex.StackTrace + " " + "DLCompany - FetchByID"); return null; } finally { conn.CloseConnection(); } }
public static int Add(ELCompany objEL) { int retValue = 0; SqlCommand cmd; string qry = ""; object value; try { conn.CreatConnection(); qry = ""; qry = "SELECT COUNT(ID) FROM Company WHERE ID =@ID "; cmd = new SqlCommand(qry, conn.con); SqlParameter param; param = new SqlParameter("@ID", SqlDbType.Int); param.Direction = ParameterDirection.Input; param.Value = objEL.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 Company 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 = objEL.ID; cmd.Parameters.Add(param); param = new SqlParameter("@Code", SqlDbType.NVarChar); param.Direction = ParameterDirection.Input; param.Value = objEL.Code; cmd.Parameters.Add(param); param = new SqlParameter("@Name", SqlDbType.NVarChar); param.Direction = ParameterDirection.Input; param.Value = objEL.Name; cmd.Parameters.Add(param); param = new SqlParameter("@isActive", SqlDbType.Bit); param.Direction = ParameterDirection.Input; param.Value = objEL.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 Company (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 = objEL.ID; cmd.Parameters.Add(param); param = new SqlParameter("@Code", SqlDbType.NVarChar); param.Direction = ParameterDirection.Input; param.Value = objEL.Code; cmd.Parameters.Add(param); param = new SqlParameter("@Name", SqlDbType.NVarChar); param.Direction = ParameterDirection.Input; param.Value = objEL.Name; cmd.Parameters.Add(param); param = new SqlParameter("@Creator", SqlDbType.Int); param.Direction = ParameterDirection.Input; param.Value = objEL.Creator; cmd.Parameters.Add(param); param = new SqlParameter("@Created", SqlDbType.DateTime); param.Direction = ParameterDirection.Input; param.Value = objEL.Created; cmd.Parameters.Add(param); param = new SqlParameter("@isActive", SqlDbType.Bit); param.Direction = ParameterDirection.Input; param.Value = objEL.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 + " " + "DLCompany - Add"); return 0; } finally { conn.CloseConnection(); } return retValue; }
private void gv_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex > 0) { string strCode = gv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); string ID = gv.Rows[e.RowIndex].Cells[0].Value.ToString(); ELCompany objEL = new ELCompany(); DLCompany objDL = new DLCompany(); objEL = DLCompany.FetchByID(Convert.ToInt32(ID)); if (objEL != null) { lblID.Text = objEL.ID.ToString(); txtCode.Text = objEL.Code; txtName.Text = objEL.Name; chkIsActive.Checked = Convert.ToBoolean(objEL.IsActive); } } }