protected void UpdateSelfPhone(object sender, GridViewUpdateEventArgs e)
{
var GridView1 = (GridView)EmployeeFormView.FindControl("GridView2");
var SpecificStaffPlaceId = (Guid)e.Keys[0];
string currentPhoneNumber = ((TextBox)GridView1.Rows[e.RowIndex]
.FindControl("txtCompanyName1")).Text;
string currentPhoneType = ((DropDownList)GridView1.Rows[e.RowIndex]
.FindControl("PhoneTypeDropDownList5")).SelectedValue;
string commandText = "update SpecificStaffPlace set PhoneTypeId='" + currentPhoneType + "',PhoneNumber='" + currentPhoneNumber + "' where Id='" + SpecificStaffPlaceId + "'";
SqlConnection connection = DBHelper.GetConnection();
var cmd = new SqlCommand(commandText, connection)
{
CommandType = CommandType.Text
};
try
{
connection.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
ShellLogger.WriteLog("DB.log", "Ошибка обновления стационарного номера", ex);
}
finally
{
connection.Close();
}
}
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();
}
}
/// <summary>
/// Gets the bytes uploaded by the FileUpload control and set them to the Photo property of the
/// passed in Employee entity.
/// </summary>
/// <param name="entity"> entity envolved in the Insert or Update action</param>
private void SetPicture(IEntityCore entity)
{
FileUpload fileUpload = (FileUpload)EmployeeFormView.FindControl("FileUpload1");
if (fileUpload.PostedFile != null && !string.IsNullOrEmpty(fileUpload.PostedFile.FileName) && fileUpload.PostedFile.InputStream != null)
{
((EmployeeEntity)entity).Photo = fileUpload.FileBytes;
}
}
protected void EmployeeFormView_ItemCreated(object sender, EventArgs e)
{
//EmployeeFormView.FindControl("Edit").Visible = false;
if (!DBHelper.CheckIfUserIsAdministrator(new Guid(Session["CurrentUser"].ToString())))
{
if (EmployeeFormView.CurrentMode == FormViewMode.ReadOnly)
{
EmployeeFormView.FindControl("Edit").Visible = false;
}
}
}
protected void UpdatePhone(object sender, GridViewUpdateEventArgs e)
{
var GridView1 = (GridView)EmployeeFormView.FindControl("UserPhonesGridView");
var EmployeePlaceId = (Guid)e.Keys[0];
string currentStreet = ((TextBox)GridView1.Rows[e.RowIndex]
.FindControl("StreetTextBox")).Text;
string currentEdifice = ((TextBox)GridView1.Rows[e.RowIndex]
.FindControl("EdificeTextBox")).Text;
string currentRegion = ((DropDownList)GridView1.Rows[e.RowIndex]
.FindControl("RegionList")).SelectedValue;
string phone = ((TextBox)GridView1.Rows[e.RowIndex]
.FindControl("txtCompanyName1")).Text;
string phoneType = ((DropDownList)GridView1.Rows[e.RowIndex]
.FindControl("PhoneTypeDropDownList")).SelectedValue;
UpdateEmployeeAddress(EmployeePlaceId, new Guid(currentRegion), currentStreet, currentEdifice, phone,
new Guid(phoneType));
}
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();
}
}
/// <summary>
/// Handles the SelectedIndexChanged event of the GridView
/// Use it to change the mode of the Employee Details FormView to the ReadOnly mode.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void EmployeesGridView_SelectedIndexChanged(object sender, EventArgs e)
{
EmployeeFormView.ChangeMode(FormViewMode.ReadOnly);
}
protected void DivisionDropDownList_OnSelectedIndexChanged3(object sender, EventArgs e)
{
var ddlist = (DropDownList)EmployeeFormView.FindControl("RegionList3");
ddlist.DataBind();
}
