public string GetValidLogin(string Username, string Password)
{
try
{
AppLog.WriteErrorLog("Function (GET) : User/GetValidLogin");
string ReturnValue = Validation.ValidLogin;
// dynamic json = JsonConvert.DeserializeObject(ReturnValue);
string AuthToken = Guid.NewGuid().ToString().Substring(0, 8);
bool IsUpdate = QueryBuilder.UpdateDB("AuthToken = '" + AuthToken + "'", "tbluserauthtokens", "Where UserId = '" + Username + "'");
if (IsUpdate)
{
DataTable dt = QueryBuilder.GetDataTable("tbluserauthtokens.AuthToken", "tblusers inner join tbluserauthtokens on tbluserauthtokens.userid = tblusers.userid ", "Where tblusers.UserId = '" + Username + "' AND tblusers.Password = '******'");
if (dt.Rows.Count > 0)
{
string AuthToken1 = dt.Rows[0]["AuthToken"].ToString();
if (!string.IsNullOrEmpty(AuthToken1))
{
ReturnValue = AuthToken1;
}
}
}
return(ReturnValue);
}
catch
{
return(null);
}
finally
{
}
}
public string UpdateUserToken(string UserId)
{
try
{
AppLog.WriteErrorLog("Function (POST) : Token/UpdateUserToken");
bool IsAdd = false; string ReturnVal = Validation.UnsuccessUpdateUserToken; string ColumnsValues = string.Empty; string AuthToken = Guid.NewGuid().ToString().Substring(0, 8);
if (!string.IsNullOrEmpty(AuthToken))
{
ColumnsValues = "AuthToken = '" + AuthToken + "'";
}
if (!string.IsNullOrEmpty(ColumnsValues))
{
IsAdd = QueryBuilder.UpdateDB(ColumnsValues, "tbluserauthtokens", "Where UserId = '" + UserId + "'");
}
if (IsAdd)
{
ReturnVal = Validation.SuccessUpdateUserToken;
}
return(ReturnVal);
}
catch (Exception ex)
{
return(Validation.ErrorComman);
}
finally
{
}
}
public string UpdateToken(string TokenId, string UserId, string AuthToken, string DeviceId, string IsActive, string ModifiedDate, string ModifiedBy)
{
try
{
AppLog.WriteErrorLog("Function (POST) : Token/UpdateToken");
bool IsAdd = false; string ReturnVal = Validation.UnsuccessUpdateToken; string ColumnsValues = string.Empty;
if (!string.IsNullOrEmpty(UserId))
{
ColumnsValues = "UserId = '" + UserId + "'";
}
if (!string.IsNullOrEmpty(AuthToken))
{
ColumnsValues = ColumnsValues + ",AuthToken = '" + AuthToken + "'";
}
if (!string.IsNullOrEmpty(DeviceId))
{
ColumnsValues = ColumnsValues + ",DeviceId = '" + DeviceId + "'";
}
if (!string.IsNullOrEmpty(UserId))
{
ColumnsValues = ColumnsValues + ",UserId = '" + UserId + "'";
}
if (!string.IsNullOrEmpty(IsActive))
{
ColumnsValues = ColumnsValues + ",IsActive = '" + IsActive + "'";
}
if (!string.IsNullOrEmpty(ModifiedDate))
{
ColumnsValues = ColumnsValues + ",ModifiedDate = '" + ModifiedDate + "'";
}
if (!string.IsNullOrEmpty(ModifiedBy))
{
ColumnsValues = ColumnsValues + ",ModifiedBy = '" + ModifiedBy + "'";
}
if (!string.IsNullOrEmpty(ColumnsValues))
{
IsAdd = QueryBuilder.UpdateDB(ColumnsValues, "tbluserauthtokens", "Where id = '" + TokenId + "'");
}
if (IsAdd)
{
ReturnVal = Validation.SuccessUpdateToken;
}
return(ReturnVal);
}
catch
{
return(Validation.ErrorComman);;
}
finally
{
}
}
public string UpdateRole(string RoleId, string Role, string RoleDescription, string IsActive, string ModifiedDate, string ModifiedBy)
{
try
{
AppLog.WriteErrorLog("Function (POST) : Role/UpdateRole");
if (!Validation.DuplicateUpdateUserId(Role, RoleId).Equals("1"))
{
return(Validation.ValidDuplicateRoleId);
}
bool IsAdd = false; string ReturnVal = Validation.UnsuccessUpdateRole; string ColumnsValues = string.Empty;
if (!string.IsNullOrEmpty(Role))
{
ColumnsValues = "Role = '" + Role + "'";
}
if (!string.IsNullOrEmpty(Role))
{
ColumnsValues = ColumnsValues + ",RoleDescription = '" + RoleDescription + "'";
}
if (!string.IsNullOrEmpty(Role))
{
ColumnsValues = ColumnsValues + ",IsActive = '" + IsActive + "'";
}
if (!string.IsNullOrEmpty(Role))
{
ColumnsValues = ColumnsValues + ",ModifiedDate = '" + ModifiedDate + "'";
}
if (!string.IsNullOrEmpty(Role))
{
ColumnsValues = ColumnsValues + ",ModifiedBy = '" + ModifiedBy + "'";
}
if (!string.IsNullOrEmpty(ColumnsValues))
{
IsAdd = QueryBuilder.UpdateDB(ColumnsValues, "mtblroles", "Where id = '" + RoleId + "'");
}
if (IsAdd)
{
ReturnVal = Validation.SuccessUpdateRole;
}
return(ReturnVal);
}
catch
{
return(Validation.ErrorComman);
}
finally
{
}
}
public string DeleteUser(string PriUserId)
{
try
{
AppLog.WriteErrorLog("Function (POST) : User/DeleteUser");
bool IsAdd = false; string ReturnVal = Validation.UnsuccessDeleteUser;
if (!string.IsNullOrEmpty(PriUserId))
{
IsAdd = QueryBuilder.UpdateDB("IsActive = 0", "tblusers", "Where id = '" + PriUserId + "'");
}
if (IsAdd)
{
ReturnVal = Validation.SuccessDeleteUser;
}
return(ReturnVal);
}
catch
{
return(Validation.ErrorComman);
}
finally
{
}
}
public string DeleteRole(string RoleId)
{
try
{
AppLog.WriteErrorLog("Function (POST) : Role/DeleteRole");
bool IsAdd = false; string ReturnVal = Validation.UnsuccessDeleteRole;
if (!string.IsNullOrEmpty(RoleId))
{
IsAdd = QueryBuilder.UpdateDB("IsActive = 0", "mtblroles", "Where id = '" + RoleId + "'");
}
if (IsAdd)
{
ReturnVal = Validation.SuccessDeleteRole;
}
return(ReturnVal);
}
catch
{
return(Validation.ErrorComman);
}
finally
{
}
}
public string UpdateUser(string PriUserId, string FirstName, string MiddleName, string LastName, string UserId, string Password, string RoleId, string EmailId, string Phone, string IsActive, string ModifiedDate, string ModifiedBy, string PasswordModifiedDate)
{
try
{
AppLog.WriteErrorLog("Function (POST) : User/UpdateUser");
if (!Validation.DuplicateUpdateUserId(UserId, PriUserId).Equals("1"))
{
return(Validation.ValidDuplicateUserId);
}
if (!Validation.DuplicateUpdateEmailId(EmailId, PriUserId).Equals("1"))
{
return(Validation.ValidDuplicateEmailId);
}
if (!Validation.DuplicateUpdatePhone(Phone, PriUserId).Equals("1"))
{
return(Validation.ValidDuplicatePhone);
}
string UserName = QueryBuilder.GetStr("UserId", "tblusers", "Where id = '" + PriUserId + "'");
bool IsAdd = false; string ReturnVal = Validation.UnsuccessUpdateUser; string ColumnsValues = string.Empty;
if (!string.IsNullOrEmpty(FirstName))
{
ColumnsValues = "FirstName = '" + FirstName + "'";
}
if (!string.IsNullOrEmpty(MiddleName))
{
ColumnsValues = ColumnsValues + ",MiddleName = '" + MiddleName + "'";
}
if (!string.IsNullOrEmpty(LastName))
{
ColumnsValues = ColumnsValues + ",LastName = '" + LastName + "'";
}
if (!string.IsNullOrEmpty(UserId))
{
ColumnsValues = ColumnsValues + ",UserId = '" + UserId + "'";
}
if (!string.IsNullOrEmpty(Password))
{
ColumnsValues = ColumnsValues + ",Password = '******'";
}
if (!string.IsNullOrEmpty(EmailId))
{
ColumnsValues = ColumnsValues + ",EmailId = '" + EmailId + "'";
}
if (!string.IsNullOrEmpty(Phone))
{
ColumnsValues = ColumnsValues + ",Phone = '" + Phone + "'";
}
if (!string.IsNullOrEmpty(IsActive))
{
ColumnsValues = ColumnsValues + ",IsActive = '" + IsActive + "'";
}
if (!string.IsNullOrEmpty(ModifiedDate))
{
ColumnsValues = ColumnsValues + ",ModifiedDate = '" + ModifiedDate + "'";
}
if (!string.IsNullOrEmpty(ModifiedBy))
{
ColumnsValues = ColumnsValues + ",ModifiedBy = '" + ModifiedBy + "'";
}
if (!string.IsNullOrEmpty(PasswordModifiedDate))
{
ColumnsValues = ColumnsValues + ",PasswordModifiedDate = '" + PasswordModifiedDate + "'";
}
if (!string.IsNullOrEmpty(ColumnsValues))
{
IsAdd = QueryBuilder.UpdateDB(ColumnsValues, "tblusers", "Where id = '" + PriUserId + "'");
}
if (IsAdd)
{
string ColumnsValues1 = string.Empty;
if (!string.IsNullOrEmpty(RoleId))
{
ColumnsValues1 = "RoleId = '" + RoleId + "'";
}
if (!string.IsNullOrEmpty(UserId))
{
ColumnsValues1 = ColumnsValues1 + ",UserId = '" + UserId + "'";
}
if (!string.IsNullOrEmpty(ColumnsValues1))
{
QueryBuilder.UpdateDB(ColumnsValues1, "tbluserroles", "Where UserId = '" + UserName + "'");
}
ReturnVal = Validation.SuccessUpdateUser;
}
return(ReturnVal);
}
catch
{
return(Validation.ErrorComman);
}
finally
{
}
}
public string SetDevice(string DeviceName, string DeviceNo, string UserId)
{
string IsSet = Validation.UnsuccessDeviceProfile;
try
{
AppLog.WriteErrorLog("Function (POST) : DeviceProfile/SetDevice");
DataTable dt = QueryBuilder.GetDataTable("DeviceMastreId", "gdt_device", "Where DeviceNo = '" + DeviceNo + "'");
if (dt.Rows.Count > 0)
{
bool IsSet1 = false;
string Date = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
IsSet1 = QueryBuilder.UpdateDB("DeviceName = '" + DeviceName + "', HDate = '" + Date + "'", "gdt_device", " Where DeviceNo = '" + DeviceNo + "'");
if (IsSet1 == true)
{
IsSet = Validation.SuccessDeviceProfile;
DataTable dt1 = QueryBuilder.GetDataTable("Id", "gdt_deviceprofile",
" Where (select DeviceNo from gdt_device where DeviceId = DeviceMastreId LIMIT 1) = '" + DeviceNo + "' AND UserId = '" + UserId + "'");
if (dt1.Rows.Count > 0)
{
}
else
{
bool IsSet2 = false;
string Date1 = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
Int32 DeviceMasterId = QueryBuilder.GetInt("DeviceMastreId", "gdt_device", " Where DeviceNo = '" + DeviceNo + "' LIMIT 1");
IsSet2 = QueryBuilder.InsertInDB("gdt_deviceprofile", "DeviceId,UserId,DeviceDateTime,HDate",
"'" + DeviceMasterId.ToString() + "','" + UserId + "','" + Date1 + "','" + Date1 + "'");
if (IsSet2 == true)
{
IsSet = Validation.SuccessDeviceProfile;
SetActivityLog(DeviceMasterId.ToString(), "Profile Created", UserId, Date);
}
}
}
}
else
{
bool IsSet1 = false;
string Date = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
IsSet1 = QueryBuilder.InsertInDB("gdt_device", "DeviceName,DeviceNo,Date,HDate",
"'" + DeviceName + "','" + DeviceNo + "','" + Date + "','" + Date + "'");
if (IsSet1 == true)
{
IsSet = Validation.SuccessDeviceProfile;
Int32 DeviceMasterId = QueryBuilder.GetInt("DeviceMastreId", "gdt_device", " Where DeviceNo = '" + DeviceNo + "' LIMIT 1");
SetActivityLog(DeviceMasterId.ToString(), "Device Created", UserId, Date);
DataTable dt1 = QueryBuilder.GetDataTable("Id", "gdt_deviceprofile",
" Where (select DeviceNo from gdt_device where DeviceId = DeviceMastreId LIMIT 1) = '" + DeviceNo + "' AND UserId = '" + UserId + "'");
if (dt1.Rows.Count > 0)
{
}
else
{
bool IsSet2 = false;
string Date1 = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
Int32 DeviceMasterId1 = QueryBuilder.GetInt("DeviceMastreId", "gdt_device", " Where DeviceNo = '" + DeviceNo + "' LIMIT 1");
IsSet2 = QueryBuilder.InsertInDB("gdt_deviceprofile", "DeviceId,UserId,DeviceDateTime,HDate",
"'" + DeviceMasterId1.ToString() + "','" + UserId + "','" + Date1 + "','" + Date1 + "'");
if (IsSet2 == true)
{
IsSet = Validation.SuccessDeviceProfile;
SetActivityLog(DeviceMasterId1.ToString(), "Profile Created", UserId, Date);
}
}
}
}
return(IsSet);
}
catch (Exception ex)
{
return(Validation.ErrorComman);
}
finally
{// return IsSet; }
}
}