/// <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);
}
