private void UpdateDownloads(int id)
{
string path = "";
string ext = "";
string file_name = "";
int fileSize = 0;
try
{
System.Data.SqlTypes.SqlDateTime nullDate;
nullDate = SqlDateTime.Null;
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_UpdateDownload";
obj.AddParam("@id", id);
obj.AddParam("@download_type", rbtnDownloadType.SelectedItem.Text.ToString());
try
{
obj.AddParam("@event_date", DateTime.Parse(event_date.SelectedDate.ToString()));
}
catch
{ obj.AddParam("@event_date", nullDate); }
obj.AddParam("@event_name", txtEventName.Text.ToString());
obj.AddParam("@title", txtTitle.Text.ToString());
obj.AddParam("@author", txtAuthor.Text.ToString());
try
{
obj.AddParam("@file_name", Session["DownloadedFile"].ToString());
}
catch { obj.AddParam("@file_name", ""); }
int exe = obj.ExecuteNonQuery();
if (exe > 0)
{
clear();
showmsg("Download Has Been Updated Successfully !", "view_download.aspx");
}
}
catch (Exception ex)
{ }
}
public async Task Unclaim(ulong side)
{
DBconnection _conn = DBconnection.Instance();
_conn.DBName = "cynicalp_weebnation";
ulong CurrentOwnerID = 0;
ulong DiceID = 0;
if (_conn.IsConnected())
{
string query = "SELECT DiceID,DiceOwner FROM dice WHERE DiceNumber=@side";
var cmd = new MySqlCommand(query, _conn.Connection);
cmd.Parameters.AddWithValue("@side", side);
var reader = await cmd.ExecuteReaderAsync();
if (!reader.HasRows)
{
return;
}
while (await reader.ReadAsync())
{
DiceID = (ulong)reader.GetInt64(0);
CurrentOwnerID = (ulong)reader.GetInt64(1);
}
_conn.Close();
}
if (CurrentOwnerID != Context.User.Id || DiceID == 0)
{
await Context.Channel.SendErrorAsync("You cannot unclaim a side you do not own.");
return;
}
if (_conn.IsConnected())
{
string query = "DELETE FROM dice WHERE DiceID=@did";
var cmd = new MySqlCommand(query, _conn.Connection);
cmd.Parameters.AddWithValue("@did", DiceID);
await cmd.ExecuteNonQueryAsync();
_conn.Close();
}
await Context.Channel.SendSuccessAsync($"Side ${side} successfully unclaimed.");
}
public void IncreaseQuantity(int quantity)
{
DBconnection dbConnection = new DBconnection();
dbConnection.OpenConnection();
string query = "UPDATE products SET quantity = quantity + @quantity, updated_at = NOW() WHERE id = @id";
using (MySqlCommand cmd = new MySqlCommand(query, dbConnection.connection))
{
cmd.Parameters.AddWithValue("@quantity", quantity);
cmd.Parameters.AddWithValue("@id", this.Id);
cmd.ExecuteNonQuery();
}
}
// Get
public DataTable SearchDownloadsByAlphabet()
{
DataTable dt = new DataTable();
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_SearchByAlphabetDownloads";
obj.AddParam("@name", this.title);
dt = obj.ExecuteTable();
}
catch { }
return(dt);
}
public DataTable GetDownloadsByDownloadsType()
{
DataTable dt = new DataTable();
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetDownloadsByDownloadType";
obj.AddParam("@download_type", this.downloadType);
dt = obj.ExecuteTable();
}
catch { }
return(dt);
}
public Candidate DeleteCandidate(int id)
{
Candidate Candidate = GetCandidateById(id);
var SessionFactory = DBconnection.GetSessionFactory();
using (var session = SessionFactory.OpenSession())
{
using (var trans = session.BeginTransaction())
{
session.Delete(Candidate);
trans.Commit();
}
}
return(Candidate);
}
public bool SAVEStudentDAL(StudentInformation aStudent, string Details)
{
SqlConnection connection = DBconnection.OpenConnection();
string query = "insert into Students(CID,StudentID,Name) values((select ID from Course where Course.Details='" + Details + "'),'" + aStudent.StudentID + "','" + aStudent.name + "' )";
SqlCommand Action = new SqlCommand(query, connection);
int Result = Action.ExecuteNonQuery();
if (Result > 0)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult GastosCategoria()
{
int id = Convert.ToInt32(Session["user"].ToString());
SqlCommand comando = new DBconnection().GetConnction();
comando.CommandText = @"SELECT categorias.nome AS 'categoria', SUM(gastos.valor) AS 'valor', cartoes.id_pessoas FROM categorias INNER JOIN gastos
ON gastos.id_categoria = categorias.Id INNER JOIN cartoes ON cartoes.Id = gastos.id_cartao
WHERE MONTH(gastos.entrada) = MONTH(GETDATE()) AND cartoes.id_pessoas = @ID GROUP BY categorias.nome, cartoes.id_pessoas";
comando.Parameters.AddWithValue("@ID", id);
DataTable tabela = new DataTable();
tabela.Load(comando.ExecuteReader());
return(Content(JsonConvert.SerializeObject(new { tabela })));
}
public int AddFeedback()
{
int i = 0;
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_AddFeedback";
obj.AddParam("@name", this.Name);
obj.AddParam("@emailid", this.EmailId);
obj.AddParam("@club_name", this.ClubName);
obj.AddParam("@mobile", this.Mobile);
obj.AddParam("@comments", this.Comments);
obj.AddParam("@ipaddress", this.Ipaddress);
i = obj.ExecuteNonQuery();
return(i);
}
public bool Cancel_checkInDAL(int ReservationID, Cost aCost)
{
SqlConnection connection = DBconnection.OpenConnection();
string query = "UPDATE RECORD set CustomerStatus='Boocked' where RECORD.Id=" + ReservationID + " UPDATE ROOM set ROOM.Status='Available' where Room_Id=(SELECT RECORD.RoomId from RECORD where Record.id=" + ReservationID + ") Update COST set Due=" + aCost.Due + " +(select LastPayment from Cost where Id=" + ReservationID + ") where ID=" + ReservationID + "";
SqlCommand Action = new SqlCommand(query, connection);
int Result = Action.ExecuteNonQuery();
if (Result > 0)
{
return(true);
}
else
{
return(false);
}
}
private void GetAdminTeam(int id)
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "sp_GetAdminTeam";
obj.AddParam("@id", id);
DataTable dt = new DataTable();
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
DDLYears.SelectedItem.Text = dt.Rows[0]["years"].ToString();
DDLMemName.SelectedItem.Text = dt.Rows[0]["Name"].ToString();
DDLDesig.SelectedItem.Text = dt.Rows[0]["designation"].ToString();
}
}
private void GetProfile(int id)
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetDistMemberforAdminTeams";
obj.AddParam("@MemberId", id);
DataTable dt = new DataTable();
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
lblClubName.Text = dt.Rows[0]["club_name"].ToString();
}
}
catch { }
}
public bool DeleteRoomsDAL(Room aRoom)
{
SqlConnection connection = DBconnection.OpenConnection();
string query = "DELETE ROOM where Room_ID=" + aRoom.Id + "";
SqlCommand Action = new SqlCommand(query, connection);
int result = Action.ExecuteNonQuery();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateRoomInfoDAL(Room aRoom)
{
SqlConnection connection = DBconnection.OpenConnection();
string query = "Update ROOM set Floor='" + aRoom.Floor + "',RoomNo='" + aRoom.RoomNo + "',Type='" + aRoom.Type + "',Class='" + aRoom.Class + "',Rent=" + aRoom.Rent + " where Room_Id=" + aRoom.Id + " ";
SqlCommand Action = new SqlCommand(query, connection);
int result = Action.ExecuteNonQuery();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool SaveRoomsDAL(Room aRoom)
{
SqlConnection connection = DBconnection.OpenConnection();
string query = "Insert into Room(Floor,RoomNo,Type,Class,Rent,Status) values ('" + aRoom.Floor + "','" + aRoom.RoomNo + "','" + aRoom.Type + "','" + aRoom.Class + "'," + aRoom.Rent + ",'Available') ";
SqlCommand Action = new SqlCommand(query, connection);
int Result = Action.ExecuteNonQuery();
if (Result > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Save_Customer_DiscountDAL(Cost aCost)
{
SqlConnection connection = DBconnection.OpenConnection();
string query = "UPDATE COST set Total=" + aCost.TotalCost + ",Due=" + aCost.Due + ",Discount=" + aCost.Discount + " where id=" + aCost.Id + "";
SqlCommand Action = new SqlCommand(query, connection);
int Result = Action.ExecuteNonQuery();
if (Result > 0)
{
return(true);
}
else
{
return(false);
}
}
// Get RI President
public DataTable GetRIPresident()
{
DataTable dt = new DataTable();
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetRIPresident";
obj.AddParam("@id", this.id);
dt = obj.ExecuteTable();
}
catch { }
return(dt);
}
// Get Interact Club
public DataTable GetInteractClub()
{
DataTable dt = new DataTable();
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetInteractClub";
obj.AddParam("@interact_id", this.id);
dt = obj.ExecuteTable();
}
catch { }
return(dt);
}
public bool SaveEvaluationDAL(StudentInformation aStudent, Course aCourse)
{
SqlConnection connection = DBconnection.OpenConnection();
string query = "Update Students Set Attendance=" + aStudent.Attendance + ",Presentation=" + aStudent.Presentation + ",Assignment=" + aStudent.Assignment + ",Quiz1=" + aStudent.Quiz1 + ",Quiz2=" + aStudent.Quiz2 + ",Quiz3=" + aStudent.Quiz3 + ",QUIZ=" + aStudent.QUIZ + " ,Midterm=" + aStudent.Mid + ",Final=" + aStudent.Final + ",TotalMarks=" + aStudent.Total + ",EvaluationGrade='" + aStudent.EvaluationGrade + "' where Students.StudentID='" + aStudent.StudentID + "' and students.CID=(select ID from course where CourseID='" + aCourse.CourseID + "')";
SqlCommand Action = new SqlCommand(query, connection);
int Result = Action.ExecuteNonQuery();
if (Result > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool CancelReservationDAL(Customer aCustomer)
{
SqlConnection connection = DBconnection.OpenConnection();
string query = " UPDATE RECORD set CustomerStatus='Reservation Cancelled' where RECORD.Id=" + aCustomer.Id + "";
SqlCommand Action = new SqlCommand(query, connection);
int Result = Action.ExecuteNonQuery();
if (Result > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool DeleteStudentDAL(StudentInformation aStudent, string Details)
{
SqlConnection connection = DBconnection.OpenConnection();
string query = "Delete Students where CID=(select ID from Course where CourseID='" + Details + "') and StudentID='" + aStudent.StudentID + "' and Name='" + aStudent.name + "' ";
SqlCommand Action = new SqlCommand(query, connection);
int Result = Action.ExecuteNonQuery();
if (Result > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool RoomBooking_avilityDAL(Record aRecord)
{
SqlConnection connection = DBconnection.OpenConnection();
string Query = "UPDATE Record set RoomNo='" + aRecord.RoomNO + "' where RoomNo='" + aRecord.RoomNO + "' and (CheckInDate='" + aRecord.CheckInDate + "' or CheckInDate='" + aRecord.CheckOutDate + "' or CheckOutDate='" + aRecord.CheckInDate + "' or CheckOutDate='" + aRecord.CheckOutDate + "' or(CheckInDate Between '" + aRecord.CheckInDate + "' and '" + aRecord.CheckOutDate + "') or (CheckOutDate between '" + aRecord.CheckInDate + "' and '" + aRecord.CheckOutDate + "' ))";
SqlCommand Action = new SqlCommand(Query, connection);
int result = Action.ExecuteNonQuery();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public DataTable GetDownloadsById()
{
DataTable dt = new DataTable();
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetDownloadById";
obj.AddParam("@id", this.id);
dt = obj.ExecuteTable();
}
catch { }
return(dt);
}
public bool SaveReservationInformation_DAL(Customer aCustomer, Record aRecord, Cost aCost)
{
SqlConnection connection = DBconnection.OpenConnection();
string query = "Insert into CUSTOMER(Name,Age,Sex,DOB,Profession,ProfessionAddress,PermanentAddress,PresentAddress,ContactNo,Email,[NID/PassportNo]) Values('" + aCustomer.Name + "'," + aCustomer.Age + ",'" + aCustomer.Sex + "','" + aCustomer.DOB + "','" + aCustomer.Profession + "','" + aCustomer.ProfessionAddress + "','" + aCustomer.PermanentAddress + "','" + aCustomer.PresentAddress + "','" + aCustomer.ContactNo + "','" + aCustomer.Email + "','" + aCustomer.NIDorPassportNo + "') INSERT into RECORD(Id,RoomId,RoomNo,BookingDate,CheckInDate,CheckOutDate,PaymentStatus,CustomerStatus) values(" + aCustomer.Id + " ," + aRecord.RoomID + ",'" + aRecord.RoomNO + "','" + aRecord.BookingDate + "','" + aRecord.CheckInDate + "','" + aRecord.CheckOutDate + "','" + aRecord.PaymentStatus + "','Boocked') INSERT into COST values(" + aCustomer.Id + " ," + aCost.TotalCost + "," + aCost.Due + "," + aCost.LastPayment + ",0)";
SqlCommand Action = new SqlCommand(query, connection);
int Result = Action.ExecuteNonQuery();
if (Result > 0)
{
return(true);
}
else
{
return(false);
}
}
public DataTable GetDownloadsByEventType()
{
DataTable dt = new DataTable();
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetAllDowonloadsByEvents";
obj.AddParam("@event_name", this.eventName);
dt = obj.ExecuteTable();
}
catch { }
return(dt);
}
public DataTable GetRiDgDataCurrentYear()
{
DataTable dt = new DataTable();
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetRiDgDataCurrentYear";
obj.AddParam("@year", this.year);
dt = obj.ExecuteTable();
}
catch { }
return(dt);
}
protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
string i = e.CommandArgument.ToString();
int id = int.Parse(i.ToString());
DBconnection obj = new DBconnection();
obj.SetCommandSP = "sp_DeleteUpcomingEvent";
obj.AddParam("@id", id);
if (obj.ExecuteNonQuery() > 0)
{
//RadGrid1.DataBind();
ManageGrid();
}
}
}
public bool Confirm_PaymentDAL(Customer aCustomer, Record aRecord, Cost aCost)
{
SqlConnection connection = DBconnection.OpenConnection();
string query = "UPDATE CUSTOMER set CUSTOMER.Name = '" + aCustomer.Name + "',CUSTOMER.Age = " + aCustomer.Age + ",CUSTOMER.Sex = '" + aCustomer.Sex + "',CUSTOMER.DOB = '" + aCustomer.DOB + "',CUSTOMER.Profession = '" + aCustomer.Profession + "',CUSTOMER.ProfessionAddress = '" + aCustomer.ProfessionAddress + "',CUSTOMER.PermanentAddress = '" + aCustomer.PermanentAddress + "',CUSTOMER.PresentAddress = '" + aCustomer.PresentAddress + "',CUSTOMER.ContactNo = '" + aCustomer.ContactNo + "',CUSTOMER.Email = '" + aCustomer.Email + "',CUSTOMER.[NID/PassportNo] = '" + aCustomer.NIDorPassportNo + "' where CUSTOMER.Id = " + aCustomer.Id + " UPDATE RECORD set RoomId = " + aRecord.RoomID + ", RoomNo = '" + aRecord.RoomNO + "', BookingDate = '" + aRecord.BookingDate + "', CheckInDate = '" + aRecord.CheckInDate + "', CheckOutDate = '" + aRecord.CheckOutDate + "', PaymentStatus = '" + aRecord.PaymentStatus + "', CustomerStatus = 'Checked Out' where RECORD.Id = " + aCustomer.Id + " UPDATE COST Set Total= " + aCost.TotalCost + ", Due = " + aCost.Due + " where COST.Id = " + aCustomer.Id + "";
SqlCommand Action = new SqlCommand(query, connection);
int Result = Action.ExecuteNonQuery();
if (Result > 0)
{
return(true);
}
else
{
return(false);
}
}
private void GetPastDistrictGove(int id)
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetPastDistGove";
obj.AddParam("@id", id);
DataTable dt = new DataTable();
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
DDLYears.SelectedItem.Text = dt.Rows[0]["year"].ToString();
txtRotarian.Text = dt.Rows[0]["rotarian_name"].ToString();
txtClubName.Text = dt.Rows[0]["club_name"].ToString();
}
}
public bool Cancel_PaymentDAL(int ReservationID, Cost aCost)
{
SqlConnection connection = DBconnection.OpenConnection();
string query = "UPDATE COST set Due=" + aCost.Due + " +(select LastPayment from Cost where Id=" + ReservationID + ") where ID=" + ReservationID + " ";
SqlCommand Action = new SqlCommand(query, connection);
int Result = Action.ExecuteNonQuery();
if (Result > 0)
{
return(true);
}
else
{
return(false);
}
}