private void InsUpdDelGender(char Event, int id) { var msg = ""; if (Event == 'I' || Event == 'U') { var objGender = new GenderClass(id, txtGender.Text); msg = BL_Gender.InsUpdDelGender(Event, objGender, out id); } else { var objGender = new GenderClass(id, ""); msg = BL_Gender.InsUpdDelGender(Event, objGender, out id); } if (DatabaseMessage.ContainMessage(msg)) { _msgBox.ShowSuccess(msg); } else { _msgBox.ShowWarning(msg); } FillGridView(); ClearAll(); }
public static List <GenderClass> GetGender(int Event, int id, string code, string code1) { var lst = new List <GenderClass>(); var dt = DlGender.GetGender(Event, id, code, code1); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { var obj = new GenderClass(Convert.ToInt32(dr["Id"]), dr["Category"].ToString()); lst.Add(obj); } } return(lst); }
private void addButton_Click(object sender, EventArgs e) { if (!validate()) { return; } MemberModel member = new MemberModel() { MemberNo = memberNoTextBox.Text, Name = nameTextBox.Text, Address = addressTextBox.Text, RegDate = regDatePicker.Value, Gender = GenderClass.getGenderType(genderComboBox.SelectedIndex), Nic = nicMaskedTextBox.Text, Dob = dobDatePicker.Value, Tel = telMaskedTextBox.Text, }; SuretyModel surety = new SuretyModel() { Name = suretyNameTextBox.Text, Address = suretyAddressTextBox.Text, Tel = suretyTelMaskedTexBox.Text }; try { MemberController.addMemberSurety(member, surety); MessageBox.Show("Member is successfully entered.", "Add Member", MessageBoxButtons.OK, MessageBoxIcon.Information ); initDefault(); } catch (SqlException ex) { MessageBox.Show(ex.Message); } }
public static string InsUpdDelGender(char Event, GenderClass obj, out int returnId) { returnId = 0; try { var cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "USP_IUD_tbl_Gender"; cmd.Connection = DL_CCommon.ConnectionForCommonDb(); cmd.Parameters.AddWithValue("@EVENT", Event); cmd.Parameters.AddWithValue("@ID", obj.Id); cmd.Parameters.AddWithValue("@Gender", obj.Gender); var outparameter = new SqlParameter("@MSG", SqlDbType.NVarChar, 200) { Direction = ParameterDirection.Output }; cmd.Parameters.Add(outparameter); var outId = new SqlParameter("@RETURNOUTID", SqlDbType.NVarChar, 100) { Direction = ParameterDirection.Output }; cmd.Parameters.Add(outId); cmd.ExecuteNonQuery(); var msg = cmd.Parameters[outparameter.ParameterName].Value; returnId = Convert.ToInt32(cmd.Parameters[outId.ParameterName].Value); return(Convert.ToString(msg)); } catch (Exception ex) { throw new ArgumentException(ex.Message); } finally { DL_CCommon.ConnectionForCommonDb().Close(); } }
public static string InsUpdDelGender(char Event, GenderClass obj, out int id) { id = 0; return(DlGender.InsUpdDelGender(Event, obj, out id)); }