public Message Add(Faild_Log item)
{
try
{
_context.Faild_Logs.Add(item);
_context.SaveChanges();
return(Message.Success);
}
catch (DbUpdateException ex)
{
Microsoft.Data.Sqlite.SqliteException sqliteEX = ex.GetBaseException() as Microsoft.Data.Sqlite.SqliteException;
int ErrorCode = sqliteEX.SqliteErrorCode;
return(Message.unKnow);
}
}
public static Message Initialize(IServiceProvider serviceprovider)
{
try
{
var UserContext = serviceprovider.GetRequiredService <IUser>();
if (UserContext.FindByUserName("admin") != null)
{
return(Message.DbNotEmpty);
}
UserContext.Add(new User
{
UserName = "******",
UserPassword = "******",
UserType = Utility.UserType.Admin,
StatusCode = Utility.UserStatus.Enable,
CreateDate = "1396/05/10"
});
return(Utility.Message.Success);
}
catch (DbUpdateException ex)
{
Microsoft.Data.Sqlite.SqliteException sqliteEX = ex.GetBaseException() as Microsoft.Data.Sqlite.SqliteException;
int ErrorCode = sqliteEX.SqliteErrorCode;
return(Message.unKnow);
}
// using (var context = new DrawChartsContext(serviceprovider.GetRequiredService<DbContextOptions<DrawChartsContext>>()))
// {
// // Look for any Users.
// if (context.Users.Any())
// {
// return -1; // DB has been seeded
// }
// context.Users.Add(new User
// {
// UserName = "******",
// UserPassword = "******",
// UserType = MyEnum.UserType.Admin,
// StatusCode = MyEnum.UserStatus.Free,
// CreateDate = "1396/05/10"
// });
// context.SaveChanges();
// return 50;
// }
}
public Message Update(Login_Log item)
{
try
{
_context.Login_Logs.Attach(item);
_context.Entry(item).State = EntityState.Modified;
_context.SaveChanges();
return(Message.Success);
}
catch (DbUpdateException ex)
{
Microsoft.Data.Sqlite.SqliteException sqliteEX = ex.GetBaseException() as Microsoft.Data.Sqlite.SqliteException;
int ErrorCode = sqliteEX.SqliteErrorCode;
return(Message.unKnow);
}
catch (Exception)
{
return(Message.unKnow);
}
}
public bool CheckUserID(int UserID)
{
try
{
var data = _context.Users.Find(UserID);
if (data == null)
{
return(false);
}
return(true);
}
catch (DbUpdateException ex)
{
Microsoft.Data.Sqlite.SqliteException sqliteEX = ex.GetBaseException() as Microsoft.Data.Sqlite.SqliteException;
int ErrorCode = sqliteEX.SqliteErrorCode;
return(false);
}
catch (Exception)
{
return(false);
}
}
public Message Add(Login_Log item)
{
try
{
if (CheckUserID(item.UserID))
{
_context.Login_Logs.Add(item);
_context.SaveChanges();
return(Message.Success);
}
return(Message.UserNotFound);
}
catch (DbUpdateException ex)
{
Microsoft.Data.Sqlite.SqliteException sqliteEX = ex.GetBaseException() as Microsoft.Data.Sqlite.SqliteException;
int ErrorCode = sqliteEX.SqliteErrorCode;
return(Message.unKnow);
}
catch (Exception)
{
return(Message.unKnow);
}
}
public Message Add(User_Temp item)
{
try
{
if (CheckUserID(item.UserID))
{
if (CheckTemplateID(item.TemplateID))
{
//عملیات ثبت اطلاعات
_context.User_Temps.Add(item);
_context.SaveChanges();
return(Message.Success);
}
else
{
//چنین الگویی به ثبت نرسیده است
return(Message.TemplateNotFound);
}
}
else
{
//چنین کاربری وجود ندارد
return(Message.UserNotFound);
}
}
catch (DbUpdateException ex)
{
Microsoft.Data.Sqlite.SqliteException sqliteEX = ex.GetBaseException() as Microsoft.Data.Sqlite.SqliteException;
int ErrorCode = sqliteEX.SqliteErrorCode;
return(Message.unKnow);
}
catch (Exception)
{
return(Message.unKnow);
}
}
