public static ApiResultEnum UpdateStatus(StatusUser model)
{
string sql = "UPDATE `user` SET `status`=@status WHERE id=@id";
if (MySQLHelper.ExecuteNonQuery(sql, DAHelper.CreateParams(sql, model)) > 0)
{
return(ApiResultEnum.Success);
}
return(ApiResultEnum.Failed);
}
private static double CalculateCoeffForDiscountDepentOfStatusUser(StatusUser status)
{
switch (status)
{
case StatusUser.normalUser: return(0);
case StatusUser.frequentClient: return(0.05);
case StatusUser.vip: return(0.15);
default: return(0);
}
}
public Result UpdateStatus(StatusUser model)
{
if (model.status != StatusUserEnum.Allowed)
{
UserRA.Delete(model.id.ToString());
}
if (model.status != StatusUserEnum.Forbidden)
{
MessageBiz.Send(model.id.ToString(), MessageTypeEnum.User_Forbidden);
}
else if (model.status == StatusUserEnum.ForcedOffline)
{
MessageBiz.Send(model.id.ToString(), MessageTypeEnum.User_ForcedOffline);
}
return(Result(UserDA.UpdateStatus(model)));
}
public static string UserInStatusBar(string _UserID, DateTime _Date, StatusUser _Status)
{
string Statement = string.Empty;
if (_UserID != "")
{
if (true /*GlobalSetting.LoginLanguage == FormsLogic.InputLanguages.Arabic*/)
{
if (_Status == StatusUser._Created)
{
Statement = string.Format("الانشاء بواسطة : " + "{0}" + " -- بتاريخ : " + "{1}", (_UserID != "" ? _UserID : ""), _Date.ToString("yyyy/MM/dd") + " " + _Date.ToShortTimeString());
}
else if (_Status == StatusUser._Modified)
{
Statement = string.Format("التعديل بواسطة : " + "{0}" + " -- بتاريخ : " + "{1}", (_UserID != "" ? _UserID : ""), _Date.ToString("yyyy/MM/dd") + " " + _Date.ToShortTimeString());
}
else if (_Status == StatusUser._Cancelled)
{
Statement = string.Format("الإلغاء بواسطة : " + "{0}" + " -- بتاريخ : " + "{1}", (_UserID != "" ? _UserID : ""), _Date.ToString("yyyy/MM/dd") + " " + _Date.ToShortTimeString());
}
else
{
Statement = "";
}
}
else
{
if (_Status == StatusUser._Created)
{
Statement = string.Format("Create By User : {0} -- Create Date : {1}", (_UserID != "" ? _UserID : ""), _Date.ToString("dd/MM/yyyy") + " " + _Date.ToShortTimeString());
}
else if (_Status == StatusUser._Modified)
{
Statement = string.Format("Modified By User : {0} -- Modified Date : {1}", (_UserID != "" ? _UserID : ""), _Date.ToString("dd/MM/yyyy") + " " + _Date.ToShortTimeString());
}
else if (_Status == StatusUser._Cancelled)
{
Statement = string.Format("Cancelled By User : {0} -- Modified Date : {1}", (_UserID != "" ? _UserID : ""), _Date.ToString("dd/MM/yyyy") + " " + _Date.ToShortTimeString());
}
else
{
Statement = "";
}
}
}
return(Statement);
}
public List <StatusUser> GetAll()
{
StatusUser status;
List <StatusUser> listStatus = new List <StatusUser>();
int i = 1;
foreach (var item in Enum.GetValues(typeof(EStatusUser)))
{
status = new StatusUser();
status.Id = i;
status.Name = item.ToString();
listStatus.Add(status);
i++;
}
return(listStatus);
}
// Use this for initialization
void Start()
{
stage = GameObject.Find( "Floor").GetComponent<Stage>();
GameObject objUser = GameObject.Find( "User");
statusUser = objUser.GetComponent<StatusUser>();
motionUser = objUser.GetComponent<MotionUser>();
attackUser = objUser.GetComponent<AttackUser>();
motionCamera = Camera.mainCamera.GetComponent<MotionCamera>();
// Se calcula la relación entre la resolución virtual de referencia y la resolución actual de pantalla
fRatioX = Screen.width * 1.0f / iWidthScreen;
fRatioY = Screen.height * 1.0f / iHeightScreen;
// Se crea la barra de energía y se inicializan los parámetros relacionados.
barUserEnergy = UIStateSprite.create( "Energy.png", 0, 0);
barUserEnergy.hidden = false;
barGunEnergy = UIStateSprite.create( "Level.png", 0, 0);
barGunEnergy.hidden = false;
textKilled = new UIText( "prototype", "prototype.png");
textEnemies = new UIText( "prototype", "prototype.png");
textRecord = new UIText( "prototype", "prototype.png");
textEnemiesInstance = textEnemies.addTextInstance( "Enemigos: 0", iXTextEnemies * fRatioX, iYTextEnemies * fRatioY, 0.8f, 1, Color.green);
textKilledInstance = textKilled.addTextInstance( "Asesinatos: 0", iXTextKilled * fRatioX, iYTextKilled * fRatioY, 0.8f, 1, Color.red);
textRecordInstance = textRecord.addTextInstance( "Record: " + PlayerPrefs.GetInt( "Record", 0),
iXTextRecord * fRatioX, iYTextRecord * fRatioY, 0.8f, 1, Color.black);
buttonPersp = UIButton.create( "emptyUp.png", "emptyDown.png", 0, 0);
buttonPersp.hidden = false;
textPersp = new UIText( "prototype", "prototype.png");
textPerspInstance = textPersp.addTextInstance( motionCamera.strCameraPersp, iXTextPersp * fRatioX, iYTextPersp * fRatioY, 0.9f, 1, Color.blue);
}
public static decimal GetPriceWithDiscount(Flight flight, RegisteredFlight registeredFlight, StatusUser status)
{
return((decimal)(1 - (CalculateCoeffForDiscountDependOnDistance(flight) + CalculateCoeffForDiscountDependOnBookinge(flight, registeredFlight) + CalculateCoeffForDiscountDepentOfStatusUser(status))) * flight.Price);
}
internal int Update(int oldCode, int userCode, string userName, long?userCodeRef, string passwordMd5, DateTime inputDate, StatusUser status)
{
string queryString = @" UPDATE USER_TEST
SET COD_USER = @COD_USER,
USER_NAME = @USER_NAME,
COD_USER_REF = @COD_USER_REF,
PASSWORD_MD5 = @PASSWORD_MD5,
INPUT_DATE = @INPUT_DATE,
USER_STATUS = @USER_STATUS
WHERE COD_USER = @OLD_COD_USER";
DataBaseParameter[] parameters = new DataBaseParameter[]
{
new DataBaseParameter("OLD_COD_USER", oldCode),
new DataBaseParameter("COD_USER", userCode),
new DataBaseParameter("USER_NAME", userName),
new DataBaseParameter("COD_USER_REF", userCodeRef),
new DataBaseParameter("PASSWORD_MD5", passwordMd5),
new DataBaseParameter("INPUT_DATE", inputDate),
new DataBaseParameter("USER_STATUS", (char)status),
};
return(this.dbBase.ExecuteNonQuery(queryString, parameters));
}
internal bool Insert(int userCode, string userName, long?userCodeRef, string passwordMd5, DateTime inputDate, StatusUser status)
{
string queryString = @" INSERT INTO USER_TEST (COD_USER, USER_NAME, COD_USER_REF, PASSWORD_MD5, INPUT_DATE, USER_STATUS)
VALUES(@COD_USER, @USER_NAME, @COD_USER_REF, @PASSWORD_MD5, @INPUT_DATE, @USER_STATUS)";
DataBaseParameter[] parameters = new DataBaseParameter[]
{
new DataBaseParameter("COD_USER", userCode),
new DataBaseParameter("USER_NAME", userName),
new DataBaseParameter("COD_USER_REF", userCodeRef),
new DataBaseParameter("PASSWORD_MD5", passwordMd5),
new DataBaseParameter("INPUT_DATE", inputDate),
new DataBaseParameter("USER_STATUS", (char)status),
};
int inserted = this.dbBase.ExecuteNonQuery(queryString, parameters);
return(inserted == 1);
}
// Use this for initialization
void Start()
{
_listEnemies = new List<GameObject>();
fTimeCreate = 0.0f;
winner = Winner.none;
statusUser = GameObject.Find( "User").GetComponent<StatusUser>();
}
