private void btnsave_Click(object sender, EventArgs e)
{
if (txtname.Text == "" || txttown.Text == "" || cmbgender.Text == "" ||
txtbday.Text == "" || txtnic.Text == "" || cmbnationality.Text == "" ||
cmbreligion.Text == "" || txttp.Text == "" || txtemail.Text == "" ||
txtemename.Text == "" || txtemetp.Text == "" || txtrank.Text == "" ||
txtpassword.Text == "" || txtid.Text == "")
{
MessageBox.Show("Please fill the required fields.", "Message", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
}
else
{
SqlCommand sqlcmd = new SqlCommand();
string query = @"INSERT INTO KDUusers(Userid,Userpassword,Name,Birthday,NICno,GenderId,NationalityId,ReligionId,Contactno,Hometown,Emailaddress,Emergencycontactname,
Emergencycontacttelephoneno,UsertypeId,UserstatusId)VALUES(@Userid,@Userpassword,@Name,@Birthday,@NICno,@GenderId,@NationalityId,@ReligionId,@Contactno,@Hometown,@Emailaddress,@Emergencycontactname,
@Emergencycontacttelephoneno,@UsertypeId,@UserstatusId)";
DataAccessLayer.AddParameters(sqlcmd, "@Name", SqlDbType.NVarChar, txtname.Text);
DataAccessLayer.AddParameters(sqlcmd, "@Hometown", SqlDbType.NVarChar, txttown.Text);
DataAccessLayer.AddParameters(sqlcmd, "@Birthday", SqlDbType.Date, txtbday.Text);
DataAccessLayer.AddParameters(sqlcmd, "@NICno", SqlDbType.NVarChar, txtnic.Text);
DataAccessLayer.AddParameters(sqlcmd, "@Contactno", SqlDbType.Int, txttp.Text);
DataAccessLayer.AddParameters(sqlcmd, "@Emailaddress", SqlDbType.NVarChar, txtemail.Text);
DataAccessLayer.AddParameters(sqlcmd, "@Emergencycontactname", SqlDbType.NVarChar, txtemename.Text);
DataAccessLayer.AddParameters(sqlcmd, "@Emergencycontacttelephoneno", SqlDbType.Int, txtemetp.Text);
DataAccessLayer.AddParameters(sqlcmd, "@Userpassword", SqlDbType.NVarChar, txtpassword.Text);
DataAccessLayer.AddParameters(sqlcmd, "@Userid", SqlDbType.Int, txtid.Text);
DataAccessLayer.AddParameters(sqlcmd, "@GenderId", SqlDbType.Int, cmbgender.SelectedValue.ToString());
DataAccessLayer.AddParameters(sqlcmd, "@NationalityId", SqlDbType.Int, cmbnationality.SelectedValue.ToString());
DataAccessLayer.AddParameters(sqlcmd, "@ReligionId", SqlDbType.Int, cmbreligion.SelectedValue.ToString());
DataAccessLayer.AddParameters(sqlcmd, "@UsertypeId", SqlDbType.Int, UserTypeId.Officer);
DataAccessLayer.AddParameters(sqlcmd, "@UserstatusId", SqlDbType.Int, UserStatusId.Active);
DataAccessLayer.ExecuteNonQuery(query, sqlcmd);
SqlCommand sqlcmd0 = new SqlCommand();
string query0 = "SELECT Id FROM KDUusers WHERE NICno = @NICno AND UsertypeId =" + UserTypeId.Officer.ToString();
DataAccessLayer.AddParameters(sqlcmd0, "@NICno", SqlDbType.NVarChar, txtnic.Text);
DataAccessLayer.AddParameters(sqlcmd0, "@UsertypeId", SqlDbType.Int, UserTypeId.Officer);
DataTable dtid = DataAccessLayer.ExecuteQuery(query0, sqlcmd0);
int officerid = 0;
if ((dtid != null) && (dtid.Rows.Count == 1))
{
officerid = Convert.ToInt32(dtid.Rows[0]["Id"]);
}
string img = string.Empty;
if (!string.IsNullOrEmpty(lblImgPath.Text))
{
using (Image image = Image.FromFile(lblImgPath.Text))
{
using (MemoryStream m = new MemoryStream())
{
image.Save(m, image.RawFormat);
byte[] imageBytes = m.ToArray();
// Convert byte[] to Base64 String
img = Convert.ToBase64String(imageBytes);
}
}
}
SqlCommand sqlcmd1 = new SqlCommand();
string query1 = @"INSERT INTO KDUofficerinfo(Id,Rank,Userphoto)VALUES(@officerid,@Rank,@Userphoto)";
DataAccessLayer.AddParameters(sqlcmd1, "@officerid", SqlDbType.Int, officerid);
DataAccessLayer.AddParameters(sqlcmd1, "@Rank", SqlDbType.NVarChar, txtrank.Text);
DataAccessLayer.AddParameters(sqlcmd1, "@Userphoto", SqlDbType.NVarChar, img);
DataAccessLayer.ExecuteNonQuery(query1, sqlcmd1);
MessageBox.Show("Saved Successfully");
txtname.Text = "";
txttown.Text = "";
cmbgender.Text = "";
txtbday.Text = "";
txtnic.Text = "";
cmbnationality.Text = "";
cmbreligion.Text = "";
txttp.Text = "";
txtemail.Text = "";
txtemename.Text = "";
txtemetp.Text = "";
txtpassword.Text = "";
txtid.Text = "";
txtrank.Text = "";
pbcadetpic.Image = null;
}
}