internal DataTable GetPhoneNumber(int loginID)
{
MySqlCommand cmd;
string MobileNumber = string.Empty;
DataTable Dt = new DataTable();
DataSet dset = new DataSet();
try
{
MySqlConnection con = GlobalConnection.getConnection();
cmd = new MySqlCommand("GetPhoneNumber", con);
cmd.Parameters.AddWithValue("?p_loginId", loginID);
cmd.Parameters.AddWithValue("?p_Phone", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("?p_FIRSTNAME", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("?p_LASTNAME", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.CommandType = CommandType.StoredProcedure;
MySqlDataAdapter sd = new MySqlDataAdapter(cmd);
sd.Fill(dset);
if (dset != null)
{
Dt = dset.Tables[0];
}
return(Dt);
}
catch (Exception ex)
{
log.Error(ex.Message);
return(Dt);
}
}
//Stored procedure needs to be added so with every upload a new table is created in database
protected void btnUpload_Click(object sender, EventArgs e)
{
if (uploader.HasFile)
{
if (Path.GetExtension(uploader.FileName).Equals(".xlsx"))
{
var excelFile = new ExcelPackage(uploader.FileContent);
var datatable = excelFile.ToDataTable();
var table = "SampleTable";
using (var conn = new SqlConnection(GlobalConnection.Connection("SQLConnectorTester")))
{
var bulkCopy = new SqlBulkCopy(conn);
bulkCopy.DestinationTableName = table;
conn.Open();
var schema = conn.GetSchema("Columns", new[] { null, null, table, null });
foreach (DataColumn sourceColumn in datatable.Columns)
{
foreach (DataRow row in schema.Rows)
{
if (string.Equals(sourceColumn.ColumnName, (string)row["COLUMN_NAME"], StringComparison.OrdinalIgnoreCase))
{
bulkCopy.ColumnMappings.Add(sourceColumn.ColumnName, (string)row["COLUMN_NAME"]);
break;
}
}
}
bulkCopy.WriteToServer(datatable);
lblShow.Text = "Check database.";
}
}
}
}
internal List <SelectListItem> getSlots()
{
List <SelectListItem> listTimeSlots = new List <SelectListItem>();
MySqlCommand cmd;
DataTable Dt = new DataTable();
DataSet dset = new DataSet();
try
{
MySqlConnection con = GlobalConnection.getConnection();
cmd = new MySqlCommand("sp_Timeslots", con);
cmd.CommandType = CommandType.StoredProcedure;
MySqlDataAdapter sd = new MySqlDataAdapter(cmd);
sd.Fill(Dt);
foreach (DataRow dR in Dt.Rows)
{
listTimeSlots.Add(new SelectListItem
{
Value = Convert.ToString(dR["SERVICE_ID"]),
Text = Convert.ToString(dR["SERVICETYPE"]),
});
}
return(listTimeSlots);
}
catch (Exception ex)
{
log.Error(ex.Message);
return(listTimeSlots);
}
}
public static List <Student> GetAllStudents()
{
List <Student> listStudents = new List <Student>();
GlobalConnection gc = new GlobalConnection();
SqlCommand cmd = new SqlCommand("SELECT * FROM Student", gc.cnn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Student student = new Student();
student.StudentID = Convert.ToInt32(rdr["StudentID"]);
student.Name = rdr["Name"].ToString();
student.RollNumber = rdr["RollNumber"].ToString();
//student.RollNumber = Convert.ToInt32(rdr["RollNumber"]);
student.Username = rdr["Username"].ToString();
student.Password = rdr["Password"].ToString();
student.Faculty = rdr["Faculty"].ToString();
student.Semester = rdr["Semester"].ToString();
student.Email = rdr["Email"].ToString();
student.Photo = rdr["Photo"].ToString();
listStudents.Add(student);
}
return(listStudents);
}
internal int TicketStatusUpdate(int Ticketid, int a_id, string time, string response, string ExpectedClosedate, string progress)
{
MySqlCommand cmd;
DataTable Dt = new DataTable();
int res = 0;
try
{
MySqlConnection con = GlobalConnection.getConnection();
cmd = new MySqlCommand("sp_TicketStatusupdate", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("?p_p_Ticketid", Ticketid);
cmd.Parameters.AddWithValue("?p_p_ApartmentID", a_id);
cmd.Parameters.AddWithValue("?p_p_TICKET_FLAG", 1);
cmd.Parameters.AddWithValue("?p_p_TICKET_SLOT", time);
cmd.Parameters.AddWithValue("?p_p_TICKET_EXP_CLOSURE_DATE", ExpectedClosedate);
cmd.Parameters.AddWithValue("?p_p_TICKET_RESPONSE", response);
cmd.Parameters.AddWithValue("?p_p_TICKET_STATUS", progress);
res = cmd.ExecuteNonQuery();
return(res);
}
catch (Exception ex)
{
log.Error(ex.Message);
return(res);
}
}
internal int SaveNewTicket(string Type, string Desc, int id)
{
MySqlCommand cmd;
DataTable Dt = new DataTable();
int res = 0;
try
{
MySqlConnection con = GlobalConnection.getConnection();
cmd = new MySqlCommand("createNewTicket", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("?p_p_TICKET_TYPE", Type);
cmd.Parameters.AddWithValue("?p_p_TICKET_DESC", Desc);
cmd.Parameters.AddWithValue("?p_p_TICKET_STATUS", "Pending");
cmd.Parameters.AddWithValue("?p_p_RAISED_BY_LOGIN_ID", id);
cmd.Parameters.AddWithValue("?p_p_TICKET_FLAG", "0");
res = cmd.ExecuteNonQuery();
return(res);
}
catch (Exception ex)
{
log.Error(ex.Message);
return(res);
}
}
/// <summary>
/// Shutdowns the specified world identifier.
/// </summary>
/// <param name="worldId">The world identifier.</param>
/// <param name="cancelToken">The cancel token.</param>
/// <param name="stream">The stream.</param>
private void Shutdown(string worldId, CancellationToken cancelToken, EeStream stream)
{
Console.WriteLine("Received signal to cancel for " + worldId);
GlobalConnection.Disconnect();
stream.Shutdown();
Core.pool.PutObject(GlobalConnect);
Console.WriteLine(worldId + " cleaned up. Bye!");
cancelToken.ThrowIfCancellationRequested();
}
public CreateTournament()
{
InitializeComponent();
GlobalConnection.InitializeConnection(DatabaseType.TXT);
loadDataToList();
connectListToData();
}
/// <summary>
/// Crawls the specified world identifier.
/// </summary>
/// <param name="worldId">The world identifier.</param>
/// <param name="cancelToken">The cancel token.</param>
public void Crawl(string worldId, CancellationToken cancelToken)
{
TheWorldId = worldId;
var eeEvent = new EeStream(worldId);
Client.Multiplayer.JoinRoom(worldId, null, // never create a new room. Ever!
delegate(Connection connection)
{
GlobalConnection = connection;
_stopwatch = new Stopwatch();
_stopwatch.Start();
Console.WriteLine(Client.ConnectUserId + " is connected to " + worldId);
GlobalConnection.Send("init");
GlobalConnection.Send("init2");
GlobalConnection.OnMessage +=
delegate(object sender, Message m) { eeEvent.Write(m, _stopwatch.Elapsed.TotalSeconds); };
GlobalConnection.OnDisconnect += delegate(object sender, string message)
{
if (message == "receivedBytes == 0")
{
Console.WriteLine("Disconnected because of immediate kick");
}
else
{
Console.WriteLine("Connection disconnected for " + worldId);
}
if (!cancelToken.IsCancellationRequested)
{
Shutdown(worldId, cancelToken, eeEvent);
}
};
});
//http://msdn.microsoft.com/en-us/library/system.timers.timer%28v=vs.110%29.aspx
// Create a timer with a two second interval.
// Hook up the Elapsed event for the timer.
Core.ATimer.Elapsed += delegate(Object source, ElapsedEventArgs e)
{
//Console.WriteLine("Timer fired for " + worldId);
if (cancelToken.IsCancellationRequested)
{
Shutdown(worldId, cancelToken, eeEvent);
}
};
Console.WriteLine("Got to end of function.");
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
GlobalConnection.OpenConnection();
var list = new List <Type>();
list.Add(new Cliente().GetType());
list.Add(new Fornecedor().GetType());
new SQLUtil().CreateDatabase(list);
Application.Run(new ClienteForm());
}
protected void Page_Load(object sender, EventArgs e)
{
questionDetails.DataBind();
GlobalConnection gc = new GlobalConnection();
SqlCommand cmd = new SqlCommand("SELECT Subject FROM Exam WHERE ExamID='" + Session["ExamID"].ToString() + "'", gc.cnn);
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
lblCurrentTest.Text = dr["Subject"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
questionDetails.DataBind();
GlobalConnection gc = new GlobalConnection();
SqlCommand cmd = new SqlCommand("SELECT Subject FROM Exam WHERE ExamID='" + Session["ExamID"].ToString() + "'", gc.cnn);
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
lblCurrentTest.Text = dr["Subject"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
try
{
GlobalConnection gc = new GlobalConnection();
HospitalClass hc = new HospitalClass();
DataTable dt = hc.selectForViewHospitalRecords_ForReport();
if (dt.Rows.Count > 0)
{
ltrMessage.Text = "";
ReportViewer1.Reset();
// OR Set Report Path
ReportViewer1.LocalReport.ReportPath = HttpContext.Current.Server.MapPath("Report_Hospital_OtherUserMaster.rdlc");
// Clear the Data Source
ReportViewer1.LocalReport.DataSources.Clear();
// Set a DataSource to the report
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dt));
ReportViewer1.DataBind();
// Refresh and Display Report
ReportViewer1.LocalReport.Refresh();
}
else
{
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dt));
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
ltrMessage.Text = "No data found!";
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dt));
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
}
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
GlobalConnection gc = new GlobalConnection();
SqlCommand cmd = new SqlCommand("SELECT * FROM Student WHERE Username='******'", gc.cnn);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
DataList1.DataSource = dt;
DataList1.DataBind();
}
catch (Exception) {
Response.Redirect("Student.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
GlobalConnection gc = new GlobalConnection();
SqlCommand cmd = new SqlCommand("SELECT * FROM Student WHERE Username='******'", gc.cnn);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
DataList1.DataSource = dt;
DataList1.DataBind();
}
catch(Exception){
Response.Redirect("Student.aspx");
}
}
internal DataTable Check(string user, string pass)
{
var userName="";
var password="";
string[] res = new string[10];
//SqlConnection objcon = new SqlConnection();
//objcon.ConnectionString = ConfigurationManager.ConnectionStrings["ConnString"].ToString();
//objcon.Open();
SqlCommand cmd;
SqlConnection con = GlobalConnection.getConnection();
cmd = new SqlCommand("CheckUSerExistence", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@User", user);
cmd.Parameters.Add("@pass", pass);
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
try
{
GlobalConnection gc = new GlobalConnection();
PatientClass pc = new PatientClass();
String username = Session["username"].ToString();
DataTable dt = pc.checkUpHistory(username);
if (dt.Rows.Count > 0)
{
ltrMessage.Text = "";
ReportViewer1.Reset();
// OR Set Report Path
ReportViewer1.LocalReport.ReportPath = HttpContext.Current.Server.MapPath("Report_PatientMaster.rdlc");
// Clear the Data Source
ReportViewer1.LocalReport.DataSources.Clear();
// Set a DataSource to the report
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dt));
ReportViewer1.DataBind();
// Refresh and Display Report
ReportViewer1.LocalReport.Refresh();
}
else
{
ltrMessage.Text = "No data found!";
ReportViewer1.Reset();
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
}
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
}
}
public List <TicketModel> getAllTableDetailsOwner(int id)
{
List <TicketModel> objTicketModel = new List <TicketModel>();
MySqlCommand cmd;
DataTable Dt = new DataTable();
try
{
MySqlConnection con = GlobalConnection.getConnection();
cmd = new MySqlCommand("getTicketListOwner", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("?p_p_ApartmentID", id);
MySqlDataAdapter sd = new MySqlDataAdapter(cmd);
sd.Fill(Dt);
foreach (DataRow dR in Dt.Rows)
{
objTicketModel.Add(new TicketModel
{
TicketID = Convert.ToString(dR["TICKET_ID"]),
Type = Convert.ToString(dR["TICKET_TYPE"]),
Description = Convert.ToString(dR["TICKET_DESC"]),
Raised_Date = Convert.ToString(dR["TICKET_RAISED_DATE"]),
Status = Convert.ToString(dR["TICKET_STATUS"]),
FIRSTNAME = Convert.ToString(dR["FIRSTNAME"]),
LASTNAME = Convert.ToString(dR["LASTNAME"]),
MOBILENO = Convert.ToString(dR["MOBILENO"]),
H_FLOOR_NO = Convert.ToString(dR["H_FLOOR_NO"]),
H_Number = Convert.ToString(dR["H_Number"]),
H_BLOCK = Convert.ToString(dR["H_BLOCK"]),
TicketNo = Convert.ToString(dR["TICKET_NUMBER"]),
});
}
return(objTicketModel);
}
catch (Exception ex)
{
log.Error(ex.Message);
return(objTicketModel);
}
}
protected void lnkbtn_W_Click(object sender, EventArgs e)
{
try
{
GlobalConnection gc = new GlobalConnection();
EntryUserClass euc = new EntryUserClass();
DataTable dt = euc.SelectForViewEntryUserRecords_SpecificLetter_ForReport("W");
if (dt.Rows.Count > 0)
{
ltrMessage.Text = "";
ReportViewer1.Reset();
// OR Set Report Path
ReportViewer1.LocalReport.ReportPath = HttpContext.Current.Server.MapPath("Report_EntryUser_OtherUserMaster.rdlc");
// Clear the Data Source
ReportViewer1.LocalReport.DataSources.Clear();
// Set a DataSource to the report
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dt));
ReportViewer1.DataBind();
// Refresh and Display Report
ReportViewer1.LocalReport.Refresh();
}
else
{
ReportViewer1.Reset();
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
ltrMessage.Text = "No data found!";
}
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
}
internal DataTable Check(string user, string pass)
{
var userName = "";
var password = "";
string[] res = new string[10];
//SqlConnection objcon = new SqlConnection();
//objcon.ConnectionString = ConfigurationManager.ConnectionStrings["ConnString"].ToString();
//objcon.Open();
MySqlCommand cmd;
MySqlConnection con = GlobalConnection.getConnection();
cmd = new MySqlCommand("CheckUSerExistence", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("?p_User", user);
cmd.Parameters.AddWithValue("?p_pass", pass);
MySqlDataAdapter sd = new MySqlDataAdapter(cmd);
DataTable DS = new DataTable();
sd.Fill(DS);
//foreach (DataRow dR in DS.Rows)
//{
// userName = Convert.ToString(dR["userName"]);
// password = Convert.ToString(dR["password"]);
//}
//if ((userName == user) && (password == pass)) //when you click login
//{
// res[0] = "1";
//}
return(DS);
}
internal DataSet getLocation()
{
List <SelectListItem> listLocations = new List <SelectListItem>();
MySqlCommand cmd;
DataTable Dt = new DataTable();
DataSet dset = new DataSet();
try
{
MySqlConnection con = GlobalConnection.getConnection();
cmd = new MySqlCommand("[getLocation]", con);
cmd.CommandType = CommandType.StoredProcedure;
MySqlDataAdapter sd = new MySqlDataAdapter(cmd);
sd.Fill(dset);
return(dset);
}
catch (Exception ex)
{
log.Error(ex.Message);
return(dset);
}
}
internal TicketModel getTicketCout(int id)
{
MySqlCommand cmd;
DataTable Dt = new DataTable();
TicketModel lstTicketCount = new TicketModel();
MySqlConnection con = GlobalConnection.getConnection();
try
{
cmd = new MySqlCommand("sp_TicketCount", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("?p_Apartment_ID", id);
cmd.Parameters.AddWithValue("?p_Processing", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("?p_Pending", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("?p_Completed", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("?p_Total", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
int p_processing = (int)cmd.Parameters["?p_Processing"].Value;
int p_completed = (int)cmd.Parameters["?p_Completed"].Value;
int p_pending = (int)cmd.Parameters["?p_Pending"].Value;
int p_total = (int)cmd.Parameters["?p_Total"].Value;
lstTicketCount.completed = p_completed;
lstTicketCount.pending = p_pending;
lstTicketCount.processing = p_processing;
lstTicketCount.total = p_total;
return(lstTicketCount);
}
catch (Exception ex)
{
log.Error(ex.Message);
return(lstTicketCount);
}
}
public DataTable FetchTicketDetail(int id, int a_id)
{
List <TicketModel> objTicketModel = new List <TicketModel>();
MySqlCommand cmd;
MySqlConnection con = GlobalConnection.getConnection();
DataTable Dt = new DataTable();
try
{
cmd = new MySqlCommand("FetchTicketDetail", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("?p_Ticket_id", id);
cmd.Parameters.AddWithValue("?p_Apart_id", a_id);
MySqlDataAdapter sd = new MySqlDataAdapter(cmd);
sd.Fill(Dt);
return(Dt);
}
catch (Exception ex)
{
log.Error(ex.Message);
return(Dt);
}
}
public static List<Student> GetAllStudents()
{
List<Student> listStudents = new List<Student>();
GlobalConnection gc = new GlobalConnection();
SqlCommand cmd = new SqlCommand("SELECT * FROM Student", gc.cnn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Student student = new Student();
student.StudentID = Convert.ToInt32(rdr["StudentID"]);
student.Name = rdr["Name"].ToString();
student.RollNumber = rdr["RollNumber"].ToString();
//student.RollNumber = Convert.ToInt32(rdr["RollNumber"]);
student.Username = rdr["Username"].ToString();
student.Password = rdr["Password"].ToString();
student.Faculty = rdr["Faculty"].ToString();
student.Semester = rdr["Semester"].ToString();
student.Email = rdr["Email"].ToString();
student.Photo = rdr["Photo"].ToString();
listStudents.Add(student);
}
return listStudents;
}
public PersonModel SavePersonModel(PersonModel new_model)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConnection.ConnectionName(nameOfConnection)))
{
var p = new DynamicParameters();
p.Add("FirstName", new_model.firstName);
p.Add("@LastName", new_model.lastName);
p.Add("@Email", new_model.Email);
p.Add("@Telephone", new_model.Telephone);
p.Add("@id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("spPeople_insert_data", p, commandType: CommandType.StoredProcedure);
new_model.Id = p.Get <int>("@id");
return(new_model);
}
}
public List <PersonModel> GetAllPeople()
{
List <PersonModel> output;
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConnection.ConnectionName(nameOfConnection)))
{
output = connection.Query <PersonModel>("dbo.spSelectAllPeople").ToList();
}
return(output);
}
public List <CustomerModel> getAllTableDetails(int a_id, int permission_id)
{
List <CustomerModel> regdetails = new List <CustomerModel>();
MySqlCommand cmd;
try
{
MySqlConnection con = GlobalConnection.getConnection();
DataTable Dt = new DataTable();
cmd = new MySqlCommand("CustomerRecordsDesc", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("?p_p_id", 0);
cmd.Parameters.AddWithValue("?p_first_name", "");
cmd.Parameters.AddWithValue("?p_last_name", "");
cmd.Parameters.AddWithValue("?p_city", "");
cmd.Parameters.AddWithValue("?p_country", "");
cmd.Parameters.AddWithValue("?p_phone", "");
cmd.Parameters.AddWithValue("?p_H_id", 0);
cmd.Parameters.AddWithValue("?p_middle_name", "");
cmd.Parameters.AddWithValue("?p_mobileno", "");
cmd.Parameters.AddWithValue("?p_address", "");
cmd.Parameters.AddWithValue("?p_username", "");
cmd.Parameters.AddWithValue("?p_password", "");
//cmd.Parameters.AddWithValue("?p_lastlogindate","");
cmd.Parameters.AddWithValue("?p_state", "");
cmd.Parameters.AddWithValue("?p_action", "");
cmd.Parameters.AddWithValue("?p_a_id", a_id);
cmd.Parameters.AddWithValue("?p_Permission_id", permission_id);
MySqlDataAdapter sd = new MySqlDataAdapter(cmd);
sd.Fill(Dt);
foreach (DataRow dR in Dt.Rows)
{
regdetails.Add(new CustomerModel
{
id = Convert.ToInt32(dR["LOGINID"]),
firstName = Convert.ToString(dR["FIRSTNAME"]),
lastName = Convert.ToString(dR["LASTNAME"]),
phoneNO = Convert.ToString(dR["phone"]),
country = Convert.ToString(dR["COUNTRY"]),
h_id = Convert.ToInt32(dR["h_id"]),
middleName = Convert.ToString(dR["MIDDLENAME"]),
mobileNo = Convert.ToString(dR["MOBILENO"]),
address = Convert.ToString(dR["country"]),
userName = Convert.ToString(dR["USERNAME"]),
password = Convert.ToString(dR["country"]),
// lastLoginDate = Convert.ToString(dR["LASTLOGGEDDATE"]),
state = Convert.ToString(dR["STATE"]),
city = Convert.ToString(dR["CITY"]),
houseNo = Convert.ToString(dR["H_NUMBER"]),
blockNo = Convert.ToString(dR["H_BLOCK"]),
floorNo = Convert.ToString(dR["H_FLOOR_NO"]),
});
}
return(regdetails);
}
catch (Exception ex)
{
log.Error(ex.Message);
return(regdetails);
}
}
internal string[] SaveRecord(int id, string FirstName, string LastName, string Contact, string City, string Country,
string proof1, string proof2, string blockNo, string floorNo, string flatNo, string loginName, string pwd)
{
string[] res = new string[3];
MySqlCommand cmd = null;
GlobalConnection conn = new GlobalConnection();
cmd.Connection = GlobalConnection.getConnection();
//conn.Open();
if (id == 0)
{
//cmd = new MySqlCommand("AddNewCustomer", objcon);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@p_id", id);
//cmd.Parameters.AddWithValue("@p_FirstName", FirstName);
//cmd.Parameters.AddWithValue("@p_LastName", LastName);
//cmd.Parameters.AddWithValue("@p_contact_Number", Contact);
//cmd.Parameters.AddWithValue("@p_City", City);
//cmd.Parameters.AddWithValue("@p_Country", Country);
//cmd.Parameters.AddWithValue("@p_Action", "I");
//res[0] = cmd.ExecuteNonQuery().ToString();
//res[0] = "Saved";
//cmd.CommandText = "AddNewCustomer";
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("p_id", OracleDbType.Long).Value = id;
//cmd.Parameters.AddWithValue("p_FirstName", OracleDbType.Varchar2).Value = FirstName;
//cmd.Parameters.AddWithValue("p_LastName", OracleDbType.Varchar2).Value = LastName;
//cmd.Parameters.AddWithValue("p_contact_Number", OracleDbType.Varchar2).Value = Contact;
//cmd.Parameters.AddWithValue("p_City", OracleDbType.Varchar2).Value =City;
//cmd.Parameters.AddWithValue("p_Country", OracleDbType.Varchar2).Value = Country;
//cmd.Parameters.AddWithValue("p_Action", OracleDbType.Varchar2).Value = "I";
//cmd.ExecuteNonQuery();
res[0] = "Saved";
}
else if (id != 0)
{
//cmd = new MySqlCommand("AddNewCustomer", objcon);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@p_id", id);
//cmd.Parameters.AddWithValue("@p_FirstName", FirstName);
//cmd.Parameters.AddWithValue("@p_LastName", LastName);
//cmd.Parameters.AddWithValue("@p_contact_Number", Contact);
//cmd.Parameters.AddWithValue("@p_City", City);
//cmd.Parameters.AddWithValue("@p_Country", Country);
//cmd.Parameters.AddWithValue("@p_Action", "U");
//res[0] = cmd.ExecuteNonQuery().ToString();
//res[0] = "Updated";
cmd.CommandText = "AddNewCustomer";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("?p_p_id", OracleDbType.Long).Value = id;
cmd.Parameters.AddWithValue("?p_p_FirstName", OracleDbType.Varchar2).Value = FirstName;
cmd.Parameters.AddWithValue("?p_p_LastName", OracleDbType.Varchar2).Value = LastName;
cmd.Parameters.AddWithValue("?p_p_contact_Number", OracleDbType.Varchar2).Value = Contact;
cmd.Parameters.AddWithValue("?p_p_City", OracleDbType.Varchar2).Value = City;
cmd.Parameters.AddWithValue("?p_p_Country", OracleDbType.Varchar2).Value = Country;
cmd.Parameters.AddWithValue("?p_p_Action", OracleDbType.Varchar2).Value = "U";
cmd.ExecuteNonQuery();
res[0] = "Updated";
}
return(res);
}
public List <TeamModel> GetAllTeams()
{
List <TeamModel> output;
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConnection.ConnectionName(nameOfConnection)))
{
output = connection.Query <TeamModel>("dbo.spSelectAllTeams").ToList();
foreach (TeamModel team in output)
{
var p = new DynamicParameters();
p.Add("@@TeamId", team.Id);
team.TeamMembers = connection.Query <PersonModel>("dbo.spSelectMembersByTeam", p, commandType: CommandType.StoredProcedure).ToList();
}
}
return(output);
}
public void SaveTournamentModel(TournamentModel new_moedl)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConnection.ConnectionName(nameOfConnection)))
{
var p = new DynamicParameters();
p.Add("@TournamentName", new_moedl.TournamentName);
p.Add("@EntryFee", new_moedl.entryFee);
p.Add("@id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("spTournament_insert_data", p, commandType: CommandType.StoredProcedure);
new_moedl.ID = p.Get <int>("@id");
foreach (PrizeModel prize in new_moedl.Prizes)
{
p = new DynamicParameters();
p.Add("@TournamentID", new_moedl.ID);
p.Add("@PrizeID", prize.Id);
p.Add("@id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("spTournamentPrizes_insert_data", p, commandType: CommandType.StoredProcedure);
}
foreach (TeamModel team in new_moedl.EnteredTeams)
{
p = new DynamicParameters();
p.Add("@TournamentID", new_moedl.ID);
p.Add("@TeamID", team.Id);
p.Add("@id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("spTournamentEntries_insert_data", p, commandType: CommandType.StoredProcedure);
}
}
}
public TeamModel SaveTeamModel(TeamModel new_model)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConnection.ConnectionName(nameOfConnection)))
{
var p = new DynamicParameters();
p.Add("@TeamName", new_model.TeamName);
p.Add("@id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("dbo.spTeams_insert_data", p, commandType: CommandType.StoredProcedure);
new_model.Id = p.Get <int>("@id");
foreach (PersonModel person in new_model.TeamMembers)
{
var p2 = new DynamicParameters();
p2.Add("@TeamId", new_model.Id);
p2.Add("@PersonId", person.Id);
connection.Execute("dbo.spTeamMembers_insert_data", p2, commandType: CommandType.StoredProcedure);
}
return(new_model);
}
}
/// <summary>
/// Saves the pzize to the SQL database
/// </summary>
/// <param name="new_model">The prize information</param>
/// <returns>The prize information including the unique identifier.</returns>
public PrizeModel SavePrizeModel(PrizeModel new_model)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConnection.ConnectionName(nameOfConnection)))
{
var p = new DynamicParameters();
p.Add("@PlaceNumber", new_model.PlaceNumber);
p.Add("@PlaceName", new_model.PlaceName);
p.Add("@PrizeAmount", new_model.PrizeAmount);
p.Add("@PrizePercentage", new_model.PricePercentage);
p.Add("@id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("dbo.spPrizes_insert_data", p, commandType: CommandType.StoredProcedure);
new_model.Id = p.Get <int>("@id");
return(new_model);
}
}
