protected void AddNewSelfPhone(object sender, EventArgs e)
{
var PhoneTypeDDL = (DropDownList)EmployeeFormView.FindControl("DropDownList2");
var regionList2 = (DropDownList)EmployeeFormView.FindControl("RegionList3");
var SpecificStaffDDL = (DropDownList)EmployeeFormView.FindControl("SpecificStaffDDL");
var txtContactName = (TextBox)EmployeeFormView.FindControl("TextBox1");
var locationId = new Guid(regionList2.SelectedValue);
var phoneTypeId = new Guid(PhoneTypeDDL.SelectedValue);
var specificStaffId = new Guid(SpecificStaffDDL.SelectedValue);
string phone = txtContactName.Text;
string commandText =
"insert into SpecificStaffPlace(Id,SpecificStaffId,LocationId,PhoneTypeId,PhoneNumber) values ('" + Guid.NewGuid() +
"','" + specificStaffId + "','" + locationId + "','" + phoneTypeId + "','" + phone + "')";
SqlConnection connection = DBHelper.GetConnection();
var cmd = new SqlCommand(commandText, connection)
{
CommandType = CommandType.Text
};
try
{
connection.Open();
cmd.ExecuteNonQuery();
EmployeeFormView.DataBind();
}
catch (Exception ex)
{
ShellLogger.WriteLog("DB.log", "Ошибка добавления стационарного номера", ex);
}
finally
{
connection.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
var employeeId = Request.Params["Id"];
if (employeeId == null)
{
Response.Redirect("Employees.aspx");
}
int parsedId = int.Parse(employeeId);
NorthwindEntities context = new NorthwindEntities();
var employee = new List <Employee>()
{
context.Employees.FirstOrDefault(x => x.EmployeeID == parsedId)
};
EmployeeDetailsView.DataSource = employee;
EmployeeDetailsView.DataBind();
EmployeeFormView.DataSource = employee;
EmployeeFormView.DataBind();
}
protected void AddFavoritesClicked(object sender, ImageClickEventArgs e)
{
var currentUserGuid = new Guid(Session["CurrentUser"].ToString());
string[] commandArguents = ((ImageButton)sender).CommandArgument.Split(';');
bool isFavorite = bool.Parse(commandArguents[1]);
var favoriteUserGuid = new Guid(commandArguents[0]);
SqlConnection connection = DBHelper.GetConnection();
string commandText = isFavorite ? "RemoveFavorites" : "AddFavorites";
var cmd = new SqlCommand(commandText, connection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add("@ParentUserGuid", SqlDbType.UniqueIdentifier);
cmd.Parameters["@ParentUserGuid"].Value = currentUserGuid;
cmd.Parameters.Add("@FavoriteUserGuid", SqlDbType.UniqueIdentifier);
cmd.Parameters["@FavoriteUserGuid"].Value = favoriteUserGuid;
try
{
connection.Open();
cmd.ExecuteNonQuery();
EmployeeFormView.DataBind();
//string popupScript = "<script language='javascript'>" +"showSuccessToast();" +"</script>";
//Page.ClientScript.RegisterStartupScript(typeof(Page), "popupScript", popupScript);
}
catch (Exception ex)
{
ShellLogger.WriteLog("DB.log", "Ошибка добаления сотрудника в избранное", ex);
}
finally
{
connection.Close();
}
}
