/// <summary> /// It will return equipment variants with their cost history based on Variant ID /// </summary> /// <param name="VariantID">Pass the variant ID for associated equipment</param> /// <returns></returns> public MDTTransactionInfo GetEquipmentVariants(int packageID, int systemID, int configurationID, int variantID) { MDTTransactionInfo mdt = new MDTTransactionInfo(); try { IEnumerable <EquipmentVariants> equipmentVariants = null; List <SqlParameter> prm = new List <SqlParameter>(); prm = DatabaseSettings.BindParamers(APIHelper.getEquipmentVariantsParameters, packageID.ToString() + "~||~" + systemID.ToString() + "~||~" + configurationID.ToString() + "~||~" + variantID.ToString()); int statusValue = 0; DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getEquipmentVariants, out statusValue, prm); DataTable dt; if (statusValue == 1) { dt = ds.Tables[0]; if (dt.Rows.Count > 0) { equipmentVariants = from d in dt.AsEnumerable() select new EquipmentVariants { SELECT = Convert.ToBoolean(d.Field <int>("SELECT")), PACKAGE_ID = d.Field <int>("PACKAGE_ID"), SYSTEM_ID = d.Field <int>("SYSTEM_ID"), EQUIPMENT_ID = d.Field <int>("EQUIPMENT_ID"), SUPPLIER_ID = d.Field <int>("SUPPLIER_ID"), CONFIGURATION_ID = d.Field <int>("CONFIGURATION_ID"), UPDT_USER_ID = d.Field <int>("UPDT_USER_ID"), IS_MANDATORY = d.Field <bool>("IS_MANDATORY"), EQUIPMENT_NAME = d.Field <string>("EQUIPMENT_NAME"), SUPPLIER_NAME = d.Field <string>("SUPPLIER_NAME"), EQUIPMENT_COST = d.Field <double>("EQUIPMENT_COST"), EQPMNT_VARIANT_ID = d.Field <int>("EQPMNT_VARIANT_ID"), COMMENTS = d.Field <string>("COMMENTS"), EQUIPMENT_DESC = d.Field <string>("EQUIPMENT_DESC"), EQUIPMENT_TYPE = d.Field <string>("EQUIPMENT_TYPE"), Documents = GetEquipmentDocuments(d.Field <int>("EQUIPMENT_ID")).transactionObject as IEnumerable <EquipmentDocuments>, SAPLinks = GetEquipmentSAPLinks(d.Field <int>("EQUIPMENT_ID")).transactionObject as IEnumerable <EquipmentSAPLink>, Suppliers = Suppliers = GetSuppliers(d.Field <int>("SYSTEM_ID"), d.Field <int>("EQUIPMENT_ID"), d.Field <int>("CONFIGURATION_ID"), d.Field <string>("EQUIPMENT_TYPE")) //(d.Field<int>("SUPPLIER_ID")!=0)?Suppliers:null }; mdt = DatabaseSettings.GetTransObject(equipmentVariants, statusValue, "System equipment variants fetched successfully", ds); } else { mdt.msgCode = MessageCode.Failed; mdt.status = HttpStatusCode.NoContent; mdt.message = "No record found"; } } } catch (Exception ex) { mdt.status = HttpStatusCode.ExpectationFailed; mdt.msgCode = MessageCode.TechnicalError; mdt.message = "Technical Error in the system, please contact to administrator"; // Need to log error in logger from ex } return(mdt); }
/// <summary> /// Change password method which will interact with database and change the password /// </summary> /// <param name="changePassword">You need to pass ChangePassword type object to process the request</param> /// <returns></returns> public MDTTransactionInfo ChangePassword(ChangePassword changePassword) { MDTTransactionInfo mdt = null; try { List <SqlParameter> prm = new List <SqlParameter>(); //SqlParameter email = new SqlParameter("@email", changePassword.Email); //prm.Add(email); //SqlParameter oldPwd = new SqlParameter("@oldPwd", changePassword.OldPassword); //prm.Add(oldPwd); //SqlParameter NewPwd = new SqlParameter("@newPwd", changePassword.NewPassword); //prm.Add(NewPwd); //SqlParameter status = new SqlParameter("@Status", 0); //status.Direction = ParameterDirection.Output; //prm.Add(status); prm = DatabaseSettings.BindParamers(APIHelper.updatePasswordParameters, changePassword.Email + "~||~" + changePassword.OldPassword + "~||~" + changePassword.NewPassword); int StatusValue = 0; DataSet ds = DatabaseSettings.GetDataSet(APIHelper.updatePassword, out StatusValue, prm); mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds); } catch (Exception ex) { mdt.status = HttpStatusCode.ExpectationFailed; mdt.msgCode = MessageCode.TechnicalError; mdt.message = "Technical Error in the system, please contact to administrator"; } return(mdt); }
/// <summary> /// It will check if login user is valid user or not /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> public bool IsValid(string userName, string password) { List <SqlParameter> prm = new List <SqlParameter>(); //SqlParameter userid = new SqlParameter("@username", userName); //prm.Add(userid); //SqlParameter filepath = new SqlParameter("@password", password); //prm.Add(filepath); //SqlParameter status = new SqlParameter("@Status", 0); //status.Direction = ParameterDirection.Output; //prm.Add(status); prm = DatabaseSettings.BindParamers(APIHelper.checkLoginParameters, userName + "~||~" + password); int statusValue = 0; bool IsVaild = false; DataSet ds = DatabaseSettings.GetDataSet(APIHelper.checkLogin, out statusValue, prm); if (statusValue == 1) { IsVaild = true; } else if (statusValue == 0) { IsVaild = false; } return(IsVaild); }
private MDTTransactionInfo GetBasicInputOptions(int basicInputID) { MDTTransactionInfo mdt = new MDTTransactionInfo(); try { IEnumerable <BasicInputOptions> basicInputOptions = null; List <SqlParameter> prm = new List <SqlParameter>(); //SqlParameter Basic_Input_ID = new SqlParameter("@BASIC_INPUT_ID", basicInputID); //prm.Add(Basic_Input_ID); //SqlParameter status = new SqlParameter("@Status", 0); //status.Direction = ParameterDirection.Output; //prm.Add(status); prm = DatabaseSettings.BindParamers(APIHelper.getBasicInputDetailsParameters, basicInputID.ToString()); int statusValue = 0; DataSet ds = DatabaseSettings.GetDataSet("sp_GetBasicInputDetails", out statusValue, prm); DataTable dt; if (statusValue == 1) { dt = ds.Tables[0]; if (dt.Rows.Count > 0) { basicInputOptions = from d in dt.AsEnumerable() select new BasicInputOptions { BASIC_INPUT_OPTN_ID = d.Field <int>("BASIC_INPUT_OPTN_ID"), INPUT_OPT_NAME = d.Field <string>("INPUT_OPT_NAME"), BASIC_INPUT_ID = d.Field <int>("BASIC_INPUT_ID"), //CONFIGURATION_ID = d.Field<int>("CONFIGURATION_ID"), //CONFIG_INPUT_OPT_ID = d.Field<int>("CONFIG_INPUT_OPT_ID"), //UPDT_USER_ID = d.Field<int>("UPDT_USER_ID") }; } mdt.msgCode = MessageCode.Success; mdt.status = HttpStatusCode.OK; mdt.message = "Record found"; mdt.transactionObject = basicInputOptions; } else if (statusValue == 5 || statusValue == 6) { mdt = DatabaseSettings.GetTransObject(null, statusValue, "", ds); } } catch (Exception ex) { mdt.status = HttpStatusCode.ExpectationFailed; mdt.msgCode = MessageCode.TechnicalError; mdt.message = "Technical Error in the system, please contact to administrator"; } return(mdt); }
/// <summary> /// This will return the list side menu from Solution to Configuration /// </summary> /// <returns></returns> public MDTTransactionInfo GetSideMenu(int UserID) { MDTTransactionInfo mdt = new MDTTransactionInfo(); try { IEnumerable <SolutionList> solutionLists = null; //List<SqlParameter> prm = new List<SqlParameter>(); //SqlParameter Status = new SqlParameter("@Status", 0); //Status.Direction = ParameterDirection.Output; //prm.Add(Status); List <SqlParameter> prm = DatabaseSettings.BindParamers(); int StatusValue = 0; DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getSolutions, out StatusValue, prm); DataTable dt; if (StatusValue == 1) { dt = ds.Tables[0]; if (dt.Rows.Count > 0) { solutionLists = from d in dt.AsEnumerable() select new SolutionList { SOLUTION_ID = d.Field <int>("SOLUTION_ID"), SOLUTION_NAME = d.Field <string>("SOLUTION_NAME"), Packages = GetPackageList(d.Field <int>("SOLUTION_ID"), UserID).transactionObject as IEnumerable <PackageList> }; } //mdt = DatabaseSettings.GetTransObject(solutionLists, StatusValue, "Record Found", ds); mdt.msgCode = MessageCode.Success; mdt.status = HttpStatusCode.OK; mdt.message = "Record found"; mdt.transactionObject = solutionLists; } else if (StatusValue == 5 || StatusValue == 6) { mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds); } } catch (Exception ex) { mdt.status = HttpStatusCode.ExpectationFailed; mdt.msgCode = MessageCode.TechnicalError; mdt.message = "Technical Error in the system, please contact to administrator"; } return(mdt); }
/// <summary> /// It will return respective equipment SAP links to navigate SAP /// </summary> /// <param name="EquipmentID"></param> /// <returns></returns> public MDTTransactionInfo GetEquipmentSAPLinks(int equipmentID) { MDTTransactionInfo mdt = new MDTTransactionInfo(); try { IEnumerable <EquipmentSAPLink> equipmentSAPLinks = null; List <SqlParameter> prm = new List <SqlParameter>(); prm = DatabaseSettings.BindParamers(APIHelper.getEquipmentSAPLinksParameters, equipmentID.ToString()); int statusValue = 0; DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getEquipmentSAPLinks, out statusValue, prm); DataTable dt; if (statusValue == 1) { dt = ds.Tables[0]; if (dt.Rows.Count > 0) { equipmentSAPLinks = from d in dt.AsEnumerable() select new EquipmentSAPLink { SAP_LINK_ID = d.Field <int>("SAP_LINK_ID"), EQUIPMENT_ID = d.Field <int>("EQUIPMENT_ID"), NAME = d.Field <string>("NAME"), DESCRIPTION = d.Field <string>("DESCRIPTION"), SAP_LINK_URL = d.Field <string>("SAP_LINK_URL"), }; mdt = DatabaseSettings.GetTransObject(equipmentSAPLinks, statusValue, "System equipment SAP links fetched successfully", ds); } else { mdt.msgCode = MessageCode.Failed; mdt.status = HttpStatusCode.NoContent; mdt.message = "No record found"; } } } catch (Exception ex) { mdt.status = HttpStatusCode.ExpectationFailed; mdt.msgCode = MessageCode.TechnicalError; mdt.message = "Technical Error in the system, please contact to administrator"; // Need to log error in logger from ex } return(mdt); }
/// <summary> /// It return all package list for respective Solution /// </summary> /// <param name="SolutionID"></param> /// <param name="UserID"></param> /// <returns></returns> private MDTTransactionInfo GetPackageList(int solutionID, int userID) { MDTTransactionInfo mdt = new MDTTransactionInfo(); try { IEnumerable <PackageList> packageLists = null; List <SqlParameter> prm = DatabaseSettings.BindParamers(APIHelper.getPackageListParameters, solutionID.ToString()); int statusValue = 0; DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getPackageList, out statusValue, prm); DataTable dt; if (statusValue == 1) { dt = ds.Tables[0]; if (dt.Rows.Count > 0) { packageLists = from d in dt.AsEnumerable() select new PackageList { PACKAGE_ID = d.Field <int>("PACKAGE_ID"), PACKAGE_NAME = d.Field <string>("PACKAGE_NAME"), SOLUTION_ID = d.Field <int>("SOLUTION_ID"), Configurations = GetConfigurationList(userID, d.Field <int>("PACKAGE_ID")).transactionObject as IEnumerable <ConfigurationList> }; } mdt.msgCode = MessageCode.Success; mdt.status = HttpStatusCode.OK; mdt.message = "Record found"; mdt.transactionObject = packageLists; } else if (statusValue == 5 || statusValue == 6) { mdt = DatabaseSettings.GetTransObject(null, statusValue, "", ds); } } catch (Exception ex) { mdt.status = HttpStatusCode.ExpectationFailed; mdt.msgCode = MessageCode.TechnicalError; mdt.message = "Technical Error in the system, please contact to administrator"; } return(mdt); }
/// <summary> /// It will return Top 3 configurations for respective package and User /// </summary> /// <param name="UserID"></param> /// <param name="PackageID"></param> /// <returns></returns> private MDTTransactionInfo GetConfigurationList(int UserID, int PackageID) { MDTTransactionInfo mdt = new MDTTransactionInfo(); IEnumerable <ConfigurationList> configLists = null; //List<SqlParameter> prm = new List<SqlParameter>(); //SqlParameter userID = new SqlParameter("@UserID", UserID); //prm.Add(userID); //SqlParameter packageID = new SqlParameter("@PackageID", PackageID); //prm.Add(packageID); //SqlParameter NoofConfiguration = new SqlParameter("@NoofConfiguration", 3); //prm.Add(NoofConfiguration); //SqlParameter Status = new SqlParameter("@Status", 0); //Status.Direction = ParameterDirection.Output; //prm.Add(Status); List <SqlParameter> prm = DatabaseSettings.BindParamers(APIHelper.getLatestConfigurationsParameters, UserID.ToString() + "," + PackageID.ToString() + ",3"); int StatusValue = 0; DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getLatestConfigurations, out StatusValue, prm); DataTable dt; if (StatusValue == 1) { dt = ds.Tables[0]; if (dt.Rows.Count > 0) { configLists = from d in dt.AsEnumerable() select new ConfigurationList { CONFIGURATION_ID = d.Field <int>("CONFIGURATION_ID"), CONFIGURATION_NAME = d.Field <string>("CONFIGURATION_NAME"), PACKAGE_ID = d.Field <int>("PACKAGE_ID") }; } mdt.msgCode = MessageCode.Success; mdt.status = HttpStatusCode.OK; mdt.message = "Record found"; mdt.transactionObject = configLists; } else if (StatusValue == 5 || StatusValue == 6) { mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds); } return(mdt); }
/// <summary> /// It return all package list for respective Solution /// </summary> /// <param name="SolutionID"></param> /// <param name="UserID"></param> /// <returns></returns> private MDTTransactionInfo GetPackageList(int SolutionID, int UserID) { IEnumerable <PackageList> packageLists = null; //PackageList packageList = null; MDTTransactionInfo mdt = new MDTTransactionInfo(); //List<SqlParameter> prm = new List<SqlParameter>(); //SqlParameter Solution_ID = new SqlParameter("@SolutionID", SolutionID); //prm.Add(Solution_ID); //SqlParameter Status = new SqlParameter("@Status", 0); //Status.Direction = ParameterDirection.Output; //prm.Add(Status); List <SqlParameter> prm = DatabaseSettings.BindParamers(APIHelper.getPackageListParameters, SolutionID.ToString()); int StatusValue = 0; DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getPackageList, out StatusValue, prm); DataTable dt; if (StatusValue == 1) { dt = ds.Tables[0]; if (dt.Rows.Count > 0) { packageLists = from d in dt.AsEnumerable() select new PackageList { PACKAGE_ID = d.Field <int>("PACKAGE_ID"), PACKAGE_NAME = d.Field <string>("PACKAGE_NAME"), SOLUTION_ID = d.Field <int>("SOLUTION_ID"), Configurations = GetConfigurationList(UserID, d.Field <int>("PACKAGE_ID")).transactionObject as IEnumerable <ConfigurationList> }; } mdt.msgCode = MessageCode.Success; mdt.status = HttpStatusCode.OK; mdt.message = "Record found"; mdt.transactionObject = packageLists; } else if (StatusValue == 5 || StatusValue == 6) { mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds); } return(mdt); }
/// <summary> /// It will return Top 3 configurations for respective package and User /// </summary> /// <param name="UserID"></param> /// <param name="PackageID"></param> /// <returns></returns> private MDTTransactionInfo GetConfigurationList(int userID, int packageID) { MDTTransactionInfo mdt = new MDTTransactionInfo(); try { IEnumerable <ConfigurationList> configLists = null; List <SqlParameter> prm = DatabaseSettings.BindParamers(APIHelper.getLatestConfigurationsParameters, userID.ToString() + "~||~" + packageID.ToString() + "~||~" + ConfigurationManager.AppSettings["NumberOfConfiguration"].ToString()); int StatusValue = 0; DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getLatestConfigurations, out StatusValue, prm); DataTable dt; if (StatusValue == 1) { dt = ds.Tables[0]; if (dt.Rows.Count > 0) { configLists = from d in dt.AsEnumerable() select new ConfigurationList { CONFIGURATION_ID = d.Field <int>("CONFIGURATION_ID"), CONFIGURATION_NAME = d.Field <string>("CONFIGURATION_NAME"), PACKAGE_ID = d.Field <int>("PACKAGE_ID") }; } mdt.msgCode = MessageCode.Success; mdt.status = HttpStatusCode.OK; mdt.message = "Record found"; mdt.transactionObject = configLists; } else if (StatusValue == 5 || StatusValue == 6) { mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds); } } catch (Exception ex) { mdt.status = HttpStatusCode.ExpectationFailed; mdt.msgCode = MessageCode.TechnicalError; mdt.message = "Technical Error in the system, please contact to administrator"; } return(mdt); }
/// <summary> /// This will update the user profile pic path into DB after upload. /// </summary> /// <param name="UserID"></param> /// <param name="filePath"></param> /// <returns></returns> public MDTTransactionInfo UploadProfilePic(int userID, string filePath) { MDTTransactionInfo mdt = null; try { List <SqlParameter> prm = new List <SqlParameter>(); //SqlParameter userid = new SqlParameter("@UserID", userID); //prm.Add(userid); //SqlParameter filepath = new SqlParameter("@ProfilePic", filePath); //prm.Add(filepath); //SqlParameter status = new SqlParameter("@Status", 0); //status.Direction = ParameterDirection.Output; //prm.Add(status); prm = DatabaseSettings.BindParamers(APIHelper.uploadProfilePicParameters, userID.ToString() + "~||~" + filePath.ToString()); int StatusValue = 0; DataSet ds = DatabaseSettings.GetDataSet(APIHelper.uploadProfilePic, out StatusValue, prm); UploadProfilePics uploadProfilePics = new UploadProfilePics(); if (StatusValue == 1) { mdt = new MDTTransactionInfo(); uploadProfilePics.ProfilePicPath = filePath; mdt.transactionObject = uploadProfilePics; mdt.status = HttpStatusCode.OK; mdt.msgCode = MessageCode.Success; mdt.message = "File uploaded successfully"; } else if (StatusValue == 5 || StatusValue == 6) { mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds); } } catch (Exception ex) { mdt.status = HttpStatusCode.ExpectationFailed; mdt.msgCode = MessageCode.TechnicalError; mdt.message = "Technical Error in the system, please contact to administrator"; } return(mdt); }
/// <summary> /// It will return the list of Suppliers /// </summary> /// <returns></returns> public IEnumerable <Supplier> GetSuppliers(int systemID, int equipmentID, int configurationID, string equipment_Type) { MDTTransactionInfo mdt = new MDTTransactionInfo(); //Suppliers = new List<Supplier>(); try { List <SqlParameter> prm = new List <SqlParameter>(); prm = DatabaseSettings.BindParamers(APIHelper.getSuppiersParameters, systemID.ToString() + "~||~" + equipmentID.ToString() + "~||~" + configurationID.ToString() + "~||~" + equipment_Type.ToString()); int statusValue = 0; DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getSuppiers, out statusValue, prm); DataTable dt; if (statusValue == 1) { dt = ds.Tables[0]; if (dt.Rows.Count > 0) { Suppliers = from d in dt.AsEnumerable() select new Supplier { SUPPLIER_ID = d.Field <int>("SUPPLIER_ID"), EQUIPMENT_ID = d.Field <int>("EQUIPMENT_ID"), SYSTEM_ID = d.Field <int>("SYSTEM_ID"), SUPPLIER_NAME = d.Field <string>("SUPPLIER_NAME"), COST = d.Field <double>("COST"), VALID_FROM = d.Field <DateTime>("VALID_FROM"), VALID_TO = d.Field <DateTime>("VALID_TO") }; } } } catch (Exception ex) { throw new Exception("Technical Error in the system, please contact to administrator"); // Need to log error in logger from ex } return(Suppliers); }
/// <summary> /// This will return list of Basic input options available in database /// </summary> /// <returns></returns> public MDTTransactionInfo GetBasicInputs(int packageID, int configurationID) { MDTTransactionInfo mdt = new MDTTransactionInfo(); try { IEnumerable <BasicInput> basicInputs = null; List <SqlParameter> prm = new List <SqlParameter>(); //SqlParameter status = new SqlParameter("@Status", 0); //status.Direction = ParameterDirection.Output; //prm.Add(status); prm = DatabaseSettings.BindParamers(APIHelper.getBasicInputdParameters, packageID.ToString() + "~||~" + configurationID.ToString()); int statusValue = 0; DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getBasicInput, out statusValue, prm); DataTable dt; if (statusValue == 1) { mdt = new MDTTransactionInfo(); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { basicInputs = from d in dt.AsEnumerable() select new BasicInput { BASIC_INPUT_ID = d.Field <int>("BASIC_INPUT_ID"), DEFAULT_INPUT_OPT_ID = d.Field <int>("DEFAULT_INPUT_OPT_ID"), CONFIGURATION_ID = d.Field <int>("CONFIGURATION_ID"), UPDT_USER_ID = d.Field <int>("UPDT_USER_ID"), BASIC_INPUT_NAME = d.Field <string>("BASIC_INPUT_NAME"), BasicInputOptions = GetBasicInputOptions(d.Field <int>("BASIC_INPUT_ID")).transactionObject as IEnumerable <BasicInputOptions> }; } if (basicInputs != null) { mdt.transactionObject = basicInputs; mdt.status = HttpStatusCode.OK; mdt.msgCode = MessageCode.Success; mdt.message = "Fetched basic input detail successfully"; } else { mdt.transactionObject = null; mdt.status = HttpStatusCode.NotFound; mdt.msgCode = MessageCode.Failed; mdt.message = "No record found"; } } else if (statusValue == 5 || statusValue == 6) { mdt = DatabaseSettings.GetTransObject(null, statusValue, "", ds); } } catch (Exception ex) { mdt.status = HttpStatusCode.ExpectationFailed; mdt.msgCode = MessageCode.TechnicalError; mdt.message = "Technical Error in the system, please contact to administrator"; } return(mdt); }
/// <summary> /// This is login method and it will connect to DB and check if user is exists or not. If user exists then it will display the user detail /// </summary> /// <param name="userLogin"></param> /// <returns></returns> public MDTTransactionInfo Login(UserLogin userLogin) { MDTTransactionInfo mdt = null; try { UserLoginDetails loginDetails = null; List <SqlParameter> prm = new List <SqlParameter>(); //SqlParameter email = new SqlParameter("@email", userLogin.UserName); //prm.Add(email); //SqlParameter pwd = new SqlParameter("@pwd", userLogin.Password); //prm.Add(pwd); //SqlParameter status = new SqlParameter("@Status", 0); //status.Direction = ParameterDirection.Output; //prm.Add(status); prm = DatabaseSettings.BindParamers(APIHelper.getLoginDetailsParameters, userLogin.UserName + "~||~" + userLogin.Password); int StatusValue = 0; DataSet ds = DatabaseSettings.GetDataSet(APIHelper.getLoginDetails, out StatusValue, prm); DataTable dt; if (StatusValue == 1) { dt = ds.Tables[0]; mdt = new MDTTransactionInfo(); if (dt.Rows.Count > 0) { loginDetails = new UserLoginDetails(); loginDetails.USER_ID = Convert.ToInt32(dt.Rows[0]["USER_ID"]); loginDetails.FIRST_NAME = dt.Rows[0]["FIRST_NAME"].ToString(); loginDetails.LAST_NAME = dt.Rows[0]["LAST_NAME"].ToString(); loginDetails.EMAIL_ADDRESS = dt.Rows[0]["EMAIL_ADDRESS"].ToString(); loginDetails.FORCE_PWD_CHNG = Convert.ToBoolean(dt.Rows[0]["FORCE_PWD_CHNG"]); loginDetails.PHOTO = dt.Rows[0]["PHOTO"].ToString(); loginDetails.ROLE_NAME = dt.Rows[0]["ROLE_NAME"].ToString(); loginDetails.ROLE_ID = Convert.ToInt32(dt.Rows[0]["ROLE_ID"]); loginDetails.UserKey = SecurityEncryptDecrypt.Encrypt(dt.Rows[0]["EMAIL_ADDRESS"].ToString()); loginDetails.UserValue = SecurityEncryptDecrypt.Encrypt(dt.Rows[0]["PASSWORD"].ToString()); mdt.status = HttpStatusCode.OK; mdt.transactionObject = loginDetails; mdt.msgCode = MessageCode.Success; mdt.message = "Login Successfully"; } else { mdt.msgCode = MessageCode.Failed; mdt.status = HttpStatusCode.NoContent; mdt.message = "No record found"; } } else if (StatusValue == 5 || StatusValue == 6) { mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds); } } catch (Exception ex) { mdt.status = HttpStatusCode.ExpectationFailed; mdt.msgCode = MessageCode.TechnicalError; mdt.message = "Technical Error in the system, please contact to administrator"; } return(mdt); }