public long AddProviderCertification(ProviderCertificationDTO providerCertification) { command = new SqlCommand(StoredProcedureName.Names.AddProviderCertification.ToString(), connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@ProviderId", SqlDbType.BigInt); command.Parameters.Add("@CertificationName", SqlDbType.VarChar, 50); command.Parameters.Add("@Description", SqlDbType.VarChar); command.Parameters.Add("@Percentage", SqlDbType.SmallInt, 100); command.Parameters.Add("@Score", SqlDbType.Int, 10); command.Parameters.Add("@YearCompleted", SqlDbType.VarChar, 10); command.Parameters[0].Value = providerCertification.ProviderId; command.Parameters[1].Value = providerCertification.CertificationName; command.Parameters[2].Value = providerCertification.Description; command.Parameters[3].Value = providerCertification.Percentage; command.Parameters[4].Value = providerCertification.Score; command.Parameters[5].Value = providerCertification.YearCompleted; connection.Open(); CertificationId = Convert.ToInt64(command.ExecuteScalar()); connection.Close(); return(CertificationId); }
protected void Page_Load(object sender, EventArgs e) { //System.Diagnostics.Debugger.Break(); GetCookie(); if (!IsPostBack) { for (int year = DateTime.Now.Year; year > (DateTime.Now.Year - 58); year--) { ListItem item = new ListItem(year.ToString(), year.ToString()); DropDownYears.Items.Add(item); } CertificationId = Convert.ToInt64(Request.QueryString["CertificationId"]); ProviderCertificationbl = new ProviderCertificationBL(); ProviderCertification = new ProviderCertificationDTO(); ProviderCertification = ProviderCertificationbl.GetProviderCertificationByCertificationId(ProviderId, CertificationId); TxtCertificationName.Text = ProviderCertification.CertificationName; TxtPercentage.Text = ProviderCertification.Percentage.ToString(); if (ProviderCertification.YearCompleted != "") { DropDownYears.Items.FindByValue(ProviderCertification.YearCompleted).Selected = true; } else { DropDownYears.Items.FindByValue("0").Selected = true; } } }
public ProviderCertificationDTO GetProviderCertificationByCertificationId(long providerid, long certificationid) { ProviderCertification = new ProviderCertificationDTO(); command = new SqlCommand(StoredProcedureName.Names.GetProviderCertificationByCertificationId.ToString(), connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@ProviderId", SqlDbType.BigInt); command.Parameters.Add("@CertificationId", SqlDbType.BigInt); command.Parameters[0].Value = providerid; command.Parameters[1].Value = certificationid; connection.Open(); datareader = command.ExecuteReader(); if (!datareader.HasRows) { return(null); } while (datareader.Read()) { ProviderCertification.CertificationId = Convert.ToInt64(datareader["CertificationId"]); ProviderCertification.ProviderId = Convert.ToInt64(datareader["ProviderId"]); ProviderCertification.CertificationName = datareader["CertificationName"].ToString(); ProviderCertification.Description = datareader["Description"].ToString(); ProviderCertification.Percentage = Convert.ToInt16(datareader["Percentage"]); ProviderCertification.Score = Convert.ToInt32(datareader["Score"]); ProviderCertification.YearCompleted = datareader["YearCompleted"].ToString(); } connection.Close(); return(ProviderCertification); }
public int UpdateProviderCertification(ProviderCertificationDTO providerCertification) { command = new SqlCommand(StoredProcedureName.Names.UpdateProviderCertification.ToString(), connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@ProviderId", SqlDbType.BigInt); command.Parameters.Add("@CertificationId", SqlDbType.BigInt); command.Parameters.Add("@CertificationName", SqlDbType.VarChar, 50); command.Parameters.Add("@Description", SqlDbType.VarChar); command.Parameters.Add("@Percentage", SqlDbType.SmallInt, 100); command.Parameters.Add("@Score", SqlDbType.Int, 10); command.Parameters.Add("@YearCompleted", SqlDbType.VarChar, 10); command.Parameters[0].Value = providerCertification.ProviderId; command.Parameters[1].Value = providerCertification.CertificationId; command.Parameters[2].Value = providerCertification.CertificationName; command.Parameters[3].Value = providerCertification.Description; command.Parameters[4].Value = providerCertification.Percentage; command.Parameters[5].Value = providerCertification.Score; command.Parameters[6].Value = providerCertification.YearCompleted; int rowaffected = 0; connection.Open(); rowaffected = command.ExecuteNonQuery(); connection.Close(); return(rowaffected); }
protected void BtnSave_Click(object sender, EventArgs e) { ProviderCertification = new ProviderCertificationDTO(); ProviderCertification.ProviderId = ProviderId; ProviderCertification.CertificationName = TxtCertificationName.Text.ToString(); if (TxtPercentage.Text != null && TxtPercentage.Text != "") { ProviderCertification.Percentage = Convert.ToInt16(TxtPercentage.Text); } if (Convert.ToInt32(DropDownYears.SelectedItem.Value) != 0) { ProviderCertification.YearCompleted = DropDownYears.SelectedItem.Value; } ProviderCertificationbl = new ProviderCertificationBL(); CertificationId = ProviderCertificationbl.AddProviderCertification(ProviderCertification); Response.Redirect("~/Provider/ProfilePage.aspx"); }
public long UpdateProviderCertification(ProviderCertificationDTO providerCertification) { ProviderCertificationdal = new ProviderCertificationDAL(); return(ProviderCertificationdal.UpdateProviderCertification(providerCertification)); }
public long AddProviderCertification(ProviderCertificationDTO providerCertification) { ProviderCertificationdal = new ProviderCertificationDAL(); return(ProviderCertificationdal.AddProviderCertification(providerCertification)); }