public JsonEntity CreateNewUser(IMitraisEntity mitraisEntity, UserDTO model)
{
JsonEntity _json = new JsonEntity();
try
{
MD_User new_user = new MD_User()
{
phone = model.Phone,
dob = (model.Dob == null) ? String.Empty : model.Dob,
first_name = model.First_Name,
last_name = model.Last_Name,
gender = model.Gender,
email = model.Email
};
user_repo.Insert(mitraisEntity, "ID", new_user);
_json.AddSuccessData("Successfully added new user");
}
catch (Exception ex)
{
_json.AddExceptionAlert(ex);
}
return(_json);
}
public virtual O FindByCondition <O>(IMitraisEntity mitraisEntity, string where, params object[] args)
{
try
{
return(mitraisEntity.Db.SingleOrDefault <O>(where, args));
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
public virtual List <O> FindAllByCondition <O>(IMitraisEntity mitraisEntity, string where, params object[] args)
{
try
{
return(mitraisEntity.Db.Fetch <O>(where, args));
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
public virtual T FindById(IMitraisEntity mitraisEntity, object id)
{
try
{
return(mitraisEntity.Db.FirstOrDefault <T>("where " + tName + "Id=@0", id.ToString()));
//repo.FindById(id);
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
public virtual int ExeNonQuery(IMitraisEntity mitraisEntity, string sql, CommandType commandType, params object[] args)
{
int output = 0;
try
{
output = mitraisEntity.Db.Execute(sql, args, commandType);
}
catch (Exception ex)
{
output = -1;
throw new Exception(ex.Message.ToString());
}
return(output);
}
public virtual int Update(IMitraisEntity mitraisEntity, string primaryKeyName, T entity)
{
int output = 0;
try
{
output = mitraisEntity.Db.Update(tName, primaryKeyName, entity);
}
catch (Exception ex)
{
output = -1;
throw new Exception(ex.Message.ToString());
}
return(output);
}
public virtual int Insert(IMitraisEntity mitraisEntity, string primaryKeyName, T entity)
{
int output = 0;
try
{
mitraisEntity.Db.Insert <T>(tName, primaryKeyName, true, entity);
}
catch (Exception ex)
{
output = -1;
throw ex;
//throw new exception(ex.message.tostring());
}
return(output);
}
public JsonEntity AddUser(UserDTO user)
{
JsonEntity _json = new JsonEntity();
try
{
using (IMitraisEntity mitraisEntity = dBEntityProvider.GetMitraisEntity())
{
_json = user_service.CreateNewUser(mitraisEntity, user);
mitraisEntity.IsRollback |= _json.error;
}
}
catch (Exception ex)
{
_json.AddExceptionAlert(ex);
}
return(_json);
}
public virtual int Delete(IMitraisEntity mitraisEntity, object id)
{
int output = 0;
try
{
T obj = mitraisEntity.Db.FirstOrDefault <T>("where " + tName + "Id=@0", id.ToString());
if (obj != null)
{
output = mitraisEntity.Db.Delete <T>(id);
}
}
catch (Exception ex)
{
output = -1;
throw new Exception(ex.Message.ToString());
}
return(output);
}
public virtual int Delete(IMitraisEntity mitraisEntity, string tableName, object param)
{
int output = 0;
try
{
T obj = mitraisEntity.Db.Query <T>("Where " + tableName + " = @0", param).SingleOrDefault();
if (obj != null)
{
output = mitraisEntity.Db.Delete <T>(obj);
}
}
catch (Exception ex)
{
output = -1;
throw new Exception(ex.Message.ToString());
}
return(output);
}
public virtual int Delete(IMitraisEntity mitraisEntity, string where, params object[] args)
{
int output = 0;
try
{
T obj = mitraisEntity.Db.FirstOrDefault <T>(where, args);
if (obj != null)
{
output = mitraisEntity.Db.Delete <T>(obj);
}
}
catch (Exception ex)
{
output = -1;
throw new Exception(ex.Message.ToString());
}
return(output);
}
public virtual int Count(IMitraisEntity mitraisEntity, string where, params object[] args)
{
try
{
string query = "";
if (where.ToLower().Contains("select"))
{
query = where;
}
else
{
query = "select count(1) as [TotalCount] from [" + tName + "] " + where;
}
return(mitraisEntity.Db.SingleOrDefault <int>(query, args));
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
