//----------------------------------------------------------- /// <summary> /// Thêm/Sửa đối tượng Actions /// </summary> /// <param name="sysMessageId"></param> /// <returns>sysMessageTypeId</returns> public byte InsertOrUpdate(ref int sysMessageId) { byte retVal = 0; try { DbCommand cmd = db.GetStoredProcCommand("Actions_InsertOrUpdate"); db.AddInParameter(cmd, "@ActionName", DbType.String, ActionName); db.AddInParameter(cmd, "@ActionDesc", DbType.String, ActionDesc); db.AddInParameter(cmd, "@ParentActionId", DbType.Int16, ParentActionId); db.AddInParameter(cmd, "@Url", DbType.String, Url); db.AddInParameter(cmd, "@ActionStatusId", DbType.Byte, ActionStatusId); db.AddInParameter(cmd, "@Display", DbType.Byte, Display); db.AddInParameter(cmd, "@DisplayOrder", DbType.Int16, DisplayOrder); db.AddInParameter(cmd, "@TreeOrder", DbType.Int32, TreeOrder); db.AddInputOutputParameter(cmd, "@ActionId", DbType.Int16, ActionId); db.AddOutParameter(cmd, "@sysMessageId", DbType.Int32); db.AddOutParameter(cmd, "@SysMessageTypeId", DbType.Byte); db.ExecuteNonQuery(cmd); ActionId = Convert.ToInt16(db.GetParameter(cmd, "@ActionId").Value == null ? "0" : db.GetParameter(cmd, "@ActionId").Value); sysMessageId = Convert.ToInt16(db.GetParameter(cmd, "@sysMessageId").Value == null ? "0" : db.GetParameter(cmd, "@sysMessageId").Value); retVal = Convert.ToByte(db.GetParameter(cmd, "@SysMessageTypeId").Value == null ? "0" : db.GetParameter(cmd, "@SysMessageTypeId").Value); } catch (Exception ex) { throw ex; } return(retVal); }
//----------------------------------------------------------- /// <summary> /// Thêm/Sửa đối tượng Users /// </summary> /// <param name="sysMessageId"></param> /// <returns>sysMessageTypeId</returns> public byte InsertOrUpdate(ref int sysMessageId) { byte retVal = 0; try { DbCommand cmd = db.GetStoredProcCommand("Users_InsertOrUpdate"); db.AddInParameter(cmd, "@UserName", DbType.String, UserName); db.AddInParameter(cmd, "@Password", DbType.String, Password); db.AddInParameter(cmd, "@FullName", DbType.String, FullName); db.AddInParameter(cmd, "@Address", DbType.String, Address); db.AddInParameter(cmd, "@Email", DbType.String, Email); db.AddInParameter(cmd, "@Mobile", DbType.String, Mobile); db.AddInParameter(cmd, "@GenderId", DbType.Byte, GenderId); db.AddInParameter(cmd, "@UserStatusId", DbType.Byte, UserStatusId); db.AddInParameter(cmd, "@UserTypeId", DbType.Byte, UserTypeId); db.AddInParameter(cmd, "@DefaultActionId", DbType.Int16, DefaultActionId); db.AddInParameter(cmd, "@BirthDay", DbType.DateTime, BirthDay); db.AddInputOutputParameter(cmd, "@UserId", DbType.Int32, UserId); db.AddOutParameter(cmd, "@sysMessageId", DbType.Int32); db.AddOutParameter(cmd, "@SysMessageTypeId", DbType.Byte); db.ExecuteNonQuery(cmd); UserId = Convert.ToInt32(db.GetParameter(cmd, "@UserId").Value == null ? "0" : db.GetParameter(cmd, "@UserId").Value); sysMessageId = Convert.ToInt16(db.GetParameter(cmd, "@sysMessageId").Value == null ? "0" : db.GetParameter(cmd, "@sysMessageId").Value); retVal = Convert.ToByte(db.GetParameter(cmd, "@SysMessageTypeId").Value == null ? "0" : db.GetParameter(cmd, "@SysMessageTypeId").Value); } catch (Exception ex) { throw ex; } return(retVal); }