public static bool Insert(JoinUs joinUs) { try { using (var context = Exigo.Sql()) { var SqlProcedure = string.Format("InsertJoinsUS '{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}',{10},'{11}','{12}','{13}','{14}','{15}','{16}','{17}'", joinUs.FirstName.Replace("'", "''"), joinUs.LastName.Replace("'", "''"), joinUs.Email, joinUs.Phone, joinUs.Zip, joinUs.City.Replace("'", "''"), joinUs.State, joinUs.BecomingAnAmbassador, joinUs.GettingMoreInformation, joinUs.HostingaGetToGether, joinUs.AmbassadorId, joinUs.Notes.Replace("'", "''"), joinUs.UTMMedium.Replace("'", "''"), joinUs.UTMSource.Replace("'", "''"), joinUs.UTMCampaign.Replace("'", "''"), joinUs.UTMContent.Replace("'", "''"), joinUs.UTMTerm.Replace("'", "''"), joinUs.DateCreated); var styleAmbassadorRewardSettings = context.Query <StyleAmbassadorReward>(SqlProcedure).FirstOrDefault(); } return(true); } catch (Exception e) { } return(false); }
public static List <JoinUs> GetJoinUs(JoinUs model) { try { List <JoinUs> listJoinUs = new List <JoinUs>(); using (var context = Exigo.Sql()) { var SqlProcedure = string.Format("GetJoinsUS"); var styleAmbassadorRewardSettings = context.Query <Common.Api.ExigoOData.Rewards.StyleAmbassadorReward>(SqlProcedure).FirstOrDefault(); return(listJoinUs); } } catch (Exception ex) { return(null); } }