/// <summary>
/// Ajouter une offre dans la base de données
/// </summary>
/// <param name="_offerToAdd">Offre à ajouter</param>
public static void AddOffer(MGCastingOffer _offerToAdd)
{
using (SqlConnection connection = new SqlConnection(LUDBcononnectionString))
{
using (SqlCommand command = new SqlCommand())
{
connection.Open();
command.CommandText = "[dbo].[SP_CreateCastingOffer]";
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
command.Prepare();
command.Parameters.Add("@Label", SqlDbType.NVarChar).Value = _offerToAdd.Label;
command.Parameters.Add("@Description", SqlDbType.NVarChar).Value = _offerToAdd.Description;
command.Parameters.Add("@Street", SqlDbType.NVarChar).Value = _offerToAdd.Street;
command.Parameters.Add("@City", SqlDbType.NVarChar).Value = _offerToAdd.City;
command.Parameters.Add("@PostalCode", SqlDbType.NVarChar).Value = _offerToAdd.PostalCode;
command.Parameters.Add("@ContractId", SqlDbType.Int).Value = _offerToAdd.Contract.Id;
command.Parameters.Add("@ClientId", SqlDbType.Int).Value = _offerToAdd.Client.Id;
command.Parameters.Add("@TalentId", SqlDbType.Int).Value = _offerToAdd.Talent.Id;
command.Parameters.Add("@UserId", SqlDbType.Int).Value = MGCurrentHeavyUser.Id;
command.ExecuteNonQuery();
}
}
}
/// <summary>
/// Selectionner tout les offres de casting actif
/// </summary>
/// <returns></returns>
public static List <MGCastingOffer> GetActiveCastingOffers()
{
List <MGCastingOffer> offers = new List <MGCastingOffer>();
using (SqlConnection connection = new SqlConnection(LUDBcononnectionString))
{
IDataReader dataReader;
using (SqlCommand command = new SqlCommand())
{
connection.Open();
command.CommandText = "[dbo].[SP_GetCastingOffers]";
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
dataReader = command.ExecuteReader();
MGCastingOffer offer;
while (dataReader.Read())
{
offer = new MGCastingOffer();
offer.Id = dataReader.GetInt32(0);
offer.Label = dataReader.GetString(1);
offer.PublicationDate = dataReader.GetDateTime(2);
offer.Description = dataReader.GetString(3);
offer.Street = dataReader.GetString(4);
offer.City = dataReader.GetString(5);
offer.PostalCode = dataReader.GetString(6);
offer.Contract.Id = dataReader.GetInt32(7);
offer.Contract.Label = dataReader.GetString(8);
offer.Contract.ShortLabel = dataReader.GetString(9);
offer.Talent.Id = dataReader.GetInt32(10);
offer.Talent.Label = dataReader.GetString(11);
offer.Talent.Description = dataReader.GetString(12);
offer.Client.Id = dataReader.GetInt32(13);
offer.Client.Name = dataReader.GetString(14);
offers.Add(offer);
}
}
}
return(offers);
}
/// <summary>
/// Envoyer la nouvelle offre sur la base de donnée
/// </summary>
private void saveNewOffer()
{
newOffer = new MGCastingOffer();
newOffer.Label = TxtTitre.Text;
newOffer.Description = TxtDescription.Text;
newOffer.Location.Street = TxtStreet.Text;
newOffer.Location.City = TxtCity.Text;
newOffer.Location.PostalCode = TxtPostalCode.Text;
newOffer.Contract = contractTypes.ElementAt(CBContract.SelectedIndex);
newOffer.Talent = talents.ElementAt(CBTalent.SelectedIndex);
newOffer.Client = clients.ElementAt(CBClient.SelectedIndex);
CastingOfferRep.AddOffer(newOffer);
TxtTitre.Text = "";
TxtDescription.Text = "";
TxtStreet.Text = "";
TxtCity.Text = "";
TxtPostalCode.Text = "";
}
public static List <PageContent> GetPageContents(int _id)
{
List <PageContent> contents = new List <PageContent>();
using (SqlConnection connection = new SqlConnection(LUDBcononnectionString))
{
IDataReader dataReader;
using (SqlCommand command = new SqlCommand())
{
connection.Open();
command.CommandText = "[dbo].[SP_GetPageContent";
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
command.Prepare();
command.Parameters.Add("@pageId", SqlDbType.Int).Value = _id;
command.ExecuteNonQuery();
dataReader = command.ExecuteReader();
PageContent content;
/*[SiteContent].[Id], [SiteContent].[LabelFr], [SiteContent].[LastUpdt]
* ,[Paragraph].[Id], [Paragraph].[LabelFr], [Paragraph].[ParagText]
* ,[Offer].[Id], [Offer].[LibelFr], [Offer].[Publication], [Offer].[Description], [Offer].[StreetName], [Offer].[CityName], [Offer].[PostalCode], [Offer].[PeriodTokens]
* ,[Talent].[Id], [Talent].[LabelFr]
* ,[ContractType].[Id], [ContractType].[LabelShortFr]*/
while (dataReader.Read())
{
content = new PageContent();
content.Id = dataReader.GetInt32(1);
content.Label = dataReader.GetString(2);
content.LastUpdate = dataReader.GetDateTime(3);
if (dataReader.GetInt32(7) == 0)
{
content.Type = PageContent.PageContentType.Para;
MGParagraph para = new MGParagraph();
para.Id = dataReader.GetInt32(4);
para.Label = dataReader.GetString(5);
para.ParaText = dataReader.GetString(6);
}
else
{
content.Type = PageContent.PageContentType.Offer;
MGCastingOffer offer = new MGCastingOffer();
offer.Id = dataReader.GetInt32(7);
offer.Label = dataReader.GetString(8);
offer.PublicationDate = dataReader.GetDateTime(9);
offer.Description = dataReader.GetString(10);
offer.Street = dataReader.GetString(11);
offer.City = dataReader.GetString(12);
offer.PostalCode = dataReader.GetString(13);
offer.Talent.Id = dataReader.GetInt32(15);
offer.Talent.Label = dataReader.GetString(16);
content.CastingOffers.Add(offer);
}
contents.Add(content);
}
}
}
return(contents);
}
