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