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()); } }