List <MODERATORS> GetDataModerators(SqlCommand cmd)
{
cmd.Connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
List <MODERATORS> list = new List <MODERATORS>();
using (reader)
{
while (reader.Read())
{
MODERATORS obj = new MODERATORS();
obj.ID = reader.GetInt32(0);
obj.NAME = reader.GetString(1);
obj.IMAGE = (byte[])(reader[2]);
MemoryStream memoryStream = new MemoryStream(obj.IMAGE);
obj.GENDER = reader.GetString(3);
obj.ADDRESS = reader.GetString(4);
obj.EMAIL = reader.GetString(5);
obj.CELLPHONE = reader.GetString(6);
obj.JOIN_DATE = reader.GetDateTime(7);
list.Add(obj);
}
reader.Close();
}
cmd.Connection.Close();
return(list);
}
private void button1_Click(object sender, EventArgs e)
{
//insert into moderators
bool flag = false;
BloodBankData bbd = new BloodBankData();
MODERATORS md = new MODERATORS();
md.ID = 5;
md.NAME = textBox1.Text;
md.IMAGE = convertImageToBinary(pictureBox2.BackgroundImage);
md.GENDER = gender;
md.ADDRESS = address;
md.EMAIL = textBox3.Text;
md.CELLPHONE = textBox4.Text;
md.JOIN_DATE = join_date;
flag = bbd.insertModerators(md);
if (flag == true)
{
this.Close();
thread = new Thread(openSignUpSuccessForm);
thread.SetApartmentState(ApartmentState.STA);
thread.Start();
}
else
{
MessageBox.Show("Sign Up Failed!", "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}
public bool insertModerators(MODERATORS obj)
{
int val = 0;
try
{
SqlDbDataAccess da = new SqlDbDataAccess();
SqlCommand cmd = da.GetCommand("INSERT INTO [dbo].[MODERATORS] ([ID],[NAME],[IMAGE], [GENDER], [ADDRESS], [EMAIL], [CELLPHONE], [JOIN_DATE]) VALUES (@ID, @NAME, @IMAGE, @GENDER, @ADDRESS, @EMAIL, @CELLPHONE, @JOIN_DATE)");
SqlParameter p = new SqlParameter("@ID", SqlDbType.Int);
p.Value = obj.ID;
SqlParameter p1 = new SqlParameter("@NAME", SqlDbType.VarChar, 50);
p1.Value = obj.NAME;
SqlParameter p2 = new SqlParameter("@IMAGE", SqlDbType.Image);
p2.Value = obj.IMAGE;
SqlParameter p3 = new SqlParameter("@GENDER", SqlDbType.VarChar, 6);
p3.Value = obj.GENDER;
SqlParameter p4 = new SqlParameter("@ADDRESS", SqlDbType.VarChar, 50);
p4.Value = obj.ADDRESS;
SqlParameter p5 = new SqlParameter("@EMAIL", SqlDbType.VarChar, 50);
p5.Value = obj.EMAIL;
SqlParameter p6 = new SqlParameter("@CELLPHONE", SqlDbType.VarChar, 11);
p6.Value = obj.CELLPHONE;
SqlParameter p7 = new SqlParameter("@JOIN_DATE", SqlDbType.Date);
p7.Value = obj.JOIN_DATE;
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Parameters.Add(p4);
cmd.Parameters.Add(p5);
cmd.Parameters.Add(p6);
cmd.Parameters.Add(p7);
cmd.Connection.Open();
val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
catch (Exception ex)
{
}
return(val > 0);
}
