/// <summary> /// Enregistre la participation d'un élève d'ybe section à une UF. /// </summary> /// <param name="section">Section de l'élève</param> /// <param name="eleve">Elève dont on enregistre la participation à une UF</param> /// <param name="uf">UF à laquelle l'élève participe</param> /// <param name="cote">Cote de l'élève</param> /// <param name="date">Date de l'examen</param> public static void Participer(BO.Section section, BO.Eleve eleve, BO.UF uf, int cote, DateTime date) { List<BO.UF> participations = DAL.AccesUF.ChargerParticipations(eleve, section); // soit l'uf a déjà été tentée, dans ce cas on update la participation // soit l'uf n'a jamais été tentée, dans ce cas on insère une nouvelle participation bool existe = false; foreach (BO.UF participation in participations) { if (participation.Id == uf.Id) { existe = true; break; } } if (existe) { // update DAL.AccesUF.MajParticipation(section, eleve, uf, cote, date); } else { // insert DAL.AccesUF.InsererParticipation(section, eleve, uf, cote, date); } }
private void Common_Trail_Set_Up(int trailSuccessOnCnt) { //Arrange int cnt = 0; _service.Setup(x => x.Save(It.IsAny <BO>())) .Callback(() => { cnt++; if (cnt != trailSuccessOnCnt) //For first {trailSuccessOnCnt} trials we are throwing ConnectionException for {trailSuccessOnCnt+1}th trail we are letting it pass. { throw new ConnectionException(); } }); BORepository repo = new BORepository(_service.Object); var boEntity = new BO(); //Act repo.Save(boEntity); //Assert _service.Verify(x => x.Save(It.IsAny <BO>()), Times.Exactly(trailSuccessOnCnt)); AssertEx.Throws <ConnectionException>(() => _service.Object.Save(It.IsAny <BO>())); }
public void Save(BO bo) { int count = 0; while (true) { try { if (bo.MakeItTrue) { Console.WriteLine("successfully Saved BO"); break; } else { throw new Exception("got error"); } }catch (Exception ex) { Console.WriteLine("save failed try again"); count += 1; if (count >= 3) { break; } } } }
/// <summary> /// Charge la liste des UF possibles d'un élève d'une section. /// </summary> /// <param name="section">Section à laquelle l'élève appartient</param> /// <param name="eleve">Elève dont on veut récupérer la liste des UF possibles</param> /// <returns>Liste des UF possibles</returns> public static List<BO.UF> ChargerUFPossibles(BO.Section section, BO.Eleve eleve) { List<BO.UF> retVal = new List<BO.UF>(); List<BO.UF> ufRéussies = DAL.AccesUF.ChargerUFRéussies(eleve, section); List<BO.UF> ufCandidates = chargerUFNonRéussies(section, eleve, ufRéussies); List<BO.Groupe> groupes = DAL.AccesGroupe.ChargerGroupes(); List<BO.Prérequis> prérequis = DAL.AccesRequerir.ChargerPrérequis(); // On filtre les UF selon leur prérequis foreach (BO.UF uf in ufCandidates) { int cptGroupes = 0; int cptGroupesOK = 0; foreach (BO.Groupe groupe in groupes) { if (groupe.IdUF == uf.Id) { cptGroupes += 1; if (vérifierGroupe(groupe, prérequis, ufRéussies)) cptGroupesOK += 1; } } // Il faut au moin avoir réussis un groupe de prérequis (s'il y en a) if(cptGroupes == 0 || cptGroupesOK >= 1) retVal.Add(uf); } return retVal; }
public void CreateUploadMessages(BO.ORCID.Person person, string loggedInInternalUsername) { // Before opening the transaction get the 'read limited' token if it exists. // if it does not exist or is expired we will create a message to update it. BO.ORCID.PersonToken personToken = new BLL.ORCID.PersonToken().GetByPersonIDAndPermissionID(person.PersonID, (int)BO.ORCID.REFPermission.REFPermissions.orcid_profile_read_limited); using (System.Data.Common.DbTransaction trans = base.GetEditTransaction()) { try { new ProfilesRNSDLL.BLL.ORCID.Person().Edit(person, trans); if (!personToken.Exists || personToken.IsExpired) { CreateMessageToReadLimited(person, trans); } if (person.PushBiographyToORCID || (person.HasURLsToPush)) { CreateBioUpdateMessage(person, trans, loggedInInternalUsername); } WorksUpdate(person, trans); AffiliationsUpdate(person, trans); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw ErrorLog.LogError(ex, loggedInInternalUsername, "An error occurred while generating the messages to send to ORCID."); } } }
protected void Page_Load(object sender, EventArgs e) { try { if (Utilities.IsUserLoggedIn()) { pnl.Visible = true; Int32 userId = 0; if (Session["currentUserId"] != null) { Int32.TryParse(Session["currentUserId"].ToString(), out userId); hdnUserId.Value = userId.ToString(); } } List <SqlParameter> sqlparameters = new List <SqlParameter>(); DataSet ds = BO.CallSQLProcwithReturnValue("dbo.sp_GetAllHome", sqlparameters.ToArray()); XmlDocument doc = new XmlDocument(); doc.LoadXml(ds.GetXml()); if (ds.Tables.Count > 0) { rptHome.DataSource = ds; rptHome.DataBind(); } } catch (Exception) { //throw; } }
public void UpdateUserToken(Dictionary<string, object> items, BO.ORCID.Person person, string loggedInInternalUsername) { try { BO.ORCID.PersonToken accessToken = PersonToken.GetAPIUserAccessToken(items, person); if (!Save(accessToken)) { throw new Exception("An unexpected error occurred while saving the token"); } if (accessToken.PermissionID == (int)BO.ORCID.REFPermission.REFPermissions.orcid_profile_read_limited) { BLL.ORCID.PersonMessage personMessageBLL = new PersonMessage(); List<BO.ORCID.PersonMessage> personMessages = personMessageBLL.GetByPersonIDAndRecordStatusIDAndPermissionID(person.PersonID, (int)BO.ORCID.REFRecordStatus.REFRecordStatuss.Waiting_for_ORCID_User_for_approval, (int)accessToken.PermissionID, false); foreach (BO.ORCID.PersonMessage personMessage in personMessages) { personMessage.RecordStatusID = (int)BO.ORCID.REFRecordStatus.REFRecordStatuss.Success; if (!personMessageBLL.Save(personMessage)) { throw new Exception("Token was saved but an unexpected error occurred while updating the related messages."); } } } } catch (Exception ex) { throw BLL.ORCID.ErrorLog.LogError(ex, loggedInInternalUsername, "Error saving token information to table: ProfileToken in databae: BUMC_ORCID."); } }
public void 使用ExpressionTree_調用兩個參數的SetMethod方法_預期得到AOPException() { var bo = new BO(); Action action = () => AOPLoader.Invoke(bo, () => bo.SetMethod("余小章", "可惡出錯了!")); action.ShouldThrow <AOPException>(); }
public void ProcessRequest(HttpContext context) { bool doesFavExist = false; if (context.Request.QueryString.HasKeys()) { if (context.Request.QueryString["id"] != null) { Int32 homeId = 0; Int32.TryParse(context.Request.QueryString["id"].ToString(), out homeId); Int32 userId = 0; if (context.Request.QueryString["userId"] != null) { Int32.TryParse(context.Request.QueryString["userId"].ToString(), out userId); List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@user_id", userId)); parameters.Add(new SqlParameter("@property_id", homeId)); doesFavExist = BO.CallSQLFunction("dbo.DoesFavoriteExist", parameters.ToArray()); if (!doesFavExist) { List <SqlParameter> sqlparameters = new List <SqlParameter>(); sqlparameters.Add(new SqlParameter("@user_id", userId)); sqlparameters.Add(new SqlParameter("@property_id", homeId)); BO.CallSQLProc("dbo.sp_Wishlist", sqlparameters.ToArray()); } } context.Response.ContentType = "text/plain"; context.Response.Write(!doesFavExist ? "Favorite added succesfully" : " Favorite already exist, please select other property"); } } }
public override void Update(BO.BOBase us) { BO.User u = us as BO.User; int error = 0; List<SqlParameter> userparam = fillParams(u); userparam.Add(DAL.CommonMethods.parameter("w_UserID", u.ID)); DAL.CommonMethods.UpdateDataTable("usp_update_AggregateUser", out error, userparam.ToArray()); }
private void GetPersonAffiliationID(BO.ORCID.PersonAffiliation personAffiliation) { BO.ORCID.PersonAffiliation personAffiliationExisting = base.GetByProfilesIDAndAffiliationTypeID(personAffiliation.ProfilesID, personAffiliation.AffiliationTypeID); if (personAffiliationExisting.Exists) { personAffiliation.PersonAffiliationID = personAffiliationExisting.PersonAffiliationID; } }
/// <summary> /// Ctor /// </summary> /// <param name="uf">UF concernée</param> public DlgParticiper(BO.UF uf) { InitializeComponent(); this.Text = uf.Libellé; this.coteMax = uf.NbHeures * 10; this.lblRésultats.Text = "Résultats ( /" + this.coteMax.ToString() + ")"; this.btOk.Enabled = false; }
public void 使用ExpressionTree_調用GetSquare方法_參數2_預期得到4() { var bo = new BO(); var expected = 4; var actual = (int)AOPLoader.Invoke(bo, () => bo.GetSquare(2)); Assert.AreEqual(expected, actual); }
public override void Create(BO.BOBase us) { BO.User u = us as BO.User; int error = 0; int identity = 0; DAL.CommonMethods.UpdateDataTable("usp_insert_AggregateUser",out error, out identity, fillParams(u).ToArray()); u.ID = identity; }
public void SendORCIDXMLMessage(BO.ORCID.Person person, string accessToken, BO.ORCID.PersonMessage personMessage, BO.ORCID.REFPermission refPermission) { List<string> responseMessage = new List<string>(); BLL.ORCID.PersonMessage personMessageBLL = new PersonMessage(); personMessage.RequestURL = ProfilesRNSDLL.BO.ORCID.Config.ORCID_API_URL_WITH_VERSION + "/" + person.ORCID + "/" + refPermission.MethodAndRequest; InitializePersonMessageRequestInfo(personMessage, personMessageBLL); string method = System.Net.WebRequestMethods.Http.Post.ToString(); if (personMessage.PermissionID == (int)BO.ORCID.REFPermission.REFPermissions.orcid_bio_update) { method = System.Net.WebRequestMethods.Http.Put.ToString(); } string msg = string.Empty; WebRequest httpWebRequest = WebRequest.Create(personMessage.RequestURL); httpWebRequest.ContentType = "application/orcid+xml"; httpWebRequest.Method = method; NameValueCollection param2 = new NameValueCollection(); string AuthBearer = "Authorization: Bearer " + accessToken; responseMessage.Add(AuthBearer); param2.Add("Authorization", " Bearer " + accessToken); foreach (var key in param2.AllKeys) { httpWebRequest.Headers.Add(key, param2[key]); } string profile = personMessage.XML_Sent; byte[] xmlBytes = Encoding.UTF8.GetBytes(profile); using (var requestStream = httpWebRequest.GetRequestStream()) { requestStream.Write(xmlBytes, 0, xmlBytes.Length); requestStream.Close(); } try { using (WebResponse response = httpWebRequest.GetResponse()) { HttpWebResponse httpResponse = (HttpWebResponse)response; using (Stream data = response.GetResponseStream()) { string text = new StreamReader(data).ReadToEnd(); personMessage.HttpResponseCode = httpResponse.StatusCode.ToString(); responseMessage.Add(text); personMessage.MessagePostSuccess = true; } } } catch (WebException en) { ProcessWebException(personMessage, en, httpWebRequest); } SavePersonMessage(personMessage, refPermission, personMessageBLL); }
public async Task <IHttpActionResult> InsertChilds(int id, long parentId, Dictionary <string, object> Items) { var model = new CrudModel() { MetaBoID = id, Items = Items }; var meta = await db.META_BO.FindAsync(model.MetaBoID); /* ACCESS RIGHTS */ try { UserRoleManager.Instance.VerifyWrite(meta.BO_DB_NAME); } catch (UnauthorizedAccessException ex) { return(Content(HttpStatusCode.Forbidden, ex.Message)); } /* FIN ACCESS RIGHTS */ BO bo_model = new BO() { CREATED_BY = User.Identity.Name, CREATED_DATE = DateTime.Now, UPDATED_BY = User.Identity.Name, UPDATED_DATE = DateTime.Now, STATUS = "1", BO_TYPE = model.MetaBoID.ToString(), VERSION = meta.VERSION }; db.BO.Add(bo_model); await db.SaveChangesAsync(); db.BO_CHILDS.Add(new BO_CHILDS() { BO_PARENT_ID = parentId, BO_CHILD_ID = bo_model.BO_ID, RELATION = "1..*" }); await db.SaveChangesAsync(); int id_ = (int)bo_model.BO_ID; model.MetaBO = meta; model.Items.Add("BO_ID", id_); string insert = model.Insert(); if (insert == "") { return(Ok(model)); } else { return(InternalServerError(new Exception(insert))); } }
public void ReadORCIDProfile(BO.ORCID.Person person, BO.ORCID.PersonMessage personMessage, BO.ORCID.REFPermission refPermission, string loggedInInternalUsername) { personMessage.RequestURL = ProfilesRNSDLL.BO.ORCID.Config.ORCID_API_URL_WITH_VERSION + "/" + person.ORCID + "/" + refPermission.MethodAndRequest; NameValueCollection param2 = new NameValueCollection(); string token = BLL.ORCID.OAuth.GetClientToken(refPermission.PermissionScope, loggedInInternalUsername); param2.Add("Authorization", " Bearer " + token); param2.Add("Scope", refPermission.PermissionScope); GetWebResponseMethodGet(personMessage, refPermission, param2); }
public BO.ORCID.PersonMessage Create(BO.ORCID.Person person, BO.ORCID.REFPermission refPermission) { ProfilesRNSDLL.BO.ORCID.PersonMessage personMessage = new ProfilesRNSDLL.BO.ORCID.PersonMessage(); personMessage.PermissionID = refPermission.PermissionID; personMessage.RecordStatusID = (int)ProfilesRNSDLL.BO.ORCID.REFRecordStatus.REFRecordStatuss.Waiting_for_ORCID_User_for_approval; personMessage.PersonID = person.PersonID; personMessage.RequestURL = ProfilesRNSDLL.BO.ORCID.Config.ORCID_API_URL_WITH_VERSION + "/" + person.ORCID + "/" + refPermission.MethodAndRequest; new BLL.ORCID.PersonMessage().Save(personMessage); return personMessage; }
internal static void SetPersonMessageID(BO.ORCID.Person person) { if (person.AlternateEmails != null && person.AlternateEmails.Count > 0) { foreach (BO.ORCID.PersonAlternateEmail personAlternateEmail in person.AlternateEmails) { personAlternateEmail.PersonMessageID = person.PersonMessage.PersonMessageID; } } }
internal static void SetPersonMessageID(BO.ORCID.Person person) { if (person.Othernames != null && person.Othernames.Count > 0) { foreach (BO.ORCID.PersonOthername personOthername in person.Othernames) { personOthername.PersonMessageID = person.PersonMessage.PersonMessageID; } } }
private void sbros_Click(object sender, EventArgs e) { button_off(); foreach (DataGridViewRow row in Table.SelectedRows) { row.Selected = false; } NM.Clear(); PAG.Clear(); BO.Clear(); OPI.Clear(); JA.Clear(); CO.Clear(); }
internal static void SetPersonMessageID(BO.ORCID.Person person) { if (person.URLs != null && person.URLs.Count > 0) { foreach (BO.ORCID.PersonURL personURL in person.URLs) { personURL.PersonMessageID = person.PersonMessage.PersonMessageID; } } }
internal static void SetPersonMessageID(BO.ORCID.Person person) { if (person.Affiliations != null && person.Affiliations.Count > 0) { foreach (BO.ORCID.PersonAffiliation personAffiliation in person.Affiliations) { personAffiliation.PersonMessageID = person.PersonMessage.PersonMessageID; } } }
internal bool Save(BO.ORCID.PersonWorkIdentifier bo, System.Data.Common.DbTransaction trans) { if (bo.Exists) { return base.Edit(bo, trans); } else { return base.Add(bo, trans); } }
internal bool Save(BO.ORCID.PersonWorkIdentifier bo) { if (bo.Exists) { return base.Edit(bo); } else { return base.Add(bo); } }
public bool Save(BO.ORCID.PersonToken bo) { if (bo.Exists) { return base.Edit(bo); } else { return base.Add(bo); } }
public void Save(BO bo) { try { //Save operation } catch (Exception) { throw; } }
protected void Page_Load(object sender, EventArgs e) { if (!Utilities.IsUserLoggedIn()) { Response.Redirect("/login.aspx?returnurl=/UserListing.aspx"); } else { Int32 userId = 0; if (Session["currentUserId"] != null) { Int32.TryParse(Session["currentUserId"].ToString(), out userId); hdnUserId.Value = userId.ToString(); } } String storedProc = "dbo.sp_GetAllHome"; List <SqlParameter> sqlparameters = new List <SqlParameter>(); ltrName.Text = "All Homes"; if (Request.QueryString["type"] != null) { String homeTypeProc = Request.QueryString["type"]; if (homeTypeProc.Equals("apt")) { ltrName.Text = "Apartments"; storedProc = "dbo.sp_GetApartments"; } else if (homeTypeProc.Equals("home")) { storedProc = "dbo.sp_GetHome"; ltrName.Text = "Individual Homes"; } else if (homeTypeProc.Equals("fav")) { ltrName.Text = "User Favorite Homes"; showFav = false; storedProc = "dbo.sp_GetFavorites"; Int32 userId = 0; if (Session["currentUserId"] != null) { Int32.TryParse(Session["currentUserId"].ToString(), out userId); } sqlparameters.Add(new SqlParameter("@user_id", userId)); } } DataSet ds = BO.CallSQLProcwithReturnValue(storedProc, sqlparameters.ToArray()); if (ds.Tables.Count > 0) { rptHome.DataSource = ds; rptHome.DataBind(); } }
//add IBOService as dependency //TDD // Various Scenrios //Retry mechanism to be covered in test scenario public void Save(BO bo) { try { RetryOperation.Retry(Retry_count, () => { _ser.Save(bo); }); } catch (Exception) { throw; } }
internal bool AddIfAny(BO.ORCID.Person person) { if (person.AlternateEmails != null) { foreach (BO.ORCID.PersonAlternateEmail altEmail in person.AlternateEmails) { altEmail.PersonID = person.PersonID; if (!this.Add(altEmail)) { return false; } } } return true; }
public ProfilesRNSDLL.BO.ORCID.PersonToken Get(BO.ORCID.Person person, BO.ORCID.REFPermission refPermission) { ProfilesRNSDLL.BO.ORCID.PersonToken personToken = new BLL.ORCID.PersonToken().GetByPersonIDAndPermissionID(person.PersonID, refPermission.PermissionID); if (personToken.Exists && !personToken.IsExpired) { return personToken; } else { BO.ORCID.PersonToken bo = new BO.ORCID.PersonToken(); bo.PersonID = person.PersonID; bo.PermissionID = refPermission.PermissionID; return bo; } }
public void CheckAlternateEmails(BO.ORCID.Person bo) { if (bo.AlternateEmails != null && bo.AlternateEmails.Count > 0) { foreach (BO.ORCID.PersonAlternateEmail email in bo.AlternateEmails) { if (!DevelopmentBase.RegEx.GeneralValidation.isValidEmail(email.EmailAddress)) { bo.HasError = true; bo.AlternateEmailDecisionIDErrors += "Please check the email address as at least one is not valid. " + Environment.NewLine; break; } } } }
internal bool AddIfAny(BO.ORCID.Person person) { if (person.Othernames != null) { foreach (BO.ORCID.PersonOthername otherName in person.Othernames) { otherName.PersonID = person.PersonID; if (!this.Add(otherName)) { return false; } } } return true; }
public void ProcessORCID_ResponseError(BO.ORCID.PersonMessage personMessage, string error, string errorDescription) { if (!error.Equals(string.Empty)) { switch (errorDescription.ToLower()) { case "user denied access": personMessage.RecordStatusID = (int)BO.ORCID.REFRecordStatus.REFRecordStatuss.ORCID_User_Denied; break; default: personMessage.RecordStatusID = (int)BO.ORCID.REFRecordStatus.REFRecordStatuss.Denied_Access; break; } Save(personMessage); } }
public void ExecuteBO(Beholder bot) { var command = BO.Peek(); switch (command.Behavior) { case CommandBehavior.Blocking: if (command.TryExecute(bot)) { BO.Dequeue(); } break; case CommandBehavior.NonBlocking: bot.ASyncCommands.Add(command); BO.Dequeue(); break; case CommandBehavior.Repetative: bot.RepetativeCommands.Add(command); BO.Dequeue(); break; } }
private void StartImport() { Int32 userId = 0; Int32 homeId = 0; if (Session["currentUserId"] != null) { Int32.TryParse(Session["currentUserId"].ToString(), out userId); } else { Response.Redirect("/login.aspx?returnurl=/PostProperty.aspx"); } List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@home_no_of_beds", bed.Text)); parameters.Add(new SqlParameter("@home_no_of_baths", bath.Text)); parameters.Add(new SqlParameter("@home_occupancy", occupancy.Text)); parameters.Add(new SqlParameter("@home_parking", parking.Checked ? 1 : 0)); parameters.Add(new SqlParameter("@home_monthly_rent", rent.Text)); parameters.Add(new SqlParameter("@home_Address", Address1.Text)); parameters.Add(new SqlParameter("@home_city", City.Text)); parameters.Add(new SqlParameter("@home_state", State.Text)); parameters.Add(new SqlParameter("@apartment_flag", apartment.Checked ? 1 : 0)); parameters.Add(new SqlParameter("@home_zipcode", zip.Text)); parameters.Add(new SqlParameter("@home_image", txtfileName)); BO.CallSQLProc("dbo.sp_AddHome", parameters.ToArray()); DataSet ds = BO.CallSQLProcwithReturnValue("dbo.sp_GetLatestHome", new SqlParameter[0]); XmlDocument doc = new XmlDocument(); doc.LoadXml(ds.GetXml()); if (doc.SelectSingleNode("NewDataSet/Table/Home_ID") != null) { Int32.TryParse(doc.SelectSingleNode("NewDataSet/Table/Home_ID").InnerText, out homeId); } List <SqlParameter> sqlparameters = new List <SqlParameter>(); sqlparameters.Add(new SqlParameter("@manager_id", userId)); sqlparameters.Add(new SqlParameter("@property_id", homeId)); BO.CallSQLProc("dbo.sp_Lister_and_Property", sqlparameters.ToArray()); Response.Redirect("/propertylisting.aspx"); }
public override void BizRules(BO.ORCID.Person bo, BO.ORCID.Person boBefore) { if (!string.IsNullOrEmpty(bo.Biography)) { if (bo.Biography.Length > ORCID_MAX_BIOGRAPHY_LENGTH) { bo.BiographyErrors = "ORCID can only accept Biography's that have 5000 or fewer characters."; bo.HasError = true; } } if (string.IsNullOrEmpty(bo.InternalUsername) || bo.InternalUsername.Trim().Equals(string.Empty)) { bo.HasError = true; bo.Error += "Missing internal username identifier." + Environment.NewLine; } CheckAlternateEmails(bo); }
internal bool AddIfAny(BO.ORCID.Person person) { if (person.AlternateEmails != null) { foreach (BO.ORCID.PersonAffiliation personAffiliation in person.Affiliations) { // get id if it already exists personAffiliation.PersonID = person.PersonID; GetPersonAffiliationID(personAffiliation); // Add the new person message id if (!Save(personAffiliation)) { return false; } } } return true; }
//public List<BO.ORCID.PersonURL> GetByPersonID(int personID) //{ // return base.GetByPersonID(personID, false); //} internal bool AddIfAny(BO.ORCID.Person person, System.Data.Common.DbTransaction trans) { if (person.AlternateEmails != null) { foreach (BO.ORCID.PersonURL personURL in person.URLs) { // get id if it already exists personURL.PersonID = person.PersonID; GetPersonURLID(personURL); // Add the new person message id if (!Save(personURL, trans)) { return false; } } } return true; }
protected void Page_Load(object sender, EventArgs e) { try { if (Request.QueryString.HasKeys()) { if (Request.QueryString["id"] != null) { Int32 propertyId = 0; Int32.TryParse(Request.QueryString["id"], out propertyId); List <SqlParameter> sqlparameters = new List <SqlParameter>(); sqlparameters.Add(new SqlParameter("@property_id", propertyId)); DataSet ds = BO.CallSQLProcwithReturnValue("dbo.sp_GetProperty", sqlparameters.ToArray()); XmlDocument doc = new XmlDocument(); doc.LoadXml(ds.GetXml()); ltrImage.Text = String.Format("<img src=\"{0}\" style=\"width:100%\"/>", doc.SelectSingleNode("NewDataSet/Table/Home_image").InnerText); ltrPrice.Text = "$" + doc.SelectSingleNode("NewDataSet/Table/Home_MonthlyRent").InnerText; ltrBeds.Text = doc.SelectSingleNode("NewDataSet/Table/Home_No_Of_Beds").InnerText + " beds"; lrBath.Text = doc.SelectSingleNode("NewDataSet/Table/Home_No_Of_Baths").InnerText + " baths"; ltroccu.Text = doc.SelectSingleNode("NewDataSet/Table/Home_Occupancy").InnerText; ltrparking.Text = doc.SelectSingleNode("NewDataSet/Table/Home_Parking").InnerText.Equals("1") ? "Yes" : "No"; ltraddress.Text = doc.SelectSingleNode("NewDataSet/Table/Home_Address").InnerText + " " + doc.SelectSingleNode("NewDataSet/Table/Home_City").InnerText + " " + doc.SelectSingleNode("NewDataSet/Table/Home_State").InnerText + " " + doc.SelectSingleNode("NewDataSet/Table/Home_Zipcode").InnerText; } } else { Response.Redirect("/propertylisting.aspx"); } } catch (Exception) { } }
/// <summary> /// Charge toutes les participations de l'élève, sans tenir compte de la cote. /// </summary> /// <param name="eleve">Elève concerné</param> /// <param name="section">Section de l'élève concerné</param> /// <returns>La liste des participations de l'élève concerné, ratée comme réussies</returns> public static List<BO.UF> ChargerParticipations(BO.Eleve eleve, BO.Section section) { List<BO.UF> retVal = new List<BO.UF>(); SqlConnection connection = Utilitaire.ObtenirConnexion(); string requête = @"SELECT uf.ID, uf.CODE_ADMIN, uf.CODE_UF, uf.FK_DOSSIER, uf.LIBELLE, uf.NB_HEURE from Participer p inner join UF uf on p.FK_UF = uf.ID inner join DossierPadagogique dossier on uf.FK_DOSSIER = dossier.ID where p.FK_ETUDIANT = @IdEtudiant and dossier.FK_SECTION = @IdSection"; SqlCommand commande = new SqlCommand(requête, connection); commande.Parameters.AddWithValue("@IdEtudiant", eleve.Id); commande.Parameters.AddWithValue("@IdSection", section.Id); try { connection.Open(); SqlDataReader lecteur = commande.ExecuteReader(); while (lecteur.Read()) { int ufId = int.Parse(lecteur["ID"].ToString()); BO.UF uf = new BO.UF(ufId); uf.CodeAdmin = lecteur["CODE_ADMIN"].ToString(); uf.CodeUF = lecteur["CODE_UF"].ToString(); uf.Libellé = lecteur["LIBELLE"].ToString(); uf.NbHeures = int.Parse(lecteur["NB_HEURE"].ToString()); retVal.Add(uf); } lecteur.Close(); return retVal; } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public int grabarCompra(BO.OrdenCompra _orden) { try { connServ.Abrir(); using (SqlCommand command = new SqlCommand()) { command.CommandText = "INSERT INTO OrdenesCompra (pendiente,total_iva,total_envio,id_cliente, fecha) values ('" + _orden.Estado + "', " + _orden.Iva.ToString(this.cultura) + ", " + _orden.Envio.ToString(this.cultura) + ", " + _orden.Cliente.Id + ",getdate()) select @@identity"; command.Connection = connServ.Conexion(); _orden.Numero = Convert.ToInt32(command.ExecuteScalar()); } connServ.Cerrar(); GrabarItemsdeUnaOrden(_orden); return _orden.Numero; } catch (Exception ex) { throw new ArgumentException("Error Generando Orden de Compra", ex); } }
public new List<BO.ORCID.PersonURL> GetForORCIDUpdate(BO.ORCID.Person orcidPerson, long subjectID) { List<ProfilesRNSDLL.BO.ORCID.PersonURL> webSites = new List<ProfilesRNSDLL.BO.ORCID.PersonURL>(); try { ProfilesRNSDLL.BO.ORNG.AppData appData = new ProfilesRNSDLL.BLL.ORNG.AppData().GetWebsites(subjectID); //value = [{"link_name":"Clinical and Translational Science Institute Leadership","link_url":"http://ctsi.bu.edu/index.php/about-us/leadership/"}, {"link_name":"My Google","link_url":"www.google.com"}] string webSitesJSON = appData.value; while (webSitesJSON.ToLower().Contains("\"link_name\"")) { BO.ORCID.PersonURL website = new BO.ORCID.PersonURL(); if (webSitesJSON.ToLower().IndexOf("\"link_name\"") < webSitesJSON.ToLower().IndexOf("\"link_url\"")) { website.URLName = GetFieldValueFromJsonString(ref webSitesJSON, "link_name"); website.URL = GetFieldValueFromJsonString(ref webSitesJSON, "link_url"); } else { website.URL = GetFieldValueFromJsonString(ref webSitesJSON, "link_url"); website.URLName = GetFieldValueFromJsonString(ref webSitesJSON, "link_name"); } // Default to Public website.DecisionID = (int)BO.ORCID.REFDecision.REFDecisions.Public; webSites.Add(website); } } catch //(Exception ex) { // unable to get links from the Open Social. return new List<ProfilesRNSDLL.BO.ORCID.PersonURL>(); } // Get the list of processed affiliations List<ProfilesRNSDLL.BO.ORCID.PersonURL> processedWebsites = GetSuccessfullyProcessedURLs(orcidPerson.PersonID); // Get the affiliations that have not been processed return (from w in webSites where !processedWebsites.Any(pw => pw.URL == w.URL) select w).ToList(); }
// Create / Update / Delete protected internal static int Insert(BO.Account account) { var cmd = @" insert into [Accounts] ([ForeignID], [Name], [FBKey], [FBSecret], [TwKey], [TwSecret]) values (@ForeignID, @Name, @FBKey, @FBSecret, @TwKey, @TwSecret); select scope_identity(); "; var parameters = new SqlParameter[6]; if (account.ForeignID == null) parameters[0] = new SqlParameter("ForeignID",DBNull.Value); else parameters[0] = new SqlParameter("ForeignID",account.ForeignID); if (account.Name == null) parameters[1] = new SqlParameter("Name",DBNull.Value); else parameters[1] = new SqlParameter("Name",account.Name); if (account.FBKey == null) parameters[2] = new SqlParameter("FBKey",DBNull.Value); else parameters[2] = new SqlParameter("FBKey",account.FBKey); if (account.FBSecret == null) parameters[3] = new SqlParameter("FBSecret",DBNull.Value); else parameters[3] = new SqlParameter("FBSecret",account.FBSecret); if (account.TwKey == null) parameters[4] = new SqlParameter("TwKey",DBNull.Value); else parameters[4] = new SqlParameter("TwKey",account.TwKey); if (account.TwSecret == null) parameters[5] = new SqlParameter("TwSecret",DBNull.Value); else parameters[5] = new SqlParameter("TwSecret",account.TwSecret); return Convert.ToInt32(DBHelper.GetScalar(cmd, CommandType.Text, parameters)); }
public static void GenerateCSharpCode1(BE dc, ref StringBuilder sb) { OracleConnection conn = new OracleConnection(UtilConstants.mssqldb); conn.Open(); OracleCommand cmd = BO.GetOracleCommand(conn, dc); BO.methodName = BO.GetMethodName(dc.StoredProcedure.ToLower()); BO.entityName = BO.GetMethodName(dc.Package) + "BE." + BO.methodName + "BE"; switch (dc.CodeTypeToGenerate) { case Enums.CodeType.BusinessEntity: BO.WriteCSharpBusinessEntity(cmd, sb, dc); break; //case Enums.CodeType.BusinessObject: // WriteCSharpBusinessObject(cmd, sb, dc); // break; //case Enums.CodeType.BusinessObjectCached: // WritecSharpBusinessObjectCached(cmd, sb, dc); // break; case Enums.CodeType.IServiceCallCode: BO.WriteCSharpIServiceInterface(cmd, ref sb, dc); break; case Enums.CodeType.ServiceCallCode: BO.WriteCSharpServiceMethods(cmd, sb, dc); break; //case Enums.CodeType.DataAccess: // WriteCSharpDataAccessCode(cmd, sb, dc); // break; default: break; // forget it } conn.Close(); //dc.CodeOutput = sb.ToString; }
static void Main(string[] args) { IBORepository repo = new BOService(); Console.WriteLine("demo save success start"); BO SavedItem1 = new BO { MakeItTrue = true }; repo.Save(SavedItem1); Console.WriteLine("demo save success end"); Console.WriteLine("demo save fail start"); BO SavedItem2 = new BO { MakeItTrue = false }; repo.Save(SavedItem2); Console.WriteLine("demo save fail end"); Console.ReadLine(); }
public override string ToString() { return($"{SequenceID}: {BO.ToString()} {UniqueID} {Depth} {Event.ToString()} {PropertyName}"); }
public async Task <IHttpActionResult> Insert(int id, Dictionary <string, object> Items) { Logger.Info("POST Crud: " + id); var model = new CrudModel() { MetaBoID = id, Items = Items }; // var meta = await db.META_BO.FindAsync(model.MetaBoID); var meta = db.META_BO.Find(model.MetaBoID); /* ACCESS RIGHTS */ try { UserRoleManager.Instance.VerifyWrite(meta.BO_DB_NAME); } catch (UnauthorizedAccessException ex) { return(Content(HttpStatusCode.Forbidden, ex.Message)); } /* FIN ACCESS RIGHTS */ BO bo_model = new BO() { CREATED_BY = User.Identity.Name, CREATED_DATE = DateTime.Now, UPDATED_BY = User.Identity.Name, UPDATED_DATE = DateTime.Now, STATUS = "1", BO_TYPE = model.MetaBoID.ToString(), VERSION = meta.VERSION }; db.BO.Add(bo_model); await db.SaveChangesAsync(); int id_ = (int)bo_model.BO_ID; BO_Insert_return = id_; model.MetaBO = meta; model.BO_ID = id_; model.Items.Add("BO_ID", model.BO_ID); //return Ok(model.FormatInsert()); string insert = model.Insert(); // Workflow executer begin var s = new SGBD(); var db_workflow = s.Cmd(" select * from WORKFLOW CROSS APPLY OPENJSON(ITEMS) with(type varchar(50) '$.type', " + " precedent varchar(50) '$.precedent', [index] int '$.index', val nvarchar(500) '$.value.value') as jsonValues where ACTIVE = 1 and jsonValues.val = " + id + "and jsonValues.type = 'bo'"); dynamic _JSON; var where = ""; foreach (DataRow item in db_workflow.Rows) { _JSON = System.Web.Helpers.Json.Decode(item["ITEMS"].ToString()); int level = 0; for (var i = (int)item["index"] + 1; i < _JSON.Length; i++) { var elm = _JSON[i]; if (elm["status"] != "deleted") { where = ""; level++; if (elm["type"] == "validation") { foreach (var rule in elm.value.rules) { var value = rule["value"]; if (!"int,float,decimal,nvarchar(MAX)".Contains(rule["field"]["DB_TYPE"])) { value = "'" + value + "'"; } where += " " + rule["logic"] + " " + rule["field"]["DB_NAME"] + " " + rule["condition"] + " " + value; } var check_validation = s.Cmd("select * from " + meta.BO_DB_NAME + " where BO_ID=" + model.BO_ID + " " + where); if (check_validation.Rows.Count > 0) { TASK valid = new TASK() { BO_ID = id_, JSON_DATA = System.Web.Helpers.Json.Encode(elm.value.validators), CREATED_BY = User.Identity.Name, CREATED_DATE = DateTime.Now, STATUS = elm.value.status, ETAT = 0, TASK_LEVEL = level, TASK_TYPE = "VALIDATION" }; db.TASK.Add(valid); foreach (var _validator in elm.value.validators) { NOTIF notification = new NOTIF() { VALIDATOR = _validator["email"], CREATED_DATE = DateTime.Now, ETAT = 0 }; db.NOTIF.Add(notification); } db.SaveChanges(); } } else if (elm["type"] == "bo") { TASK valid = new TASK() { BO_ID = id_, JSON_DATA = System.Web.Helpers.Json.Encode(elm.value), CREATED_BY = User.Identity.Name, CREATED_DATE = DateTime.Now, ETAT = 0, TASK_LEVEL = level, TASK_TYPE = "BO" }; db.TASK.Add(valid); db.SaveChanges(); var task_id = (int)valid.TASK_ID; // await Insert_Bo_Using_Mapping(id, meta.BO_DB_NAME, model.BO_ID, task_id); } } } } if (insert == "") { BO_Insert_return = id_; return(Ok(model)); } else { return(InternalServerError(new Exception(insert))); } }
protected void RemoveAnotherOrder(List <Unit> units) { Player player = GameController.players[units[0].idPlayer]; Unit unit = units[0]; FindAndAttackOrder FAO; MovementOrder MO; DefenseOrder DO; AttackOrder AO; BuildOrder BO; foreach (Order order in GameController.players[unit.idPlayer].orders) { if (order != this) { if (!unit.isBusy && order.GetType() == typeof(MovementOrder)) { MO = (MovementOrder)order; if (MO.units.Contains(unit)) { if (MO.units.Count != units.Count) { foreach (Unit unitItem in units) { MO.units.Remove(unitItem); } if (MO.units.Count > 0) { player.standbyOrders.Add(MO.Clone()); } } MO.isActive = false; break; } } else { if (order.GetType().BaseType == typeof(AttackOrder)) { AO = (AttackOrder)order; if (AO.units.Contains(unit)) { if (AO.units.Count != units.Count) { foreach (Unit unitItem in units) { AO.units.Remove(unitItem); } if (AO.units.Count > 0) { player.standbyOrders.Add(AO.Clone()); } } //Debug.Log("Remove AO"); GameController.players[(this.idPlayer == 0 ? 1 : 0)].enemyAttackOrders.Remove(AO); AO.isActive = false; break; } } else if (order.GetType() == typeof(BuildOrder) && unit.GetType().BaseType == typeof(Worker)) { BO = (BuildOrder)order; if (BO.workers.Contains((Worker)unit)) { if (BO.workers.Count != units.Count) { foreach (Worker unitItem in units) { BO.workers.Remove(unitItem); } if (BO.workers.Count > 0) { player.standbyOrders.Add(BO.Clone()); } } BO.isActive = false; break; } } else if (order.GetType() == typeof(DefenseOrder)) { DO = (DefenseOrder)order; if (this.GetType() == typeof(DefenseOrder)) { DefenseOrder DefenseOrderOld = (DefenseOrder)this; if (DO.units.Contains(unit)) { if (DO.units.Count == units.Count && DO.building != DefenseOrderOld.building) { foreach (Unit unitItem in units) { DO.units.Remove(unitItem); } if (DO.units.Count > 0) { player.standbyOrders.Add(DO.Clone()); } DO.isActive = false; } break; } } if (DO.units.Contains(unit)) { if (DO.units.Count != units.Count) { foreach (Unit unitItem in units) { DO.units.Remove(unitItem); } if (DO.units.Count > 0) { player.standbyOrders.Add(DO.Clone()); } } DO.isActive = false; break; } } else if (order.GetType() == typeof(FindAndAttackOrder)) { FAO = (FindAndAttackOrder)order; if (FAO.units.Contains(unit)) { if (FAO.units.Count != units.Count) { foreach (Worker unitItem in units) { FAO.units.Remove(unitItem); } if (FAO.units.Count > 0) { player.standbyOrders.Add(FAO.Clone()); } } FAO.isActive = false; break; } } } } } }
public async Task <IHttpActionResult> InsertMultipleChilds(int id, List <Dictionary <string, object> > Items) { var meta = await db.META_BO.FindAsync(id); if (meta == null) { return(NotFound()); } /* ACCESS RIGHTS */ try { UserRoleManager.Instance.VerifyWrite(meta.BO_DB_NAME); } catch (UnauthorizedAccessException ex) { return(Content(HttpStatusCode.Forbidden, ex.Message)); } /* FIN ACCESS RIGHTS */ List <object> result = new List <object>(); string insert = "-"; bool deleted = false; foreach (var ligne in Items) { BO bo_model = new BO() { CREATED_BY = User.Identity.Name, CREATED_DATE = DateTime.Now, UPDATED_BY = User.Identity.Name, UPDATED_DATE = DateTime.Now, STATUS = "1", BO_TYPE = id.ToString(), VERSION = meta.VERSION }; db.BO.Add(bo_model); await db.SaveChangesAsync(); db.BO_CHILDS.Add(new BO_CHILDS() { BO_PARENT_ID = (long)ligne["parentId"], BO_CHILD_ID = bo_model.BO_ID, RELATION = "1..*" }); await db.SaveChangesAsync(); int id_ = (int)bo_model.BO_ID; ligne.Remove("parentId"); var model = new CrudModel() { MetaBoID = id, Items = ligne, MetaBO = meta }; model.Items.Add("BO_ID", id_); insert = model.Insert(); result.Add(new { inserted = insert, BO_ID = id_ }); if (insert != "") { deleted = true; db.Entry(bo_model).State = EntityState.Deleted; } } if (deleted) { await db.SaveChangesAsync(); } return(Ok(result)); }
protected void btnLogin_Click(object sender, EventArgs e) { bool isPageValid = true; if (Page.IsValid) { if (!Utilities.IsValidInput(username.Text.Trim())) { sbErrors.Append("The username is invalid!<br/>"); isPageValid = false; } if (!Utilities.IsValidInput(password.Text.Trim())) { sbErrors.Append("The username password is invalid!<br/>"); isPageValid = false; } if (isPageValid) { String sqlFunctionName = String.Empty; if (radioList.SelectedItem.Value != String.Empty) { sqlFunctionName = radioList.SelectedItem.Value; List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@student_pass", password.Text.Trim())); parameters.Add(new SqlParameter("@student_username", username.Text.Trim())); bool isUserValidLogin = BO.CallSQLFunction(sqlFunctionName, parameters.ToArray()); if (isUserValidLogin) { Session["UserLoggedIn"] = "true"; Session["CurrentUser"] = username.Text.Trim(); Session["currentUserType"] = radioList.SelectedItem.Text.Trim(); String sqlProc = String.Empty; String property = String.Empty; String currentUserId = String.Empty; //get user id and put in session if (radioList.SelectedItem.Text.Equals("Student")) { sqlProc = "dbo.sp_GetStudent"; property = "student_vcu_vNumber"; } else if (radioList.SelectedItem.Text.Equals("Faculty")) { sqlProc = "dbo.sp_GetFaculty"; property = "faculty_vcu_vNumber"; } else { sqlProc = "dbo.sp_GetPropertyLister"; property = "property_lister_ID"; } List <SqlParameter> sqlparameters = new List <SqlParameter>(); sqlparameters.Add(new SqlParameter("@student_Username", username.Text.Trim())); DataSet ds = BO.CallSQLProcwithReturnValue(sqlProc, sqlparameters.ToArray()); XmlDocument doc = new XmlDocument(); doc.LoadXml(ds.GetXml()); if (doc.SelectSingleNode("NewDataSet/Table/" + property) != null) { currentUserId = doc.SelectSingleNode("NewDataSet/Table/" + property).InnerText; Session["currentUserId"] = currentUserId; } if (Request.QueryString["returnurl"] != null) { Response.Redirect(Request.QueryString["returnurl"]); } if (radioList.SelectedItem.Text.Equals("Property Manager")) { Response.Redirect("/PropertyListing.aspx"); } else { Response.Redirect("/UserListing.aspx"); } } else { sbErrors.Append("please check the username and password!<br/>"); } } else { sbErrors.Append("please select the user type to login!<br/>"); } } } ltrErrors.Text = sbErrors.ToString(); }
private void GenerateCSharpCode(BE dc, string sp_name, int spno, StringBuilder allCode) { applicationPath = System.AppDomain.CurrentDomain.BaseDirectory.Replace(@"\bin\Debug\", ""); applicationPath = applicationPath.Replace(@"Generator\AutoCodeGenerator", ""); applicationPath = applicationPath.Replace(@"Generator\\AutoCodeGenerator", ""); applicationPath = applicationPath + "Projects\\"; string foldername = ""; if (dc.CodeTypeToGenerate.ToString() == "BusinessEntity") { foldername = "BusinessEntities"; } else if (dc.CodeTypeToGenerate.ToString() == "BusinessObjects") { foldername = "BusinessObjects"; } else if (dc.CodeTypeToGenerate.ToString() == "ServiceCallCode") { foldername = "BusinessEntities"; } else if (dc.CodeTypeToGenerate.ToString() == "BusinessObjectCached") { foldername = "BusinessObjects"; } else if (dc.CodeTypeToGenerate.ToString() == "DataAccess") { foldername = "DataAccessLayer"; } else if (dc.CodeTypeToGenerate.ToString() == "IServiceCallCode") { foldername = "BusinessEntities"; } //applicationPath = applicationPath + foldername + "\\"; string[] arr = sp_name.Split('_'); dc.Package = sp_name;//"EzRide_RDR";//arr[1]; //dc.CodeTypeToGenerate = Enums.CodeType.BusinessEntity; StringBuilder sb = new StringBuilder(); // this holds code generated in this pass string classBaseName = BO.GetClassName(dc); string className = ""; //sb.Append("//************************************************************"); //sb.Append("//* New Code Block *"); //sb.Append("//************************************************************"); switch (dc.CodeTypeToGenerate) { //case Enums.CodeType.BusinessObject: // AddAWholeFile(applicationPath + @"\CsharpBOImports.txt", ref sb); // className = classBaseName + "BO"; // sb.AppendLine("public class " + className); // sb.AppendLine("{"); // break; //case Enums.CodeType.BusinessObjectCached: // AddAWholeFile(applicationPath + @"\CsharpBOImports.txt", ref sb); // className = classBaseName + "BO"; // sb.AppendLine("public class " + className); // sb.AppendLine("{"); // break; //case Enums.CodeType.DataAccess: // AddAWholeFile(applicationPath + @"\CsharpBOImports.txt", ref sb); // className = classBaseName + "DO"; // sb.AppendLine(""); // sb.AppendLine("public class " + className); // sb.AppendLine("{"); // break; case Enums.CodeType.IServiceCallCode: className = "I" + classBaseName + "DataService"; sb.AppendLine("using System.ServiceModel;"); sb.AppendLine("[ServiceContract()]"); sb.AppendLine("public interface " + className + dc.InterfaceName); sb.AppendLine("{"); sb.AppendLine("#region " + className + " Methods"); break; case Enums.CodeType.ServiceCallCode: className = classBaseName + "DataService"; sb.AppendLine("using System;"); //sb.AppendLine("using PA.DPW.PACSES.Utilities;"); sb.AppendLine("public class " + className + "DataService"); sb.Append(": " + " I" + className + dc.InterfaceName); sb.AppendLine("{"); sb.AppendLine("#region " + className + " Methods"); break; case Enums.CodeType.BusinessEntity: sb.AppendLine("using System.Runtime.Serialization;"); sb.AppendLine("using System;"); sb.AppendLine("using System.Data;"); className = classBaseName + "BE"; sb.AppendLine("namespace " + className); sb.AppendLine("{"); break; default: className = "UnknownCodeType"; break; } //for (int i = 0; i <= max; i++) //{ dc.StoredProcedure = dc.Package; GenerateCSharpCode1(dc, ref sb); // ProgressBar1.Value = i + 1; // _with1.Append(dc.CodeOutput); //} switch (dc.CodeTypeToGenerate) { case Enums.CodeType.IServiceCallCode: sb.AppendLine("#endregion"); sb.AppendLine("}"); break; //case Enums.CodeType.DataAccess: // AddAWholeFile(applicationPath + "\\CsharpparameterConversionFunctions.txt", ref sb); // sb.AppendLine("}"); // break; //case Enums.CodeType.BusinessObject: // sb.AppendLine("}"); // break; //case Enums.CodeType.BusinessObjectCached: // AddAWholeFile(applicationPath + "\\CsharpcacheKeyHelper.txt", ref sb); // sb.AppendLine("}"); // break; case Enums.CodeType.ServiceCallCode: sb.AppendLine("#endregion"); sb.AppendLine("}"); break; case Enums.CodeType.BusinessEntity: sb.AppendLine("}"); break; default: break; } //applicationPath = path.Replace(@"\bin\Debug\", ""); //applicationPath = applicationPath.Replace(@"Generator\AutoCodeGenerator", ""); //applicationPath = applicationPath.Replace(@"Generator\\AutoCodeGenerator", ""); //applicationPath = applicationPath + "Projects\\" + foldername + "\\"; applicationPath = applicationPath + foldername + "\\"; FileInfo fileInfo = new FileInfo(applicationPath + className + ".cs"); if (!fileInfo.Exists) { // Create the file. using (FileStream fs = File.Create(applicationPath + className + ".cs")) { } } WriteTheFile(applicationPath + "" + className + ".cs", sb); //allCode.Append(sb.ToString); }
protected void registerButton_Click(object sender, EventArgs e) { bool isPageValid = true; if (Page.IsValid) { if (!Utilities.IsValidInput(username.Text)) { sbErrors.Append("The username is invalid!<br/>"); isPageValid = false; } if (!Utilities.IsValidInput(txtPassword.Text)) { sbErrors.Append("The username password is invalid!<br/>"); isPageValid = false; } if (!Utilities.IsValidInput(first_name.Text)) { sbErrors.Append("The first is invalid!<br/>"); isPageValid = false; } if (!Utilities.IsValidInput(last_name.Text)) { sbErrors.Append("The lastname is invalid!<br/>"); isPageValid = false; } if (!Utilities.IsEmailValidInput(email.Text)) { sbErrors.Append("The email is invalid!<br/>"); isPageValid = false; } if (!Utilities.IsValidInput(phone.Text)) { sbErrors.Append("The Phone is invalid!<br/>"); isPageValid = false; } if (!Utilities.IsValidInput(fax.Text)) { sbErrors.Append("The Fax is invalid!<br/>"); isPageValid = false; } if (!Utilities.IsValidInput(vcu.Text)) { sbErrors.Append("The VCU number is invalid!<br/>"); isPageValid = false; } if (isPageValid) { if (!radioList.SelectedItem.Text.Equals("Property Manager")) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@student_id", vcu.Text)); parameters.Add(new SqlParameter("@student_email", email.Text)); bool isUserValid = BO.CallSQLFunction("dbo.IsValidVCUMember", parameters.ToArray()); if (!isUserValid) { sbErrors.Append("The VCU number is invalid!<br/>"); isPageValid = false; } } } if (isPageValid) { //create user account List <SqlParameter> parameters = new List <SqlParameter>(); if (radioList.SelectedItem.Text.Equals("Student")) { parameters.Add(new SqlParameter("@student_id", vcu.Text)); parameters.Add(new SqlParameter("@student_password", txtPassword.Text)); parameters.Add(new SqlParameter("@student_username", username.Text)); parameters.Add(new SqlParameter("@student_lastname", last_name.Text)); parameters.Add(new SqlParameter("@student_firstname", first_name.Text)); parameters.Add(new SqlParameter("@student_MobilePhoneNumber", phone.Text)); parameters.Add(new SqlParameter("@student_gradeLevel", fax.Text)); parameters.Add(new SqlParameter("@student_email", email.Text)); parameters.Add(new SqlParameter("@student_Gender", referencedfrom.SelectedItem.Text.Equals("Please Select") ? "" : referencedfrom.SelectedItem.Text)); BO.CallSQLProc("dbo.sp_AddStudent", parameters.ToArray()); } else if (radioList.SelectedItem.Text.Equals("Faculty")) { parameters.Add(new SqlParameter("@faculty_vcu_vNumber", vcu.Text)); parameters.Add(new SqlParameter("@faculty_Password", txtPassword.Text)); parameters.Add(new SqlParameter("@faculty_Username", username.Text)); parameters.Add(new SqlParameter("@faculty_lastName", last_name.Text)); parameters.Add(new SqlParameter("@faculty_firstName", first_name.Text)); parameters.Add(new SqlParameter("@faculty_MobilePhoneNumber", phone.Text)); parameters.Add(new SqlParameter("@faculty_Gender", referencedfrom.SelectedItem.Text.Equals("Please Select") ? "" : referencedfrom.SelectedItem.Text)); parameters.Add(new SqlParameter("@faculty_email", email.Text)); BO.CallSQLProc("dbo.sp_AddFaculty", parameters.ToArray()); } else { parameters.Add(new SqlParameter("@propertyLister_password", txtPassword.Text)); parameters.Add(new SqlParameter("@propertyLister_username", username.Text)); parameters.Add(new SqlParameter("@propertyLister_lastname", last_name.Text)); parameters.Add(new SqlParameter("@propertyLister_firstname", first_name.Text)); parameters.Add(new SqlParameter("@propertyLister_MobilePhoneNumber", phone.Text)); parameters.Add(new SqlParameter("@propertyLister_email", email.Text)); BO.CallSQLProc("dbo.sp_AddPropertyLister", parameters.ToArray()); } Session["UserLoggedIn"] = "true"; Session["CurrentUser"] = username.Text.Trim(); Session["currentUserType"] = radioList.SelectedItem.Text.Trim(); String sqlProc = String.Empty; String property = String.Empty; String currentUserId = String.Empty; //get user id and put in session if (radioList.SelectedItem.Text.Equals("Student")) { sqlProc = "dbo.sp_GetStudent"; property = "student_vcu_vNumber"; } else if (radioList.SelectedItem.Text.Equals("Faculty")) { sqlProc = "dbo.sp_GetFaculty"; property = "faculty_vcu_vNumber"; } else { sqlProc = "dbo.sp_GetPropertyLister"; property = "property_lister_ID"; } List <SqlParameter> sqlparameters = new List <SqlParameter>(); sqlparameters.Add(new SqlParameter("@student_Username", username.Text.Trim())); DataSet ds = BO.CallSQLProcwithReturnValue(sqlProc, sqlparameters.ToArray()); XmlDocument doc = new XmlDocument(); doc.LoadXml(ds.GetXml()); if (doc.SelectSingleNode("NewDataSet/Table/" + property) != null) { currentUserId = doc.SelectSingleNode("NewDataSet/Table/" + property).InnerText; Session["currentUserId"] = currentUserId; } if (Request.QueryString["returnurl"] != null) { Response.Redirect(Request.QueryString["returnurl"]); } if (radioList.SelectedItem.Text.Equals("Property Manager")) { Response.Redirect("/PropertyListing.aspx"); } else { Response.Redirect("/UserListing.aspx"); } } ltrError.Text = sbErrors.ToString(); } }
private void AddBut_Click(object sender, EventArgs e) { if (NM.Text != "" && BO.Text != "" && OPI.Text != "" && JA.Text != "" && PAG.Text != "") { DialogResult dr = MessageBox.Show("Добавить запись?", "Добавление", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); if (dr == DialogResult.OK) { bool flag = false; for (int i = 0; i < Objects.Count; i++) { if (NM.Text == Objects[i].Name && BO.Text == Objects[i].bookname && JA.Text == Objects[i].Janr && OPI.Text == Objects[i].opis || CO.Text == Objects[i].index.ToString()) { flag = true; } } if (!flag) { this.Validate(); this.biblBindingSource.EndEdit(); DataRow nRow = kursDataSet.Tables[0].NewRow(); nRow["Код"] = CO.Text.ToString(); nRow["Имя"] = NM.Text.ToString(); nRow["Книга"] = BO.Text.ToString(); nRow["Жанр"] = JA.Text.ToString(); nRow["Страницы"] = PAG.Text.ToString(); nRow["Описание"] = OPI.Text.ToString(); kursDataSet.Tables[0].Rows.Add(nRow); biblTableAdapter2.Update(kursDataSet.Bibl); kursDataSet.Tables[0].AcceptChanges(); Table.Refresh(); Bibl.data_update(this.Table, this.Objects); NM.Clear(); BO.Clear(); JA.Clear(); PAG.Clear(); OPI.Clear(); CO.Clear(); } if (flag) { DialogResult er = MessageBox.Show("Такая запись уже существует!", "Добавление", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1); } } } else { DialogResult dr = MessageBox.Show("Некорректный ввод! Поля пусты.", "Добавление", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); } }