protected void GridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
SqlConnection con = new ConnectionMediator().ConnectionProvider();
int id = Convert.ToInt32((JobPortalView.Rows[e.RowIndex].FindControl("TxtId") as TextBox).Text);
string firstname = (JobPortalView.Rows[e.RowIndex].FindControl("TxtName") as TextBox).Text;
string lastname = (JobPortalView.Rows[e.RowIndex].FindControl("TxtLastName") as TextBox).Text;
string address = (JobPortalView.Rows[e.RowIndex].FindControl("TxtAddress") as TextBox).Text;
string gender = (JobPortalView.Rows[e.RowIndex].FindControl("TxtGender") as TextBox).Text;
string role = (JobPortalView.Rows[e.RowIndex].FindControl("TxtRole") as TextBox).Text;
string password = (JobPortalView.Rows[e.RowIndex].FindControl("TxtPassword") as TextBox).Text;
string email = (JobPortalView.Rows[e.RowIndex].FindControl("TxtEmail") as TextBox).Text;
long phonenumber = long.Parse((JobPortalView.Rows[e.RowIndex].FindControl("TxtPhone") as TextBox).Text);
con.Open();
SqlCommand cmd = new SqlCommand("sp_JOBPORTALGRID_UPDATE", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@firstname", firstname);
cmd.Parameters.AddWithValue("@lastname", lastname);
cmd.Parameters.AddWithValue("@phonenumber", phonenumber);
cmd.Parameters.AddWithValue("@address", address);
cmd.Parameters.AddWithValue("@gender", gender);
cmd.Parameters.AddWithValue("@role", role);
cmd.Parameters.AddWithValue("@email", email);
cmd.Parameters.AddWithValue("@password", password);
cmd.ExecuteNonQuery();
con.Close();
JobPortalView.EditIndex = -1;
FillData();
}
protected void GridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
SqlConnection con = new ConnectionMediator().ConnectionProvider();
int id = Convert.ToInt16(RecruiterView.DataKeys[e.RowIndex].Values["AccountId"].ToString());
con.Open();
SqlCommand cmd = new SqlCommand("sp_JOBPORTALGRID_DELETE", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", id);
int i = cmd.ExecuteNonQuery();
con.Close();
FillData();
}
protected void FillData()
{
SqlConnection con = new ConnectionMediator().ConnectionProvider();
SqlCommand cmd = new SqlCommand("sp_JOBPORTALGRID_VIEW", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@userid", id);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
RecruiterView.DataSource = dt;
RecruiterView.DataBind();
}
static void Main()
{
#region Useless
//////create a new server
////var server = new UdpListener();
//////start listening for messages and copy the messages back to the client
////Task.Factory.StartNew(async () =>
////{
//// while (true)
//// {
//// try
//// {
//// Console.Write("StartToListen" + "\n");
//// var received = await server.Receive();
//// var recievedDatagram = BinarySerializer.Deserialize<Datagrams.AbstractTypes.AbstractDatagram>(received.Datagram);
//// Console.Write("Someone try to connect" + "\n");
//// if (recievedDatagram.GetDatagramId() == RequestIdentifiers.Connect)
//// {
//// Console.Write("Someone is connected " + received.EndPoint.Address + " " + received.EndPoint.Port + "\n");
//// server.Reply(BinarySerializer.Serialize(new ConnectedRequestBody(){Description = "connected"}), received.EndPoint);
//// }
//// //Console.Write(" "+ recievedDatagram.GetDatagramId()+"\n");
//// //Console.Write("copy " + " msg: " + transformRequest.Message + "\n" +
//// // "position: " + transformRequest.Position.x + " " + transformRequest.Position.y +" " + transformRequest.Position.z + "\n" +
//// // "rotation: " + transformRequest.Rotation.x + " " + transformRequest.Rotation.y + " "+transformRequest.Rotation.z + " " +transformRequest.Rotation.w + "\n");
//// //if (transformRequest.Message == "quit")
//// //break;
//// }
//// catch (Exception e)
//// {
//// Console.WriteLine(e);
//// throw;
//// }
//// }
////});
////// create a new client
//////var client = UdpUser.ConnectTo("127.0.0.1", 32123);
////////wait for reply messages from server and send them to console
//////Task.Factory.StartNew(async () =>
//////{
////// while (true)
////// {
////// try
////// {
////// var received = await client.Receive();
////// Console.WriteLine("user: "******" received.Message" + "\n");
////// //if (received.Message.Contains("quit"))
////// //break;
////// }
////// catch (Exception ex)
////// {
////// Console.WriteLine(ex);
////// }
////// }
//////});
//////type ahead :-)
////string read;
////do
////{
//// read = Console.ReadLine();
//// //client.Send(read);
////} while (read != "quit");
#endregion
var userManager = new UserManager();
var connectionMediator = new ConnectionMediator();
connectionMediator.InjectDependencies(userManager);
connectionMediator.StartStreaming();
Console.Write("Start Server\n");
string read;
do
{
read = Console.ReadLine();
} while (read != "quit");
}
