private Guest ProcessInternalGuests(Guest paramGuest)
{
try
{
PrincipalContext principalContext = new PrincipalContext(ContextType.Domain, ConfigurationManager.AppSettings["Domain"]);
if (principalContext.ValidateCredentials(paramGuest.uid, paramGuest.password))
{
Guest guestExist = _db.Guests.Where(w => w.OracleId.Equals(paramGuest.OracleId)).FirstOrDefault(); //.Select(s => s.OracleId.Equals(OracleId)).Count();
if (guestExist == null)
{
paramGuest.DateAdded = DateTime.Now;
paramGuest.DateModified = DateTime.Now;
paramGuest.CreatedBy = HttpContext.Current.User.Identity.Name.ToString();
paramGuest.ModifiedBy = HttpContext.Current.User.Identity.Name.ToString();
_db.Guests.Add(paramGuest);
_db.SaveChanges();
return(paramGuest);
}
else
{
return(guestExist);
}
}
else
{
throw new Exception("Incorrect Password");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Index(Config config)
{
if (ModelState.IsValid)
{
config.Recepients = config.Recepients.Trim();
db.Entry(config).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(config));
}
public UploadTokens UploadTokens(HttpPostedFileBase file)
{
List <Token> batchToken = new List <Token>();
//Token tokensVM = new TokensVM();
var transactions = _db.Database.BeginTransaction();
try
{
StreamReader reader = new StreamReader(file.InputStream);
string line;
int counter = 0;
while ((line = reader.ReadLine()) != null)
{
string[] split = line.Split('\t');
if (split[0] != "")
{
var token = new Token
{
Token1 = split[0]
};
batchToken.Add(token);
}
}
_db.Configuration.AutoDetectChangesEnabled = false;
_db.Configuration.ValidateOnSaveEnabled = false;
_db.BulkInsert(batchToken, x => x.BatchSize = 100);
//_db.Tokens.AddRange(batchToken);
_db.SaveChanges();
transactions.Commit();
UploadTokensVM uploadTokens = new UploadTokensVM("", true, counter);
return(uploadTokens);
}
catch (Exception ex)
{
transactions.Rollback();
throw ex;
}
finally
{
_db.Dispose();
}
}
public string GetValidToken(long GuestID, string lang)
{
//var token = new ObjectParameter("ReturnToken", typeof(string));
using (var db = new InnermetrixDBEntities())
{
DateTime cutOffDateTime = DateTime.Now.Subtract(TimeSpan.FromHours(1));
var data = db.Tokens.Where(
r =>
(r.IsUsed ?? false) == false &&
((r.IsLocked ?? false) == false || ((r.IsLocked ?? false) == true && r.DateLocked > cutOffDateTime)) &&
(r.IsArchived ?? false == false
))
.First();
data.GuestId = GuestID;
data.IsLocked = true;
data.DateLocked = DateTime.Now;
data.Lang = lang;
db.SaveChanges();
return(data.Token1.ToString());
}
}
public void SaveRawScores(RawScores rawscores, Attributes attributes, string code, JObject jObject)
{
using (var transactions = _db.Database.BeginTransaction())
{
try
{
var root = rawscores.results;
//attributes//////////////////////////////////////////////
foreach (var item in attributes.AttributeScores)
{
_db.SaveGuestScore(code, Convert.ToInt32(item.Key), item.Value.Replace(",", "."));
}
//categories///////////////////////////////////////////
_db.SaveCategoryScores((decimal)root.categories.GettingResultsScores,
(decimal)root.categories.InterpersonalSkills,
(decimal)root.categories.MakingDecision,
(decimal)root.categories.WorkEthic,
code);
//reliability//////////////////////////////////////////
foreach (var item in root.reliability)
{
_db.SaveReliabilityScores((decimal)item,
code);
}
//dimensional balance ///////////////////////////////////////////////////////////////////
//empathy
_db.SaveDimensionalBalanceScores("Empathy",
(decimal)root.dimensionalBalance.Empathy.score,
root.dimensionalBalance.Empathy.sign,
code);
//practicalthinking
_db.SaveDimensionalBalanceScores("PracticalThinking",
(decimal)root.dimensionalBalance.PracticalThinking.score,
root.dimensionalBalance.PracticalThinking.sign,
code);
//system judgement
_db.SaveDimensionalBalanceScores("SystemsJudgement",
(decimal)root.dimensionalBalance.SystemsJudgement.score,
root.dimensionalBalance.SystemsJudgement.sign,
code);
//selfesteem
_db.SaveDimensionalBalanceScores("SelfEsteem",
(decimal)root.dimensionalBalance.SelfEsteem.score,
root.dimensionalBalance.SelfEsteem.sign,
code);
//role awareness
_db.SaveDimensionalBalanceScores("RoleAwareness",
(decimal)root.dimensionalBalance.RoleAwareness.score,
root.dimensionalBalance.RoleAwareness.sign,
code);
//self directions
_db.SaveDimensionalBalanceScores("SelfDirection",
(decimal)root.dimensionalBalance.SelfDirection.score,
root.dimensionalBalance.SelfDirection.sign,
code);
//valuations///////////////////////////////////////////////////////////////////
//empathy
_db.SaveValuationScores("Empathy",
(decimal)root.valuations.Empathy.over,
(decimal)root.valuations.Empathy.under,
code);
//practicalthinking
_db.SaveValuationScores("PracticalThinking",
(decimal)root.valuations.PracticalThinking.over,
(decimal)root.valuations.PracticalThinking.under,
code);
//system judgement
_db.SaveValuationScores("SystemsJudgement",
(decimal)root.valuations.SystemsJudgement.over,
(decimal)root.valuations.SystemsJudgement.under,
code);
//selfesteem
_db.SaveValuationScores("SelfEsteem",
(decimal)root.valuations.SelfEsteem.over,
(decimal)root.valuations.SelfEsteem.under,
code);
//role awareness
_db.SaveValuationScores("RoleAwareness",
(decimal)root.valuations.RoleAwareness.over,
(decimal)root.valuations.RoleAwareness.under,
code);
//self directions
_db.SaveValuationScores("SelfDirection",
(decimal)root.valuations.SelfDirection.over,
(decimal)root.valuations.SelfDirection.under,
code);
_db.SaveChanges();
transactions.Commit();
}
catch (Exception)
{
transactions.Rollback();
throw;
}
}
}
