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));
}
