public Conv_JobFair GetConv_JobFairFromReader(IDataReader reader)
{
try
{
Conv_JobFair conv_JobFair = new Conv_JobFair
(
(int)reader["Conv_JobFairID"],
reader["Name"].ToString(),
reader["IEBMembershipNo"].ToString(),
reader["Institution"].ToString(),
reader["Deprtment"].ToString(),
reader["PassingYear"].ToString(),
reader["Mobile"].ToString(),
reader["Email"].ToString(),
reader["Details"].ToString(),
reader["OfficeName"].ToString(),
reader["TrxID"].ToString(),
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
reader["ExtraField3"].ToString(),
reader["ExtraField4"].ToString(),
reader["ExtraField5"].ToString(),
(DateTime)reader["AddedDate"]
);
return(conv_JobFair);
}
catch (Exception ex)
{
return(null);
}
}
public bool UpdateConv_JobFair(Conv_JobFair conv_JobFair)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_UpdateConv_JobFair", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Conv_JobFairID", SqlDbType.Int).Value = conv_JobFair.Conv_JobFairID;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = conv_JobFair.Name;
cmd.Parameters.Add("@IEBMembershipNo", SqlDbType.NVarChar).Value = conv_JobFair.IEBMembershipNo;
cmd.Parameters.Add("@Institution", SqlDbType.NVarChar).Value = conv_JobFair.Institution;
cmd.Parameters.Add("@Deprtment", SqlDbType.NVarChar).Value = conv_JobFair.Deprtment;
cmd.Parameters.Add("@PassingYear", SqlDbType.Int).Value = conv_JobFair.PassingYear;
cmd.Parameters.Add("@Mobile", SqlDbType.Int).Value = conv_JobFair.Mobile;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = conv_JobFair.Email;
cmd.Parameters.Add("@Details", SqlDbType.NVarChar).Value = conv_JobFair.Details;
cmd.Parameters.Add("@OfficeName", SqlDbType.NVarChar).Value = conv_JobFair.OfficeName;
cmd.Parameters.Add("@TrxID", SqlDbType.NVarChar).Value = conv_JobFair.TrxID;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = conv_JobFair.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = conv_JobFair.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = conv_JobFair.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = conv_JobFair.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = conv_JobFair.ExtraField5;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = conv_JobFair.AddedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Conv_JobFair conv_JobFair = new Conv_JobFair();
conv_JobFair = Conv_JobFairManager.GetConv_JobFairByID(Int32.Parse(Request.QueryString["conv_JobFairID"]));
Conv_JobFair tempConv_JobFair = new Conv_JobFair();
tempConv_JobFair.Conv_JobFairID = conv_JobFair.Conv_JobFairID;
tempConv_JobFair.Name = txtName.Text;
tempConv_JobFair.IEBMembershipNo = txtIEBMembershipNo.Text;
tempConv_JobFair.Institution = txtInstitution.Text;
tempConv_JobFair.Deprtment = txtDeprtment.Text;
tempConv_JobFair.PassingYear = txtPassingYear.Text;
tempConv_JobFair.Mobile = txtMobile.Text;
tempConv_JobFair.Email = txtEmail.Text;
tempConv_JobFair.Details = txtDetails.Text;
tempConv_JobFair.OfficeName = txtOfficeName.Text;
tempConv_JobFair.TrxID = txtTrx.Text;
tempConv_JobFair.ExtraField1 = conv_JobFair.ExtraField1;
tempConv_JobFair.ExtraField2 = conv_JobFair.ExtraField2;
tempConv_JobFair.ExtraField3 = txtExtraField3.Text;
tempConv_JobFair.ExtraField4 = txtExtraField4.Text;
tempConv_JobFair.ExtraField5 = txtExtraField5.Text;
tempConv_JobFair.AddedDate = conv_JobFair.AddedDate;
bool result = Conv_JobFairManager.UpdateConv_JobFair(tempConv_JobFair);
Response.Redirect("AdminConv_JobFairDisplayAdmin.aspx");
}
public static Conv_JobFair GetConv_JobFairByID(int id)
{
Conv_JobFair conv_JobFair = new Conv_JobFair();
SqlConv_JobFairProvider sqlConv_JobFairProvider = new SqlConv_JobFairProvider();
conv_JobFair = sqlConv_JobFairProvider.GetConv_JobFairByID(id);
return(conv_JobFair);
}
private void showConv_JobFairData()
{
Conv_JobFair conv_JobFair = new Conv_JobFair();
conv_JobFair = Conv_JobFairManager.GetConv_JobFairByID(Int32.Parse(Request.QueryString["conv_JobFairID"]));
txtName.Text = conv_JobFair.Name;
txtIEBMembershipNo.Text = conv_JobFair.IEBMembershipNo;
txtInstitution.Text = conv_JobFair.Institution;
txtDeprtment.Text = conv_JobFair.Deprtment;
txtPassingYear.Text = conv_JobFair.PassingYear.ToString();
txtMobile.Text = conv_JobFair.Mobile.ToString();
txtEmail.Text = conv_JobFair.Email;
txtDetails.Text = conv_JobFair.Details;
txtOfficeName.Text = conv_JobFair.OfficeName;
txtTrx.Text = conv_JobFair.TrxID.ToString();
//txtExtraField1.Text = conv_JobFair.ExtraField1;
//txtExtraField2.Text = conv_JobFair.ExtraField2;
txtExtraField3.Text = conv_JobFair.ExtraField3;
txtExtraField4.Text = conv_JobFair.ExtraField4;
txtExtraField5.Text = conv_JobFair.ExtraField5;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Conv_JobFair conv_JobFair = new Conv_JobFair();
conv_JobFair.Name = txtName.Text;
conv_JobFair.IEBMembershipNo = txtIEBMembershipNo.Text;
conv_JobFair.Institution = txtInstitution.Text;
conv_JobFair.Deprtment = txtDeprtment.Text;
conv_JobFair.PassingYear = txtPassingYear.Text;
conv_JobFair.Mobile = txtMobile.Text;
conv_JobFair.Email = txtEmail.Text;
conv_JobFair.Details = txtDetails.Text;
conv_JobFair.OfficeName = txtOfficeName.Text;
conv_JobFair.TrxID = txtTrx.Text;
conv_JobFair.ExtraField1 = txtExtraField1.Text;
conv_JobFair.ExtraField2 = txtExtraField2.Text;
conv_JobFair.ExtraField3 = txtExtraField3.Text;
conv_JobFair.ExtraField4 = txtExtraField4.Text;
conv_JobFair.ExtraField5 = txtExtraField5.Text;
conv_JobFair.AddedDate = DateTime.Now;
int resutl = Conv_JobFairManager.InsertConv_JobFair(conv_JobFair);
Response.Redirect("AdminConv_JobFairDisplay.aspx");
}
public static bool UpdateConv_JobFair(Conv_JobFair conv_JobFair)
{
SqlConv_JobFairProvider sqlConv_JobFairProvider = new SqlConv_JobFairProvider();
return(sqlConv_JobFairProvider.UpdateConv_JobFair(conv_JobFair));
}
public static int InsertConv_JobFair(Conv_JobFair conv_JobFair)
{
SqlConv_JobFairProvider sqlConv_JobFairProvider = new SqlConv_JobFairProvider();
return(sqlConv_JobFairProvider.InsertConv_JobFair(conv_JobFair));
}
