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