public void DeleteEmployee() { SqlParameter p = new SqlParameter("@EmpId", SqlDbType.Int); p.Value = _EmpId; SqlHelper.ExecuteNonQuery(ClsConnection.GetConnection(), CommandType.StoredProcedure, "Delete_Employee", p); }
public int ShowBookingInfo() { SqlParameter p = new SqlParameter("@VehicleId", SqlDbType.VarChar); p.Value = _VehicleId; DataSet ds = SqlHelper.ExecuteDataset(ClsConnection.GetConnection(), CommandType.StoredProcedure, "DisplayBooking", p); DataRowCollection rec = ds.Tables[0].Rows; if (rec.Count > 0) { _BookingId = Convert.ToInt16(rec[0]["BookingId"]); _DateOfBooked = rec[0]["DateOfBooked"].ToString(); _VehicleId = rec[0]["VehicleId"].ToString(); _UserId = Convert.ToInt16(rec[0]["UserId"]); _TimeOfPeriod = Convert.ToInt16(rec[0]["TimePeriod"]); _BookingAmount = Convert.ToInt32(rec[0]["BookingAmount"]); _AmountPaid = rec[0]["AmountPaid"].ToString(); _BookingStatus = Convert.ToInt16(rec[0]["BookingStatus"]); return(1); } else { return(0); } }
public void InsertUserRegistration() { SqlParameter[] p = new SqlParameter[8]; p[0] = new SqlParameter("@UserName", SqlDbType.VarChar); p[0].Value = _UserName; p[1] = new SqlParameter("@Surname", SqlDbType.VarChar); p[1].Value = _Surname; p[2] = new SqlParameter("@EmailId", SqlDbType.VarChar); p[2].Value = _EmailId; p[3] = new SqlParameter("@MobileNo", SqlDbType.VarChar); p[3].Value = _MobileNo; p[4] = new SqlParameter("@Address", SqlDbType.VarChar); p[4].Value = _Address; p[5] = new SqlParameter("@City", SqlDbType.VarChar); p[5].Value = _City; p[6] = new SqlParameter("@State", SqlDbType.VarChar); p[6].Value = _State; p[7] = new SqlParameter("@ZipCode", SqlDbType.VarChar); p[7].Value = _ZipCode; SqlHelper.ExecuteNonQuery(ClsConnection.GetConnection(), CommandType.StoredProcedure, "Insert_userRegistraion", p); }
public int DisplayTotalAmount(string stat) { int i = 0; i = Convert.ToInt32(SqlHelper.ExecuteScalar(ClsConnection.GetConnection(), CommandType.Text, stat)); return(i); }
public DataSet GetVehicleDetails() { SqlParameter[] p = new SqlParameter[1]; p[0] = new SqlParameter("@VechicleId", VehicleId); p[0].SqlDbType = SqlDbType.VarChar; return(SqlHelper.ExecuteDataset(ClsConnection.GetConnection(), CommandType.StoredProcedure, "spDisplayVehicleById", p)); }
public void DeleteVehicle() { SqlParameter p = new SqlParameter("@VehicleId", SqlDbType.VarChar); p.Value = _VehicleId; SqlHelper.ExecuteNonQuery(ClsConnection.GetConnection(), CommandType.StoredProcedure, "delete_vehicle", p); }
public void InsertEmployee() { SqlParameter[] p = new SqlParameter[9]; p[0] = new SqlParameter("@Ename", SqlDbType.VarChar); p[0].Value = _EmpName; p[1] = new SqlParameter("@Surname", SqlDbType.VarChar); p[1].Value = _Surname; p[2] = new SqlParameter("@Address", SqlDbType.VarChar); p[2].Value = _Address; p[3] = new SqlParameter("@City", SqlDbType.VarChar); p[3].Value = _City; p[4] = new SqlParameter("@State", SqlDbType.VarChar); p[4].Value = _State; p[5] = new SqlParameter("@ZipCode", SqlDbType.Float); p[5].Value = _ZipCode; p[6] = new SqlParameter("@WorkOnVehicle", SqlDbType.Int); p[6].Value = _WorkOnVehicle; p[7] = new SqlParameter("@Salary", SqlDbType.Float); p[7].Value = _Salary; p[8] = new SqlParameter("@JobDesc", SqlDbType.VarChar); p[8].Value = _JobDesc; SqlHelper.ExecuteNonQuery(ClsConnection.GetConnection(), CommandType.StoredProcedure, "Insert_Employee", p); }
public void AcceptBooking() { SqlParameter[] p = new SqlParameter[6]; p[0] = new SqlParameter("@DateBooked", SqlDbType.VarChar); p[0].Value = _DateOfBooked; p[1] = new SqlParameter("@VehicleId", SqlDbType.VarChar); p[1].Value = _VehicleId; p[2] = new SqlParameter("@TimePeriod", SqlDbType.Int); p[2].Value = _TimeOfPeriod; p[3] = new SqlParameter("@AmountPaid", SqlDbType.VarChar); p[3].Value = _AmountPaid; p[4] = new SqlParameter("@BookingStatus", SqlDbType.Int); p[4].Value = _BookingStatus; p[5] = new SqlParameter("@UserId", SqlDbType.Int); p[5].Value = _UserId; SqlHelper.ExecuteNonQuery(ClsConnection.GetConnection(), CommandType.StoredProcedure, "AddBookingInfo", p); }
public DataSet AvaliableVehicleByDate() { SqlParameter[] p = new SqlParameter[1]; p[0] = new SqlParameter("@DateOfBooked", SqlDbType.VarChar); p[0].Value = _DateOfBooked; DataSet ds = SqlHelper.ExecuteDataset(ClsConnection.GetConnection(), CommandType.StoredProcedure, "AvaliableVehicleByDate", p); return(ds); }
public DataSet DisplayCancelBooking() { SqlParameter[] p = new SqlParameter[1]; p[0] = new SqlParameter("@BookingId", SqlDbType.Int); p[0].Value = _BookingId; DataSet ds = SqlHelper.ExecuteDataset(ClsConnection.GetConnection(), CommandType.StoredProcedure, "DisplayCancelBooking", p); return(ds); }
public void InserUser() { SqlParameter [] p = new SqlParameter [2]; p[0] = new SqlParameter("@username", SqlDbType.VarChar); p[0].Value = _UserName; p[1] = new SqlParameter("@password", SqlDbType.VarChar); p[1].Value = _PassWord; SqlHelper.ExecuteNonQuery(ClsConnection.GetConnection(), CommandType.StoredProcedure, "Insert_EmpUsers", p); }
public DataSet MupleSearchDisplay() { SqlParameter[] p = new SqlParameter[2]; p[0] = new SqlParameter("@VehicleId", SqlDbType.VarChar); p[0].Value = _VehicleId; p[1] = new SqlParameter("@DateOfBooked", SqlDbType.VarChar); p[1].Value = _DateOfBooked; DataSet ds = SqlHelper.ExecuteDataset(ClsConnection.GetConnection(), CommandType.StoredProcedure, "SpMultipleSearch", p); return(ds); }
public bool CheckAvalibility(string stat) { SqlDataReader dr = SqlHelper.ExecuteReader(ClsConnection.GetConnection(), CommandType.Text, stat); dr.Read(); if (dr.HasRows) { return(true); } else { return(false); } }
public void DisplayPackage() { SqlParameter[] p = new SqlParameter[1]; p[0] = new SqlParameter("@PackageId", SqlDbType.Int); p[0].Value = _PackageId; DataSet ds = SqlHelper.ExecuteDataset(ClsConnection.GetConnection(), CommandType.StoredProcedure, "DiplayAvaliabePackage", p); DataRowCollection rec = ds.Tables[0].Rows; if (rec.Count > 0) { _Details = rec[0]["Details"].ToString(); _NoOfDays = Convert.ToInt32(rec[0]["NoOfDays"]); _Price = Convert.ToInt32(rec[0]["Price"]); } }
public int CancelBooking() { SqlParameter[] p = new SqlParameter[3]; p[0] = new SqlParameter("@BookingId", SqlDbType.Int); p[0].Value = _BookingId; p[1] = new SqlParameter("@DateOfBooked", SqlDbType.VarChar); p[1].Value = _DateOfBooked; p[2] = new SqlParameter("@str", SqlDbType.Int); p[2].Direction = ParameterDirection.Output; SqlHelper.ExecuteScalar(ClsConnection.GetConnection(), CommandType.StoredProcedure, "CancelBooking", p); //SqlHelper.ExecuteNonQuery(ClsConnection.GetConnection(), CommandType.StoredProcedure, "CancelBooking", p); return((int)p[2].Value); }
public void DisplyVehicleInfo() { SqlParameter p = new SqlParameter("@VehicleId", SqlDbType.VarChar); p.Value = _VehicleId; DataSet ds = SqlHelper.ExecuteDataset(ClsConnection.GetConnection(), CommandType.StoredProcedure, "DisplayVehicleAvaliability", p); DataRowCollection rec = ds.Tables[0].Rows; if (rec.Count > 0) { _Description = rec[0]["Description"].ToString(); _Model = rec[0]["Model"].ToString(); _Make = rec[0]["Make"].ToString(); _VehicleType = Convert.ToInt32(rec[0]["VehicleType"]); _RatePerDay = Convert.ToInt32(rec[0]["RatePerDay"]); //_BookingStatus = Convert.ToInt32(rec[0]["BookingStatus"]); } }
public void InsertUserLogn() { SqlParameter[] p = new SqlParameter[4]; p[0] = new SqlParameter("@username", SqlDbType.VarChar); p[0].Value = _UserName; p[1] = new SqlParameter("@password", SqlDbType.VarChar); p[1].Value = _PassWord; p[2] = new SqlParameter("@HintQuestion", SqlDbType.VarChar); p[2].Value = _HintQuestion; p[3] = new SqlParameter("@Answer", SqlDbType.VarChar); p[3].Value = _Answer; SqlHelper.ExecuteNonQuery(ClsConnection.GetConnection(), CommandType.StoredProcedure, "Insert_LoginUsers", p); }
public void BookPackage() { SqlParameter[] p = new SqlParameter[4]; p[0] = new SqlParameter("@PackageId", SqlDbType.Int); p[0].Value = _PackageId; p[1] = new SqlParameter("@VehicleId", SqlDbType.VarChar); p[1].Value = _VehicleId; p[2] = new SqlParameter("@UserId", SqlDbType.VarChar); p[2].Value = _UserId; p[3] = new SqlParameter("@DateOfBook", SqlDbType.VarChar); p[3].Value = _DateOfBook; SqlHelper.ExecuteNonQuery(ClsConnection.GetConnection(), CommandType.StoredProcedure, "BookPackage", p); }
public bool ValiDateUser() { SqlParameter[] p = new SqlParameter[2]; p[0] = new SqlParameter("@username", SqlDbType.VarChar); p[0].Value = _UserName; p[1] = new SqlParameter("@password", SqlDbType.VarChar); p[1].Value = _PassWord; SqlDataReader dr; dr = SqlHelper.ExecuteReader(ClsConnection.GetConnection(), CommandType.StoredProcedure, "Validate_LoginUsers", p); dr.Read(); if (dr.HasRows) { return(true); } else { return(false); } }
public void UpdateVehicle() { SqlParameter[] p = new SqlParameter[6]; p[0] = new SqlParameter("@VehicleId", SqlDbType.VarChar); p[0].Value = _VehicleId; p[1] = new SqlParameter("@Description", SqlDbType.VarChar); p[1].Value = _Description; p[2] = new SqlParameter("@Model", SqlDbType.VarChar); p[2].Value = _Model; p[3] = new SqlParameter("@Make", SqlDbType.VarChar); p[3].Value = _Make; p[4] = new SqlParameter("@vehicletype", SqlDbType.Int); p[4].Value = _VehicleType; p[5] = new SqlParameter("@RatePerDay", SqlDbType.Float); p[5].Value = _RatePerDay; SqlHelper.ExecuteNonQuery(ClsConnection.GetConnection(), CommandType.StoredProcedure, "update_vehicle", p); }
public DataSet GetVehicleId() { string SqlStat = "Select vehicleId from tblVehicle"; return(SqlHelper.ExecuteDataset(ClsConnection.GetConnection(), CommandType.Text, SqlStat)); }
public void UpdateBookingInfo(string stat) { SqlHelper.ExecuteNonQuery(ClsConnection.GetConnection(), CommandType.Text, stat); }
public DataSet GetUserId(string stat) { DataSet ds = SqlHelper.ExecuteDataset(ClsConnection.GetConnection(), CommandType.Text, stat); return(ds); }
public DataSet DisplayConformBookings() { DataSet ds = SqlHelper.ExecuteDataset(ClsConnection.GetConnection(), CommandType.StoredProcedure, "AdminBookingConformDiplay"); return(ds); }
public DataSet DisplayBookingInfo(string stat) { DataSet ds = SqlHelper.ExecuteDataset(ClsConnection.GetConnection(), CommandType.Text, stat); return(ds); }
public DataSet DisplyEmployee(string Stat) { DataSet ds = SqlHelper.ExecuteDataset(ClsConnection.GetConnection(), CommandType.Text, Stat); return(ds); }
public DataSet DisplayBookingReport() { return(SqlHelper.ExecuteDataset(ClsConnection.GetConnection(), CommandType.StoredProcedure, "spDisplayBookingInfo", null)); }
public DataSet DisplayVehicleReport() { string SqlStat = "select * from tblVehicle"; return(SqlHelper.ExecuteDataset(ClsConnection.GetConnection(), CommandType.Text, SqlStat)); }