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 SetEnergyMeterParameter(string MacId, string EPRowNo, string EPDate, string EPMonth, string EPYear, string EPHour, string EPMinute, string EPCumulativeActiveEnergy, string EPAveragePowerFactor, string EPPowerONHours, string EPMonthlyLoadONCount, string EPMonthlyLoadOFFCount) { AppLog.WriteErrorLog("Function (POST) : EnergyParameter/SetEnergyMeterParameter"); bool IsRecordStore = false; string ReturnVal = Validation.UnsuccessEnergyParameter; try { IsRecordStore = QueryBuilder.InsertInDB("gdt_energymeterparameter", "MacId,EPRowNo,EPDate,EPMonth,EPYear,EPHour,EPMinute,EPCumulativeActiveEnergy,EPAveragePowerFactor,EPPowerONHours,EPMonthlyLoadONCount,EPMonthlyLoadOFFCount,EPRecordDate", "'" + MacId + "','" + EPRowNo + "','" + EPDate + "','" + EPMonth + "','" + EPYear + "','" + EPHour + "','" + EPMinute + "','" + EPCumulativeActiveEnergy + "','" + EPAveragePowerFactor + "','" + EPPowerONHours + "','" + EPMonthlyLoadONCount + "','" + EPMonthlyLoadOFFCount + "','" + DateTime.Now + "'"); if (IsRecordStore) { ReturnVal = Validation.SuccessEnergyParameter; } return(ReturnVal); } catch (Exception ex) { return(Validation.ErrorComman); } 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[] GetDeviceProfileList(string UserId) { string[] UseList = null; try { AppLog.WriteErrorLog("Function (GET) : DeviceProfile/GetDeviceProfileList"); if (UserId != "-2") { UseList = QueryBuilder.GetArrayList("CONCAT(DeviceMastreId,'-',DeviceName, '-', DeviceNo,'-',DeviceDateTime,'-',UserId) AS FullName", "gdt_deviceprofile AS gdtdp Inner Join gdt_device AS gdtd ON gdtd.DeviceMastreId = gdtdp .DeviceId", " Where UserId = '" + UserId + "'"); } else { UseList = QueryBuilder.GetArrayList("CONCAT(DeviceMastreId,'-',DeviceName, '-', DeviceNo,'-',DeviceDateTime,'-',UserId) AS FullName", "gdt_deviceprofile AS gdtdp Inner Join gdt_device AS gdtd ON gdtd.DeviceMastreId = gdtdp .DeviceId", " group by DeviceMastreId "); } } catch (Exception ex) { return(null); } finally { } return(UseList); }
public string AddRole(string Role, string RoleDescription, string IsActive, string CreatedDate, string CreatedBy) { try { AppLog.WriteErrorLog("Function (POST) : Role/AddRole"); if (!Validation.DuplicateRole(Role).Equals("1")) { return(Validation.ValidDuplicateRoleId); } bool IsAdd = false; string ReturnVal = Validation.UnsuccessRoleUser; string Columns = string.Empty; string Values = string.Empty; if (!string.IsNullOrEmpty(Role)) { Columns = "Role"; Values = "'" + Role + "'"; } else { return(Validation.ValidDuplicateRoleId); } if (!string.IsNullOrEmpty(RoleDescription)) { Columns = Columns + ",RoleDescription"; Values = Values + ",'" + RoleDescription + "'"; } if (!string.IsNullOrEmpty(IsActive)) { Columns = Columns + ",IsActive"; Values = Values + ",'" + IsActive + "'"; } if (!string.IsNullOrEmpty(CreatedDate)) { Columns = Columns + ",CreatedDate"; Values = Values + ",'" + CreatedDate + "'"; } if (!string.IsNullOrEmpty(CreatedDate)) { Columns = Columns + ",ModifiedDate"; Values = Values + ",'" + CreatedDate + "'"; } if (!string.IsNullOrEmpty(CreatedBy)) { Columns = Columns + ",CreatedBy"; Values = Values + ",'" + CreatedBy + "'"; } if (!string.IsNullOrEmpty(Columns) && !string.IsNullOrEmpty(Values)) { IsAdd = QueryBuilder.InsertInDB("mtblroles", Columns, Values); } if (IsAdd) { ReturnVal = Validation.SuccessRoleUser; } return(ReturnVal); } catch { 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 { } }
private void SetActivityLogg(string DeviceId, string HType, string UserId, string HDate, string Value1, string Value2, string Value3) { try { AppLog.WriteErrorLog("Function : ActivityLog/SetActivityLogg"); bool IsSet1 = false; IsSet1 = QueryBuilder.InsertInDB("gdt_activitylog", "DeviceId,MHDate,HType,UserId,Value1,Value2,Value3", "'" + DeviceId + "','" + HDate + "','" + HType + "','" + UserId + "','" + Value1 + "','" + Value2 + "','" + Value3 + "'"); } catch (Exception ex) { } 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 DataTable GetToken(string UserId) { try { AppLog.WriteErrorLog("Function (GET) : Token/GetToken"); DataTable dt = QueryBuilder.GetDataTable("*", "tbluserauthtokens", "Where UserId = '" + UserId + "'"); return(dt); } catch { return(null); } finally { } }
public DataTable GetRoleList() { try { AppLog.WriteErrorLog("Function (GET) : Role/GetRoleList"); DataTable dt = QueryBuilder.GetDataTable("*", "mtblroles", string.Empty); return(dt); } catch { return(null); } finally { } }
public DataTable GetUser(string UserId) { try { AppLog.WriteErrorLog("Function (GET) : User/GetUser"); DataTable dt = QueryBuilder.GetDataTable("*", "tblusers inner join tbluserroles on tbluserroles.UserId = tblusers.UserId Inner Join mtblroles on tbluserroles.RoleId = mtblroles.id", "Where tblusers.UserId = '" + UserId + "'"); return(dt); } catch { return(null); } finally { } }
public DataTable GetActivity(string UserId) { try { AppLog.WriteErrorLog("Function : ActivityLog/GetActivity"); DataTable dt = QueryBuilder.GetDataTable("*", "gdt_activitylog", "Where UserId = '" + UserId + "'"); return(dt); } catch { return(null); } finally { } }
public DataTable GetActivityList() { try { AppLog.WriteErrorLog("Function : ActivityLog/GetActivityList"); DataTable dt = QueryBuilder.GetDataTable("*", "gdt_activitylog", string.Empty); return(dt); } catch { return(null); } finally { } }
public DataTable GetRole(string RoleId) { try { AppLog.WriteErrorLog("Function (GET) : Role/GetRole"); DataTable dt = QueryBuilder.GetDataTable("*", "mtblroles", "Where id = '" + RoleId + "'"); return(dt); } catch { return(null); } finally { } }
public string GetDeviceProfileDetails(string DeviceId) { string UseList = null; try { AppLog.WriteErrorLog("Function (GET) : DeviceProfile/GetDeviceProfileDetails"); UseList = QueryBuilder.GetStr("CONCAT(DeviceMastreId,'-',DeviceName,'-',DeviceNo,'-',IFNULL(RTC,0),'-',IFNULL(Latitude,0),'-',IFNULL(Longitude,0),'-',IFNULL(RPH,0),'-',IFNULL(YPH,0),'-',IFNULL(BPH,0)) AS DeviceDetails", "devicedetails", " Where DeviceMastreId = '" + DeviceId + "'"); } catch (Exception ex) { return(Validation.ErrorComman); } finally { } return(UseList); }
public string[] GetDeviceScheduleList(string DeviceId) { string[] UseList = null; try { AppLog.WriteErrorLog("Function : DeviceProfile/GetDeviceScheduleList"); UseList = QueryBuilder.GetArrayList("CONCAT(Intervall,'-',RPhase,'-', YPhase,'-',BPhase,'-',SunriseSunset,'-',ScheduleType) AS FullName", "gdt_deviceschedule", " Where (DeviceId = '" + DeviceId + "') AND (IsActive = 1)"); } catch (Exception ex) { return(null); } finally { } return(UseList); }
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 AddToken(string UserId, string DeviceId, string IsActive, string CreatedDate, string CreatedBy) { try { AppLog.WriteErrorLog("Function (POST) : Token/AddToken"); string AuthToken = Guid.NewGuid().ToString().Substring(0, 8); if (!Validation.DuplicateAuthToken(UserId, AuthToken, DeviceId).Equals("1")) { return(Validation.ValidDuplicateAuthToken); } bool IsAdd = false; string ReturnVal = Validation.UnsuccessAddToken; string Columns = string.Empty; string Values = string.Empty; if (!string.IsNullOrEmpty(UserId)) { Columns = "UserId"; Values = "'" + UserId + "'"; } else { return(Validation.ValidDuplicateUserId); } if (!string.IsNullOrEmpty(AuthToken)) { Columns = Columns + ",AuthToken"; Values = Values + ",'" + AuthToken + "'"; } else { return(Validation.ValidDuplicateAuthToken); } if (!string.IsNullOrEmpty(DeviceId)) { Columns = Columns + ",DeviceId"; Values = Values + ",'" + DeviceId + "'"; } else { return(Validation.ValidDuplicateDeviceId); } if (!string.IsNullOrEmpty(UserId)) { Columns = Columns + ",UserId"; Values = Values + ",'" + UserId + "'"; } if (!string.IsNullOrEmpty(IsActive)) { Columns = Columns + ",IsActive"; Values = Values + ",'" + IsActive + "'"; } if (!string.IsNullOrEmpty(CreatedDate)) { Columns = Columns + ",CreatedDate"; Values = Values + ",'" + CreatedDate + "'"; } if (!string.IsNullOrEmpty(CreatedBy)) { Columns = Columns + ",CreatedBy"; Values = Values + ",'" + CreatedBy + "'"; } if (!string.IsNullOrEmpty(Columns) && !string.IsNullOrEmpty(Values)) { IsAdd = QueryBuilder.InsertInDB("tbluserauthtokens", Columns, Values); } if (IsAdd) { ReturnVal = Validation.SuccessAddToken; } 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 AddUser(string FirstName, string MiddleName, string LastName, string UserId, string Password, string RoleId, string EmailId, string Phone, string IsActive, string CreatedDate, string CreatedBy) { try { AppLog.WriteErrorLog("Function (POST) : User/AddUser"); if (!Validation.DuplicateUserId(UserId).Equals("1")) { return(Validation.ValidDuplicateUserId); } if (!Validation.DuplicateEmailId(EmailId).Equals("1")) { return(Validation.ValidDuplicateEmailId); } if (!Validation.DuplicatePhone(Phone).Equals("1")) { return(Validation.ValidDuplicatePhone); } bool IsAdd = false; string ReturnVal = Validation.UnsuccessAddUser; string Columns = string.Empty; string Values = string.Empty; if (!string.IsNullOrEmpty(FirstName)) { Columns = "FirstName"; Values = "'" + FirstName + "'"; } else { return(Validation.ValidFirstName); } if (!string.IsNullOrEmpty(MiddleName)) { Columns = Columns + ",MiddleName"; Values = Values + ",'" + MiddleName + "'"; } if (!string.IsNullOrEmpty(LastName)) { Columns = Columns + ",LastName"; Values = Values + ",'" + LastName + "'"; } if (!string.IsNullOrEmpty(UserId)) { Columns = Columns + ",UserId"; Values = Values + ",'" + UserId + "'"; } else { return(Validation.ValidUserId); } if (string.IsNullOrEmpty(RoleId)) { return(Validation.ValidRoleId); } if (!string.IsNullOrEmpty(Password)) { Columns = Columns + ",Password"; Values = Values + ",'" + Password + "'"; } else { return(Validation.ValidPassword); } if (!string.IsNullOrEmpty(EmailId)) { Columns = Columns + ",EmailId"; Values = Values + ",'" + EmailId + "'"; } else { return(Validation.ValidEmail); } if (!string.IsNullOrEmpty(Phone)) { Columns = Columns + ",Phone"; Values = Values + ",'" + Phone + "'"; } if (!string.IsNullOrEmpty(IsActive)) { Columns = Columns + ",IsActive"; Values = Values + ",'" + IsActive + "'"; } if (!string.IsNullOrEmpty(CreatedDate)) { Columns = Columns + ",CreatedDate"; Values = Values + ",'" + CreatedDate + "'"; } if (!string.IsNullOrEmpty(CreatedBy)) { Columns = Columns + ",CreatedBy"; Values = Values + ",'" + CreatedBy + "'"; } if (!string.IsNullOrEmpty(Columns) && !string.IsNullOrEmpty(Values)) { IsAdd = QueryBuilder.InsertInDB("tblusers", Columns, Values); if (IsAdd) { string Columns1 = string.Empty; string Values1 = string.Empty; string AuthToken = Guid.NewGuid().ToString().Substring(0, 8); if (!string.IsNullOrEmpty(UserId)) { Columns1 = "UserId"; Values1 = "'" + UserId + "'"; } else { return(Validation.ValidUserId); } if (!string.IsNullOrEmpty(AuthToken)) { Columns1 = Columns1 + ",AuthToken"; Values1 = Values1 + ",'" + AuthToken + "'"; } if (!string.IsNullOrEmpty(IsActive)) { Columns1 = Columns1 + ",IsActive"; Values1 = Values1 + ",'" + IsActive + "'"; } if (!string.IsNullOrEmpty(CreatedDate)) { Columns1 = Columns1 + ",CreatedDate"; Values1 = Values1 + ",'" + CreatedDate + "'"; } if (!string.IsNullOrEmpty(CreatedBy)) { Columns1 = Columns1 + ",CreatedBy"; Values1 = Values1 + ",'" + CreatedBy + "'"; } if (!string.IsNullOrEmpty(Columns1) && !string.IsNullOrEmpty(Values1)) { QueryBuilder.InsertInDB("tbluserauthtokens", Columns1, Values1); } } if (IsAdd) { string Columns2 = string.Empty; string Values2 = string.Empty; if (!string.IsNullOrEmpty(UserId)) { Columns2 = "UserId"; Values2 = "'" + UserId + "'"; } else { return(Validation.ValidUserId); } if (!string.IsNullOrEmpty(RoleId)) { Columns2 = Columns2 + ",RoleId"; Values2 = Values2 + ",'" + RoleId + "'"; } if (!string.IsNullOrEmpty(IsActive)) { Columns2 = Columns2 + ",IsActive"; Values2 = Values2 + ",'" + IsActive + "'"; } if (!string.IsNullOrEmpty(CreatedDate)) { Columns2 = Columns2 + ",CreatedDate"; Values2 = Values2 + ",'" + CreatedDate + "'"; } if (!string.IsNullOrEmpty(CreatedBy)) { Columns2 = Columns2 + ",CreatedBy"; Values2 = Values2 + ",'" + CreatedBy + "'"; } if (!string.IsNullOrEmpty(Columns2) && !string.IsNullOrEmpty(Values2)) { QueryBuilder.InsertInDB("tbluserroles", Columns2, Values2); } } } if (IsAdd) { ReturnVal = Validation.SuccessAddUser; } return(ReturnVal); } catch { return(Validation.ErrorComman); } finally { } }
public string SetActivityLog(string DeviceNo, string HType, string UserId, string Value1, string Value2, string Value3) { string IsSet = Validation.UnsuccessActivity; try { if (string.IsNullOrEmpty(Value1)) { Value1 = "NULL"; } if (string.IsNullOrEmpty(Value2)) { Value2 = "NULL"; } if (string.IsNullOrEmpty(Value3)) { Value3 = "NULL"; } AppLog.WriteErrorLog("Function : ActivityLog/SetActivityLog | DeviceNo : " + DeviceNo + " | HType : " + HType + " | UserId : " + UserId + " | Value1 : " + Value1 + " | Value2 : " + Value2 + " | Value3 : " + Value3); string DeviceMasterId = DeviceNo; if (HType == "Set RTC") { string Date = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute; SetActivityLogg(DeviceMasterId.ToString(), "Set RTC", UserId, Date, Value1, Value2, Value3); IsSet = Validation.SuccessActivity; } if (HType == "Set Lat Long") { string Date = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute; SetActivityLogg(DeviceMasterId.ToString(), "Set Lat Long", UserId, Date, Value1, Value2, Value3); IsSet = Validation.SuccessActivity; } if (HType == "Phase switch") { string Date = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute; SetActivityLogg(DeviceMasterId.ToString(), "Phase switch", UserId, Date, Value1, Value2, Value3); IsSet = Validation.SuccessActivity; } if (HType == "Lamp control") { string Date = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute; SetActivityLogg(DeviceMasterId.ToString(), "Lamp control", UserId, Date, Value1, Value2, Value3); IsSet = Validation.SuccessActivity; } if (HType == "4 CH Lamp control") { string Date = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute; SetActivityLogg(DeviceMasterId.ToString(), "4 CH Lamp control", UserId, Date, Value1, Value2, Value3); IsSet = Validation.SuccessActivity; } if (HType == "Get Time") { string Date = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute; SetActivityLogg(DeviceMasterId.ToString(), "Get Time", UserId, Date, Value1, Value2, Value3); IsSet = Validation.SuccessActivity; } if (HType == "Smart Scheduling") { string Date = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute; SetActivityLogg(DeviceMasterId.ToString(), "Smart Scheduling", UserId, Date, Value1, Value2, Value3); IsSet = Validation.SuccessActivity; } if (HType == "Set Astro Schedule") { string Date = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute; SetActivityLogg(DeviceMasterId.ToString(), "Set Astro Schedule", UserId, Date, Value1, Value2, Value3); IsSet = Validation.SuccessActivity; } if (HType == "Device Connected") { string Date = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute; SetActivityLogg(DeviceMasterId.ToString(), "Device Connected", UserId, Date, Value1, Value2, Value3); IsSet = Validation.SuccessActivity; } if (HType == "Device Disconneced") { string Date = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute; SetActivityLogg(DeviceMasterId.ToString(), "Device Disconneced", UserId, Date, Value1, Value2, Value3); IsSet = Validation.SuccessActivity; } return(IsSet); } catch (Exception ex) { return(IsSet); } 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; } } }