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