public int SaveActivationDetails(ActivationDetails activationDetails)
{
// Delete all the records, as there should be only one row for activation
_database.DeleteAll <ActivationDetails>();
return(_database.Insert(activationDetails));
}
public Response ValidateActivation(ActivationDetails activationDetails)
{
int count = ObjDAL.ExecuteScalarInt("SELECT COUNT(1) FROM " + strDBName + ".[dbo].[tblMobileActivation] WITH(NOLOCK) WHERE ActivationCode='" + activationDetails.ActivationCode + "' AND SerialNumber='" + activationDetails.DeviceSerialNumber + "'");
if (count > 0)
{
return(new Response {
Result = true, Message = "Application has been activated!", Value = 1
});
}
else
{
return(new Response {
Result = false, Message = "Invalid Activation Code", Value = 0
});
}
}
private bool SaveActivationDetails()
{
// save the data into database
ActivationDetails activation = new ActivationDetails();
activation.ActivationCode = txtActivationCode.Text;
activation.DeviceSerialNumber = lblSerialNo.Text;
activation.ServerIP = txtServerIP.Text;
int result = TAILORING_DB.Instance.SaveActivationDetails(activation);
if (result > 0)
{
clsSmartTailoringService.ServerIPAddress = txtServerIP.Text;
return(true);
}
else
{
return(false);
}
}
public Response ProcessActivationRequest(ActivationDetails activationDetails)
{
// delete activation if alerady exsit
ObjDAL.ExecuteNonQuery("DELETE FROM " + strDBName + ".[dbo].[tblMobileActivation] WHERE SerialNumber='" + activationDetails.DeviceSerialNumber + "'");
int isCodeExist = 1;
int ActivationCode = 0;
// keep generating the activation code if it is already exist in the system
while (isCodeExist > 0) // Need to Generate code from SQL
{
ActivationCode = RandomNumber(1000, 9999);
isCodeExist = ObjDAL.ExecuteScalarInt("SELECT COUNT(1) FROM " + strDBName + ".[dbo].[tblMobileActivation] WHERE ActivationCode='" + ActivationCode + "'");
}
ObjDAL.SetStoreProcedureData("SerialNumber", System.Data.SqlDbType.NVarChar, activationDetails.DeviceSerialNumber);
ObjDAL.SetStoreProcedureData("ActivationCode", System.Data.SqlDbType.NVarChar, ActivationCode);
ObjDAL.ExecuteStoreProcedure_DML(strDBName + ".dbo.SPR_Insert_MobileActivation");
return(new Response {
Result = true, Message = "ActivationSuccess", Value = ActivationCode
});
}
