public bool DeleteAdviserData(AdviserDTO oAdviserDTO)
{
bool ReturnValue = false;
try
{
using (HttpClient client = new HttpClient())
{
string path = "Adviser/DeleteAdviserData";
client.BaseAddress = new Uri(GlobalValues.BaseUri);
var json = JsonConvert.SerializeObject(oAdviserDTO);
var content = new StringContent(json, Encoding.UTF8, "application/json");
HttpResponseMessage responce = client.PostAsync(path, content).Result;
if (responce.IsSuccessStatusCode)
{
string jsnString = responce.Content.ReadAsStringAsync().Result;
ReturnValue = JsonConvert.DeserializeObject <bool>(jsnString);
}
}
}
catch (Exception ex)
{
string message = ex.Message;
}
return(ReturnValue);
}
public AdviserDTO AdviserSearchByFilters(string adviserName, int adviserType)
{
AdviserDTO oAdviserDTO = new AdviserDTO();
try
{
using (HttpClient client = new HttpClient())
{
string path = "Adviser/AdviserSearchByFilters?adviserName=" + adviserName + "&adviserType=" + adviserType;
client.BaseAddress = new Uri(GlobalValues.BaseUri);
HttpResponseMessage responce = client.GetAsync(path).Result;
if (responce.IsSuccessStatusCode)
{
var value = responce.Content.ReadAsStringAsync().Result;
oAdviserDTO = JsonConvert.DeserializeObject <AdviserDTO>(value);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(oAdviserDTO);
}
private void ViewAdviserData()
{
try
{
LoadDropDownList();
GridViewRow oGridViewRow = gvAdviser.Rows[Convert.ToInt32(ViewState["index"])];
Label lblAdviserId = (Label)oGridViewRow.FindControl("lblAdviserId");
Session["AdviserId"] = lblAdviserId.Text;
AdviserDTO oAdviserDTO = new AdviserDTO();
oAdviserDTO = oWebApiCalls.AdviserSearchById(Convert.ToInt32(lblAdviserId.Text));
txtName.Text = oAdviserDTO.Name;
txtAddress.Text = oAdviserDTO.Address;
txtTelephone.Text = oAdviserDTO.Telephone;
txtEmail.Text = oAdviserDTO.Email;
txtDescription.InnerText = oAdviserDTO.Description;
ddlType.SelectedValue = Convert.ToString((int)oAdviserDTO.Type);
txtJoinDate.Text = oAdviserDTO.JoinDate.ToString("yyyy-MM-dd");
//txtNoOfShares.Text = Convert.ToString(oAdviserDTO.NumberOfShares);
//txtSharePrice.Text = Convert.ToString(oAdviserDTO.SharePrice);
ddlStatus.SelectedValue = Convert.ToString((int)oAdviserDTO.Status);
string DecryptedPwd = Cryptography.Encryption.Decrypt(oAdviserDTO.Password, oAdviserDTO.UserName);
txtUserName.Text = oAdviserDTO.UserName;
txtPassword.Text = DecryptedPwd;
ControllersHandler(CommandMood.View);
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
throw ex;
}
}
private void DeleteAdviserData()
{
bool result = false;
try
{
GridViewRow oGridViewRow = gvAdviser.Rows[Convert.ToInt32(ViewState["index"])];
Label lblAdviserId = (Label)oGridViewRow.FindControl("lblAdviserId");
AdviserDTO oAdviserDTO = new AdviserDTO();
oAdviserDTO.AdviserId = Convert.ToInt32(lblAdviserId.Text);
oAdviserDTO.Status = (int)Status.Inactive;
oAdviserDTO.ModifiedUser = Session["UserID"].ToString();
oAdviserDTO.ModifiedDateTime = DateTime.Now;
oAdviserDTO.ModifiedMachine = Session["UserMachine"].ToString();
result = oWebApiCalls.DeleteAdviserData(oAdviserDTO);
if (result == true)
{
ResetControllers();
Messages("Adviser Deleted Successfully!!");
}
else
{
Messages("Connection Error!");
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
throw ex;
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
AdviserDTO oAdviserDTO = new AdviserDTO();
string adviserName = string.Empty;
int adviserType = 0;
if (txtAdviserName.Text.Length > 0)
{
adviserName = txtAdviserName.Text;
}
if (ddlAdviserType.SelectedIndex > 0)
{
adviserType = ddlAdviserType.SelectedIndex;
}
oAdviserDTO = oWebApiCalls.AdviserSearchByFilters(adviserName, adviserType);
txtName.Text = oAdviserDTO.Name;
txtAddress.Text = oAdviserDTO.Address;
txtTelephone.Text = oAdviserDTO.Telephone;
txtEmail.Text = oAdviserDTO.Email;
txtDescription.InnerText = oAdviserDTO.Description;
ddlType.SelectedValue = Convert.ToString((int)oAdviserDTO.Type);
txtJoinDate.Text = Convert.ToString(oAdviserDTO.JoinDate);
ddlStatus.SelectedValue = Convert.ToString((int)oAdviserDTO.Status);
string DecryptedPwd = Cryptography.Encryption.Decrypt(oAdviserDTO.Password, oAdviserDTO.UserName);
txtUserName.Text = oAdviserDTO.UserName;
txtPassword.Text = DecryptedPwd;
ControllersHandler(CommandMood.View);
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
}
public bool AdviserInsert(AdviserMaintanance oAdviserMaintanance)
{
AdviserDTO oAdviserDTOs = oAdviserMaintanance.oAdviserDTO;
LoginDTO oLoginDTOs = oAdviserMaintanance.oLoginDTO;
int resultCount = 0;
try
{
using (UniversalConnection oUniversalConnection = new UniversalConnection(Connection.Common.ConnectionString))
{
StringBuilder varname1 = new StringBuilder();
varname1.Append("INSERT INTO Adviser \n");
varname1.Append(" (Name, \n");
varname1.Append(" Address, \n");
varname1.Append(" Telephone, \n");
varname1.Append(" Email, \n");
varname1.Append(" Description, \n");
varname1.Append(" Type, \n");
varname1.Append(" JoinDate, \n");
varname1.Append(" Status, \n");
varname1.Append(" UserName, \n");
varname1.Append(" Password, \n");
varname1.Append(" CreatedUser, \n");
varname1.Append(" CreatedMachine, \n");
varname1.Append(" CreatedDateTime, \n");
varname1.Append(" ModifiedUser, \n");
varname1.Append(" ModifiedMachine, \n");
varname1.Append(" ModifiedDateTime) \n");
varname1.Append("VALUES (?Name, \n");
varname1.Append(" ?Address, \n");
varname1.Append(" ?Telephone, \n");
varname1.Append(" ?Email, \n");
varname1.Append(" ?Description, \n");
varname1.Append(" ?Type, \n");
varname1.Append(" ?JoinDate, \n");
varname1.Append(" ?Status, \n");
varname1.Append(" ?UserName, \n");
varname1.Append(" ?Password, \n");
varname1.Append(" ?CreatedUser, \n");
varname1.Append(" ?CreatedMachine, \n");
varname1.Append(" ?CreatedDateTime, \n");
varname1.Append(" ?ModifiedUser, \n");
varname1.Append(" ?ModifiedMachine, \n");
varname1.Append(" ?ModifiedDateTime)");
oUniversalConnection.CommandText = varname1.ToString();
oUniversalConnection.Parameters.Clear();
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Name", Value = (object)oAdviserDTOs.Name ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Address", Value = (object)oAdviserDTOs.Address ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Telephone", Value = (object)oAdviserDTOs.Telephone ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Email", Value = (object)oAdviserDTOs.Email ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Description", Value = (object)oAdviserDTOs.Description ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Type", Value = (object)oAdviserDTOs.Type ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "JoinDate", Value = (object)oAdviserDTOs.JoinDate ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Status", Value = (object)oAdviserDTOs.Status ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "UserName", Value = (object)oAdviserDTOs.UserName ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Password", Value = (object)oAdviserDTOs.Password ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "CreatedUser", Value = (object)oAdviserDTOs.CreatedUser ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "CreatedMachine", Value = (object)oAdviserDTOs.CreatedMachine ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "CreatedDateTime", Value = (object)oAdviserDTOs.CreatedDateTime ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "ModifiedUser", Value = (object)oAdviserDTOs.ModifiedUser ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "ModifiedMachine", Value = (object)oAdviserDTOs.ModifiedMachine ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "ModifiedDateTime", Value = (object)oAdviserDTOs.ModifiedDateTime ?? DBNull.Value
});
resultCount = oUniversalConnection.ExecuteQuery();
StringBuilder varname2 = new StringBuilder();
varname2.Append("INSERT INTO Users \n");
varname2.Append(" (UserName, \n");
varname2.Append(" Password, \n");
varname2.Append(" UserType, \n");
varname2.Append(" LoginAttempts, \n");
varname2.Append(" CreatedUser, \n");
varname2.Append(" CreatedMachine, \n");
varname2.Append(" CreatedDateTime, \n");
varname2.Append(" ModifiedUser, \n");
varname2.Append(" ModifiedMachine, \n");
varname2.Append(" ModifiedDateTime) \n");
varname2.Append("VALUES (?UserName, \n");
varname2.Append(" ?Password, \n");
varname2.Append(" ?UserType, \n");
varname2.Append(" ?LoginAttempts, \n");
varname2.Append(" ?CreatedUser, \n");
varname2.Append(" ?CreatedMachine, \n");
varname2.Append(" ?CreatedDateTime, \n");
varname2.Append(" ?ModifiedUser, \n");
varname2.Append(" ?ModifiedMachine, \n");
varname2.Append(" ?ModifiedDateTime)");
oUniversalConnection.CommandText = varname2.ToString();
oUniversalConnection.Parameters.Clear();
oUniversalConnection.Parameters.Add(new Parameter {
Name = "UserName", Value = (object)oLoginDTOs.UserName ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Password", Value = (object)oLoginDTOs.Password ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "UserType", Value = (object)oLoginDTOs.UserType ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "LoginAttempts", Value = (object)oLoginDTOs.LoginAttempts ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "CreatedUser", Value = (object)oLoginDTOs.CreatedUser ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "CreatedMachine", Value = (object)oLoginDTOs.CreatedMachine ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "CreatedDateTime", Value = (object)oLoginDTOs.CreatedDateTime ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "ModifiedUser", Value = (object)oLoginDTOs.ModifiedUser ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "ModifiedMachine", Value = (object)oLoginDTOs.ModifiedMachine ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "ModifiedDateTime", Value = (object)oLoginDTOs.ModifiedDateTime ?? DBNull.Value
});
resultCount = oUniversalConnection.ExecuteQuery();
return(resultCount > 0);
}
}
catch (Exception ex)
{
Logger.Write(ex);
throw ex;
}
}
public AdviserDTO AdviserSearchById(int AdviserId)
{
AdviserDTO result = new AdviserDTO();
try
{
using (UniversalConnection oUniversalConnection = new UniversalConnection(Connection.Common.ConnectionString))
{
StringBuilder varname1 = new StringBuilder();
varname1.Append("SELECT [AdviserId], \n");
varname1.Append(" [Name], \n");
varname1.Append(" [Address], \n");
varname1.Append(" [Telephone], \n");
varname1.Append(" [Email], \n");
varname1.Append(" [Description], \n");
varname1.Append(" [Type], \n");
varname1.Append(" [JoinDate], \n");
varname1.Append(" [Status], \n");
varname1.Append(" [UserName], \n");
varname1.Append(" [Password], \n");
varname1.Append(" [CreatedUser], \n");
varname1.Append(" [CreatedMachine], \n");
varname1.Append(" [CreatedDatetime], \n");
varname1.Append(" [ModifiedUser], \n");
varname1.Append(" [ModifiedMachine], \n");
varname1.Append(" [ModifiedDatetime] \n");
varname1.Append("FROM Adviser \n");
varname1.Append("WHERE [Status] = ?Status");
varname1.Append(" AND [AdviserId] = ?AdviserId");
oUniversalConnection.CommandText = varname1.ToString();
oUniversalConnection.Parameters.Clear();
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Status", Value = Status.Active
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "AdviserId", Value = AdviserId
});
using (IDataReader dr = oUniversalConnection.ExecuteReader())
{
while (dr.Read())
{
result.AdviserId = Helper.GetDataValue <int>(dr, "AdviserId");
result.Name = Helper.GetDataValue <string>(dr, "Name");
result.Address = Helper.GetDataValue <string>(dr, "Address");
result.Telephone = Helper.GetDataValue <string>(dr, "Telephone");
result.Email = Helper.GetDataValue <string>(dr, "Email");
result.Description = Helper.GetDataValue <string>(dr, "Description");
result.Type = Helper.GetDataValue <int>(dr, "Type");
result.JoinDate = Helper.GetDataValue <DateTime>(dr, "JoinDate");
result.Status = Helper.GetDataValue <int>(dr, "Status");
result.UserName = Helper.GetDataValue <string>(dr, "UserName");
result.Password = Helper.GetDataValue <string>(dr, "Password");
result.CreatedUser = Helper.GetDataValue <string>(dr, "CreatedUser");
result.CreatedMachine = Helper.GetDataValue <string>(dr, "CreatedMachine");
result.CreatedDateTime = Helper.GetDataValue <DateTime>(dr, "CreatedDateTime");
result.ModifiedUser = Helper.GetDataValue <string>(dr, "ModifiedUser");
result.ModifiedMachine = Helper.GetDataValue <string>(dr, "ModifiedMachine");
result.ModifiedDateTime = Helper.GetDataValue <DateTime>(dr, "ModifiedDateTime");
}
dr.Close();
}
}
}
catch (Exception ex)
{
Logger.Write(ex);
throw ex;
}
return(result);
}
public bool AdviserUpdate(AdviserMaintanance oAdviserMaintanance)
{
AdviserDTO oAdviserDTOs = oAdviserMaintanance.oAdviserDTO;
LoginDTO oLoginDTOs = oAdviserMaintanance.oLoginDTO;
int resultCount = 0;
try
{
using (UniversalConnection oUniversalConnection = new UniversalConnection(Connection.Common.ConnectionString))
{
oUniversalConnection.Parameters.Clear();
StringBuilder varname1 = new StringBuilder();
varname1.Append("UPDATE Adviser \n");
varname1.Append("SET \n");
varname1.Append(" Name = ?Name, \n");
varname1.Append(" Address = ?Address, \n");
varname1.Append(" Telephone = ?Telephone, \n");
varname1.Append(" Email = ?Email, \n");
varname1.Append(" Description = ?Description, \n");
varname1.Append(" Type = ?Type, \n");
varname1.Append(" JoinDate = ?JoinDate, \n");
varname1.Append(" Status = ?Status, \n");
varname1.Append(" UserName = ?UserName, \n");
varname1.Append(" Password = ?Password, \n");
varname1.Append(" ModifiedUser = ?ModifiedUser, \n");
varname1.Append(" ModifiedMachine = ?ModifiedMachine, \n");
varname1.Append(" ModifiedDateTime = ?ModifiedDateTime \n");
varname1.Append(" WHERE AdviserId = ?AdviserId");
oUniversalConnection.CommandText = varname1.ToString();
oUniversalConnection.Parameters.Add(new Parameter {
Name = "AdviserId", Value = (object)oAdviserDTOs.AdviserId ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Name", Value = (object)oAdviserDTOs.Name ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Address", Value = (object)oAdviserDTOs.Address ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Telephone", Value = (object)oAdviserDTOs.Telephone ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Email", Value = (object)oAdviserDTOs.Email ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Description", Value = (object)oAdviserDTOs.Description ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Type", Value = (object)oAdviserDTOs.Type ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "JoinDate", Value = (object)oAdviserDTOs.JoinDate ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Status", Value = (object)oAdviserDTOs.Status ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "UserName", Value = (object)oAdviserDTOs.UserName ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Password", Value = (object)oAdviserDTOs.Password ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "ModifiedUser", Value = (object)oAdviserDTOs.ModifiedUser ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "ModifiedMachine", Value = (object)oAdviserDTOs.ModifiedMachine ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "ModifiedDateTime", Value = (object)oAdviserDTOs.ModifiedDateTime ?? DBNull.Value
});
resultCount = oUniversalConnection.ExecuteQuery();
StringBuilder varname2 = new StringBuilder();
varname2.Append("UPDATE Users \n");
varname2.Append(" SET [UserName] = ?UserName \n");
varname2.Append(" ,[Password] = ?Password \n");
varname2.Append(" ,[UserType] = ?UserType \n");
varname2.Append(" ,[LoginAttempts] = ?LoginAttempts \n");
varname2.Append(" ,[ModifiedUser] = ?ModifiedUser \n");
varname2.Append(" ,[ModifiedMachine] = ?ModifiedMachine \n");
varname2.Append(" ,[ModifiedDateTime] = ?ModifiedDateTime \n");
varname2.Append("WHERE UserName = ?UserName \n");
oUniversalConnection.CommandText = varname2.ToString();
oUniversalConnection.Parameters.Clear();
oUniversalConnection.Parameters.Add(new Parameter {
Name = "UserName", Value = (object)oLoginDTOs.UserName ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "Password", Value = (object)oLoginDTOs.Password ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "UserType", Value = (object)oLoginDTOs.UserType ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "LoginAttempts", Value = (object)oLoginDTOs.LoginAttempts ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "ModifiedUser", Value = (object)oLoginDTOs.ModifiedUser ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "ModifiedMachine", Value = (object)oLoginDTOs.ModifiedMachine ?? DBNull.Value
});
oUniversalConnection.Parameters.Add(new Parameter {
Name = "ModifiedDateTime", Value = (object)oLoginDTOs.ModifiedDateTime ?? DBNull.Value
});
oUniversalConnection.ExecuteQuery();
}
return(resultCount > 0);
}
catch (Exception ex)
{
Logger.Write(ex);
throw ex;
}
}
public bool DeleteAdviserData(AdviserDTO oCompanyDTO)
{
return(oAdviserBL.AdviserDelete(oCompanyDTO));
}
protected void btnAAdd_Click(object sender, EventArgs e)
{
bool result = false;
try
{
#region Adviser
AdviserDTO oAdviserDTOs = new AdviserDTO();
oAdviserDTOs.Name = txtAName.Text;
oAdviserDTOs.Address = txtAAddress.Text;
oAdviserDTOs.Telephone = txtATelephone.Text;
oAdviserDTOs.Email = txtAEmail.Text;
oAdviserDTOs.Description = txtADescription.InnerText;
oAdviserDTOs.Type = Convert.ToInt32(ddlAType.SelectedValue.ToString());
oAdviserDTOs.JoinDate = Convert.ToDateTime(dtpAJoinDate.Text);
oAdviserDTOs.Status = Convert.ToInt32(ddlAStatus.SelectedValue.ToString());
oAdviserDTOs.UserName = txtAUserName.Text;
string EncryptedPwd = Cryptography.Encryption.Encrypt(txtAPassword.Text, txtAUserName.Text);
oAdviserDTOs.Password = EncryptedPwd;
oAdviserDTOs.CreatedUser = Session["UserID"].ToString();
oAdviserDTOs.CreatedDateTime = DateTime.Now;
oAdviserDTOs.CreatedMachine = Session["UserMachine"].ToString();
oAdviserDTOs.ModifiedUser = Session["UserID"].ToString();
oAdviserDTOs.ModifiedDateTime = DateTime.Now;
oAdviserDTOs.ModifiedMachine = Session["UserMachine"].ToString();
#endregion
#region Login
LoginDTO oLoginDTOs = new LoginDTO();
oLoginDTOs.UserName = txtAUserName.Text;
oLoginDTOs.Password = EncryptedPwd;
oLoginDTOs.UserType = Convert.ToInt32(Session["UserType"].ToString());
oLoginDTOs.LoginAttempts = 1;
oLoginDTOs.CreatedUser = Session["UserID"].ToString();
oLoginDTOs.CreatedDateTime = DateTime.Now;
oLoginDTOs.CreatedMachine = Session["UserMachine"].ToString();
oLoginDTOs.ModifiedUser = Session["UserID"].ToString();
oLoginDTOs.ModifiedDateTime = DateTime.Now;
oLoginDTOs.ModifiedMachine = Session["UserMachine"].ToString();
#endregion
AdviserMaintanance oAdviserMaintanance = new AdviserMaintanance();
oAdviserMaintanance.oAdviserDTO = oAdviserDTOs;
oAdviserMaintanance.oLoginDTO = oLoginDTOs;
result = oWebApiCalls.InsertAdviserData(oAdviserMaintanance);
if (result == true)
{
ResetControllers();
Messages("Adviser Inserted Successfully!!");
}
else
{
Messages("Connection Error!");
}
}
catch (Exception ex)
{
throw ex;
}
}
private void UpdateAdviserData()
{
bool result = false;
try
{
AdviserDTO oAdviserDTO = new AdviserDTO();
oAdviserDTO.AdviserId = Convert.ToInt32(Session["AdviserId"].ToString());
oAdviserDTO.Name = txtName.Text;
oAdviserDTO.Address = txtAddress.Text;
oAdviserDTO.Telephone = txtTelephone.Text;
oAdviserDTO.Email = txtEmail.Text;
oAdviserDTO.Description = txtDescription.InnerText;
oAdviserDTO.Type = Convert.ToInt32(ddlType.SelectedValue.ToString());
oAdviserDTO.JoinDate = Convert.ToDateTime(txtJoinDate.Text);
//oAdviserDTO.NumberOfShares = Convert.ToInt32(txtNoOfShares.Text);
//oAdviserDTO.SharePrice = Convert.ToDecimal(txtSharePrice.Text);
oAdviserDTO.Status = Convert.ToInt32(ddlStatus.SelectedValue.ToString());
oAdviserDTO.UserName = txtUserName.Text;
string EncryptedPwd = Cryptography.Encryption.Encrypt(txtPassword.Text, txtUserName.Text);
oAdviserDTO.Password = EncryptedPwd;
oAdviserDTO.ModifiedUser = Session["UserID"].ToString();
oAdviserDTO.ModifiedDateTime = DateTime.Now;
oAdviserDTO.ModifiedMachine = Session["UserMachine"].ToString();
#region Login
LoginDTO oLoginDTOs = new LoginDTO();
oLoginDTOs.UserName = txtUserName.Text;
oLoginDTOs.Password = EncryptedPwd;
oLoginDTOs.UserType = Convert.ToInt32(Session["UserType"].ToString());
oLoginDTOs.LoginAttempts = 1;
oLoginDTOs.ModifiedUser = Session["UserID"].ToString();
oLoginDTOs.ModifiedDateTime = DateTime.Now;
oLoginDTOs.ModifiedMachine = Session["UserMachine"].ToString();
#endregion
AdviserMaintanance oAdviserMaintanance = new AdviserMaintanance();
oAdviserMaintanance.oAdviserDTO = oAdviserDTO;
oAdviserMaintanance.oLoginDTO = oLoginDTOs;
result = oWebApiCalls.UpdateAdviserData(oAdviserMaintanance);
if (result == true)
{
ResetControllers();
Messages("Adviser Updated Successfully!!");
}
else
{
Messages("Connection Error!");
}
}
catch (Exception ex)
{
throw ex;
}
}
