Girfa : Student Help

Free Result Management System in CodeIgniter (CI) with Online Verification – Download Source Code

2026-04-14T21:24:00.000-07:00

Free Result Management System for Schools, Colleges & Institutes (CodeIgniter 4.5.0)

Are you looking for a free Result Management System for your school, college, or coaching institute? This powerful and easy-to-use Student Result Management System, built using CodeIgniter 4.5.0, helps you easily create, manage, print, and verify student results online.

This system is already live and successfully used by multiple institutions, making it stable, reliable, and tested for real-world use. It is suitable for schools, colleges, coaching centers, and training institutes of any size.

Key Features

Complete student record management
Automatic result generation
Mark sheet and report card printing
Secure online result verification system
User-friendly admin dashboard
Fully responsive and fast performance

Why Choose This System?

100% Free Source Code
Easy installation and customization
Suitable for academic and final year projects
Fully tested and bug-free system
Complete documentation included
Customization support available at minimal cost

Whether you want to manage a small institute or handle hundreds of students, this Result Management System is a scalable, secure, and future-ready solution.

Download the Free Result Management System now and simplify your result management process.

Download Source Code

Download from Github

Complete Blog System in CodeIgniter 4.5.0 with Source Code (Free Download)

2026-02-09T20:31:00.000-08:00

Are you looking for a powerful and ready-to-use blog system built with CodeIgniter 4.5.0? I have developed a complete, production-ready blog web application that includes all essential blogging features with optimized performance and smart image handling.

This project is designed for developers, students, and learners who want to understand real-world blog development using CodeIgniter or build their own blogging platform quickly.

⭐ Key Features

✅ Create, edit, and delete blog posts
✅ Upload blog images stored on the server (not in database)
✅ Automatic image deletion when blog post is removed
✅ Fast image loading and optimized performance
✅ Automatic image resizing for better speed
✅ Clean and structured CodeIgniter 4.5.0 code
✅ Fully functional blog management system
✅ SEO-friendly blog structure
✅ Lightweight and high performance

This project follows best development practices with efficient database handling, optimized image processing, and clean architecture, making it ideal for learning and production use.

Download the complete source code below and start building your own professional blog system today.

Screen Shot

#CodeIgniter #CodeIgniter4 #PHPProject #FreeSourceCode #BlogSystem #WebDevelopment #OpenSource #CodeIgniterTutorial #PHPBlog #DeveloperTools

Download from Github

Download Source Code

Next Topic

Responsive Image Slider | HTML, CSS, Js

2025-10-03T00:54:00.000-07:00

Looking for a simple and responsive image slider for your website? Here you can download a free image slider made with pure HTML, CSS, and JavaScript. It is lightweight, fast-loading, and fully mobile-friendly, making it perfect for blogs, portfolios, and business websites. This slider supports smooth transitions, modern design, and can be easily customized to match your theme. No heavy libraries required—just copy, paste, and integrate into your project!

HTML

CSS

        .slides {
  display: flex;
  transition: transform 0.5s ease-in-out;
  width: 100%;
  }

     .slides img {
  width: 100%;
  flex-shrink: 0;
  }

/* Navigation buttons */

.prev, .next {

            position: absolute;
  top: 50%;
  transform: translateY(-50%);
  background: rgba(0, 0, 0, 0.5);
  color: #fff;
  padding: 10px;
  cursor: pointer;
  border: none;
  font-size: 18px;
  z-index: 10;
  }

        .prev {
  left: 10px;
  }

        .next {
  right: 10px;
      }

/* Responsive */

@media (max-width: 768px) {

            .prev, .next {
  font-size: 14px;
  padding: 8px;
  }

}

</style>

JS

        const slides = document.querySelector('.slides');
  const slideImages = document.querySelectorAll('.slides img');
  const prevBtn = document.querySelector('.prev');
  const nextBtn = document.querySelector('.next');
  let counter = 0;
  const size = slideImages[0].clientWidth;

function showSlide(index) {

if (index >= slideImages.length) counter = 0;
if (index < 0) counter = slideImages.length - 1;
slides.style.transform = 'translateX(' + (-counter * 100) + '%)';

}

nextBtn.addEventListener('click', () => {

counter++;
showSlide(counter);

});

prevBtn.addEventListener('click', () => {

counter--;
showSlide(counter);

});

// Auto slide

setInterval(() => {

counter++;
showSlide(counter);

}, 4000);

</script>

Next Template
Download Source Code

E‑Learning Platform Project (ASP.NET MVC + SQL Server) – Sell Webinars, Video & Audio Lectures Download Free

2025-06-19T21:37:00.000-07:00

🎓 Free Download: ASP.NET MVC5 E-Commerce Project with Full Source Code + 400-Page Documentation

Are you a Computer Science or IT student looking for a complete academic project to submit for your BCA, MCA, BSc, MSc, B.Tech, O Level, A Level courses? You're in the right place!

I'm offering a fully functional E-Commerce Web Application developed using ASP.NET MVC5 (C#) and SQL Server as the backend — absolutely FREE for educational purposes.

💡 Project Overview

This project is specially designed to sell educational content like:

✅ Online Webinars
✅ Offline Audio Lectures
✅ Offline Video Lectures

It includes all core functionalities expected from a professional e-commerce platform.

🧩 Features

👨‍🏫 Product Categories (Webinars, Audio, Video)
🛒 Add to Cart / Checkout
💳 Order Processing & Payment (dummy gateway for academic purpose)
👤 User Registration & Login
📦 Admin Dashboard (Manage products, orders, users)
🔎 Search and Filter Products
📁 Downloadable Content (after purchase)
📈 Order History / Tracking
✉ Contact & Support Page
📈 Payment gateway integration ( Paypal, CC Avenue, Stripe, Razorpay)

🔧 Tech Stack

Frontend: ASP.NET MVC5 (Razor View Engine), HTML, CSS, Bootstrap,jquery
Backend: C# (.NET Framework)
Database: SQL Server
IDE: Visual Studio 2019+

📚 Documentation

Need help with project submission? No problem!

A 400 + pages detailed documentation is included, covering:

📌 Project Abstract
📌 SDLC Process
📌 ER Diagrams & Flowcharts
📌 Code Descriptions
📌 Testing & Validation
📌 User Manuals
📌 Future Enhancements

Screen Shot

Next Project

Dairy Management System – A Mini Project for Computer Science Students (VB.NET + SQL Server)

2025-05-29T19:55:00.000-07:00

Are you a computer science student looking for a practical and impactful mini project? The Dairy Management System, developed using VB.NET and SQL Server, is a perfect project that blends real-world utility with essential programming skills. Designed specifically to meet the basic operational needs of a dairy business, this project helps in managing day-to-day activities like customer records, product inventory, sales tracking, invoicing, and more.

With a user-friendly interface and appealing graphic design, the application is intuitive enough to be used even by non-technical users, making it highly applicable in real business environments. The system also includes reporting features to support data-driven business decisions, adding significant value for small and medium dairy firms.

This mini project not only helps students understand core concepts of database management, UI/UX design, and CRUD operations, but also gives them hands-on experience in building software that solves real problems. Whether you're presenting it for your academic submission or as a portfolio project, the Dairy Management System is a solid choice to showcase your development skills.

Silent Features

Dairy Item Entry
Price Master
Searching
User Account Management
Reporting

Development Platform

VB.Net
SQL Server (Management Studio 2012)
Visual Studio 2019 (IDE)

Download Source Code

Next Project

Boost Website Sales with a Spin-to-Win Popup Offer Wheel

2025-05-20T20:33:00.000-07:00

Boost Your Website Sales with a Spin-to-Win Offer Popup!

Looking for a fun and effective way to engage your website visitors and increase conversions? Our Spin-to-Win UI is the perfect solution!

This interactive UI element features a rotating spin wheel that activates with a simple button click. When the wheel stops, it automatically selects a discount or special offer—creating an exciting, game-like experience for users.

What makes it even better? The entire spin interface appears in a popup modal, making it super easy to integrate into any website—no need to redesign your layout or page structure.

By adding a little surprise and delight, this tool helps attract customer attention, encourage engagement, and ultimately increase your revenue. Turn casual visitors into loyal buyers with a spin!

<!DOCTYPE html>

<head>

<title>Bootstrap Example</title>

$(document).ready(function () {

$('#myModal').modal('show');

});

</script>

</head>

<body>

<h2>Modal Example</h2>

<h4 class="modal-title">Modal Header</h4>

</div>

<style>

#spin-popup .selector {

width: 0;

height: 0;

border-left: 20px solid transparent;

border-right: 20px solid transparent;

border-bottom: 30px solid red;

position: absolute;

left: 50%;

transform: translateX(-50%);

top: 5px;

z-index: 2;

}

#spin-popup .canvas-container {

position: relative;

display: inline-block;

}

#spin-popup canvas {

margin-top: 20px;

background-color: transparent;

}

#spin-popup #spinBtn {

margin-top: 20px;

padding: 12px 25px;

font-size: 18px;

font-weight: bold;

background-color: #fff;

border: none;

border-radius: 10px;

color: #00B7D5;

cursor: pointer;

box-shadow: 0 4px 6px rgba(0,0,0,0.2);

}

#spin-popup #result {

margin-top: 20px;

font-size: 20px;

color: #333;

}

</style>

</div>

<br />

(function () {

const canvas = document.getElementById('popup-wheel');

const ctx = canvas.getContext('2d');

const segments = ['5%', '10%', '15%', '20%', '8%', '25%', '12%', '18%'];

const colors = ['#FEC007', '#00B7D5'];

const numSegments = segments.length;

const segAngle = 2 * Math.PI / numSegments;

let angle = 0;

let currentRotation = 0;

let spinning = false;

function drawWheel() {

const radius = canvas.width / 2;

ctx.clearRect(0, 0, canvas.width, canvas.height);

for (let i = 0; i < numSegments; i++) {

const start = angle + i * segAngle;

const end = start + segAngle;

ctx.beginPath();

ctx.moveTo(radius, radius);

ctx.arc(radius, radius, radius, start, end);

ctx.fillStyle = colors[i % 2];

ctx.fill();

ctx.strokeStyle = '#fff';

ctx.lineWidth = 2;

ctx.stroke();

ctx.save();

ctx.translate(radius, radius);

ctx.rotate(start + segAngle / 2);

ctx.textAlign = 'right';

ctx.fillStyle = '#fff';

ctx.font = 'bold 14px Arial';

ctx.fillText(segments[i] + ' OFF', radius - 10, 10);

ctx.restore();

}

ctx.beginPath();

ctx.arc(radius, radius, 40, 0, 2 * Math.PI);

ctx.fillStyle = '#fff';

ctx.fill();

ctx.fillStyle = '#00B7D5';

ctx.font = 'bold 14px Arial';

ctx.textAlign = 'center';

ctx.fillText('PLAY', radius, radius - 5);

ctx.fillText('NOW', radius, radius + 12);

}

function spin() {

if (spinning) return;

spinning = true;

document.getElementById('result').textContent = '';

const spinAngle = 360 * 5 + Math.floor(Math.random() * 360);

const finalAngle = (spinAngle % 360) * Math.PI / 180;

const targetSegment = Math.floor((2 * Math.PI - (finalAngle % (2 * Math.PI))) / segAngle) % numSegments;

let frames = 0;

const totalFrames = 150;

const startRotation = currentRotation;

const targetRotation = startRotation + finalAngle + 2 * Math.PI * 4;

function animate() {

frames++;

const progress = frames / totalFrames;

const eased = easeOutCubic(progress);

currentRotation = startRotation + (targetRotation - startRotation) * eased;

angle = currentRotation;

drawWheel();

if (frames < totalFrames) {

requestAnimationFrame(animate);

} else {

const resultText = segments[targetSegment];

document.getElementById('result').textContent = `🎉 Congratulations Show this Code to counter and get off from bill 🎉`;

spinning = false;

}

animate();

}

function easeOutCubic(t) {

return (--t) * t * t + 1;

}

drawWheel();

document.getElementById('spinBtn').addEventListener('click', spin);

})();

</script>

</div>

<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>

</div>

</body>

</html>

#BoostSales #CustomerEngagement #WebsiteConversion #IncreaseRevenue #MarketingTools #GrowthHack #Gamification #InteractiveUI #UserExperience #SpinToWin #SpinAndWin #WebDesignTips #EcommerceTips #PopupOffers #DiscountWheel #OfferPopup #FlashDeals

Download Source Code

Next Topic

Parameterized Queries Without Stored Procedures In ASP.NET

2025-02-28T05:40:00.000-08:00

Why Use Parameterized Queries?

Parameterized queries help prevent SQL injection, making them a secure way to interact with a database. While stored procedures are highly recommended for their security benefits and performance advantages, they also come with some practical limitations.

Disadvantages of Using Stored Procedures in SQL Server

Requires SQL Server Management Studio (SSMS) – Creating or editing stored procedures requires access to SSMS, which is not always convenient.
IP Binding Restrictions – Many hosting providers require IP whitelisting before allowing access to SQL Server via SSMS. This can be problematic if you are using mobile data, as mobile IP addresses frequently change.
Hosting Provider IP Restrictions – Some hosting providers restrict access to SQL Server by allowing only specific IP ranges, requiring manual approval. This adds extra delays and dependency on hosting support.
Deployment Complexity – Using stored procedures requires uploading both the DLL file (for your application) and the stored procedure in SQL Server. Without stored procedures, you only need to upload the DLL file, simplifying deployment and saving time.

Alternative Approach: Using Parameterized Queries Without Stored Procedures

Instead of relying on SSMS, you can use C# to create and execute parameterized queries directly within your application.

Here’s an example of how to implement a parameterized query in C# without using a stored procedure:

public bool UpdateTestimonial(TestimonialModel data, ref string ErrMsg)

{

String result = "0",sql="";

try

{

using (SqlConnection dbcon = new SqlConnection(ConfigurationManager.ConnectionStrings["dbConnection"].ToString()))

{

sql = "update Testimonial set Name=@nm,Profession=@prof,Star=@star,Message=@msg where id=@ID";

using (SqlCommand cmd = new SqlCommand(sql, dbcon))

{

cmd.Parameters.Add(new SqlParameter("@nm", SqlDbType.VarChar, 25) { Value = data.Name } );

cmd.Parameters.Add(new SqlParameter("@prof", SqlDbType.VarChar, 25) { Value = data.Profession });

cmd.Parameters.Add(new SqlParameter("@star", SqlDbType.Int) { Value = data.Star }) ;

cmd.Parameters.Add(new SqlParameter("@msg", SqlDbType.VarChar, 500) { Value = data.Message });

cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int) { Value = Convert.ToInt32(data.ID) });

if (dbcon.State == ConnectionState.Closed)

dbcon.Open();

cmd.ExecuteNonQuery();

result = "1";

}

catch (Exception ex)

{

ErrMsg = ex.Message;

}

if (result == "1")

return true;

else

return false;

}

Next Topic

Coming Soon page with animated background

2025-02-25T20:54:00.000-08:00

A Coming Soon page is essential when upgrading or launching a new website. Building or updating a website takes time, and working on it live may expose users to incomplete pages, which can leave a negative impression.

A better approach is to display a Coming Soon page while you work on the website in the background. Once your site is ready, simply replace the Coming Soon page with your live website.

I have created a fully responsive Coming Soon page with smooth animations in the background. Just copy the code below, save it as a .html file, and upload it to your server.

Code (HTML, CSS, Javascript)

<!DOCTYPE html>

<head>

<title>Coming Soon</title>

<style>

* {

margin: 0;

padding: 0;

box-sizing: border-box;

}

body {

font-family: 'Arial', sans-serif;

color: #fff;

display: flex;

justify-content: center;

align-items: center;

height: 100vh;

overflow: hidden;

background: linear-gradient(135deg, #1e3c72, #2a5298); /* Fallback background */

}

#particles-js {

position: absolute;

width: 100%;

height: 100%;

background: transparent;

z-index: -1;

}

.container {

text-align: center;

max-width: 90%; /* Adjusted for mobile */

padding: 20px;

background: rgba(130, 10, 15, 0.7); /* Semi-transparent overlay */

border-radius: 10px;

animation: fadeIn 2s ease-in-out;

z-index: 1;

}

h1 {

font-size: 2.5rem; /* Smaller font for mobile */

margin-bottom: 20px;

animation: slideIn 1.5s ease-in-out;

}

p {

font-size: 1rem; /* Smaller font for mobile */

margin-bottom: 30px;

animation: fadeIn 3s ease-in-out;

}

.subscribe-form {

display: flex;

flex-direction: column; /* Stack input and button on mobile */

align-items: center;

animation: slideIn 2s ease-in-out;

}

.subscribe-form input {

padding: 10px;

border: none;

border-radius: 5px;

width: 100%; /* Full width on mobile */

max-width: 300px; /* Limit width on larger screens */

font-size: 1rem;

margin-bottom: 10px; /* Space between input and button */

transition: transform 0.3s ease;

}

.subscribe-form input:focus {

transform: scale(1.05);

outline: none;

}

.subscribe-form button {

padding: 10px 20px;

border: none;

background: #ff6f61;

color: #fff;

border-radius: 5px;

cursor: pointer;

font-size: 1rem;

width: 100%; /* Full width on mobile */

max-width: 300px; /* Limit width on larger screens */

transition: background 0.3s ease, transform 0.3s ease;

}

.subscribe-form button:hover {

background: #ff3b2f;

transform: scale(1.05);

}

.social-links {

margin-top: 20px;

animation: fadeIn 4s ease-in-out;

}

.social-link {

color: #fff;

text-decoration: none;

margin: 0 10px;

font-size: 0.9rem; /* Smaller font for mobile */

transition: color 0.3s ease, transform 0.3s ease;

}

.social-link:hover {

color: #ff6f61;

transform: translateY(-5px);

}

/* Media Queries for Mobile Responsiveness */

@media (max-width: 768px) {

h1 {

font-size: 2rem; /* Smaller font for smaller screens */

}

p {

font-size: 0.9rem; /* Smaller font for smaller screens */

}

.subscribe-form input,

.subscribe-form button {

max-width: 100%; /* Full width on smaller screens */

}

.social-links {

flex-direction: column; /* Stack social links vertically */

}

.social-link {

margin: 5px 0; /* Space between stacked links */

}

@keyframes fadeIn {

from {

opacity: 0;

}

to {

opacity: 1;

}

@keyframes slideIn {

from {

transform: translateY(-50px);

opacity: 0;

}

to {

transform: translateY(0);

opacity: 1;

}

</style>

</head>

<body>

<h1>Coming Soon</h1>

<p>We're building an exciting new platform to transform education. Stay tuned!</p>

<a href="#" class="social-link">Facebook</a>

<a href="#" class="social-link">Twitter</a>

<a href="#" class="social-link">Instagram</a>

</div>

// Particle.js Configuration

particlesJS("particles-js", {

particles: {

number: {

value: 80, // Number of particles

density: {

enable: true,

value_area: 800,

color: {

value: "#ffffff", // Particle color

shape: {

type: "circle", // Particle shape

opacity: {

value: 0.7,

random: true,

anim: {

enable: true,

speed: 1,

opacity_min: 0.1,

sync: false,

size: {

value: 3,

random: true,

anim: {

enable: true,

speed: 2,

size_min: 0.1,

sync: false,

line_linked: {

enable: true,

distance: 150,

color: "#ffffff",

opacity: 0.4,

width: 1,

move: {

enable: true,

speed: 3,

direction: "none",

random: true,

straight: false,

out_mode: "bounce",

bounce: true,

attract: {

enable: true,

rotateX: 600,

rotateY: 1200,

interactivity: {

detect_on: "canvas",

events: {

onhover: {

enable: true,

mode: "bubble",

onclick: {

enable: true,

mode: "push",

resize: true,

modes: {

bubble: {

distance: 200,

size: 6,

duration: 2,

opacity: 0.8,

speed: 3,

push: {

particles_nb: 4,

retina_detect: true,

});

// Handle form submission

document.querySelector('.subscribe-form').addEventListener('submit', function (event) {

event.preventDefault();

const email = this.querySelector('input').value;

alert(`Thank you! We'll notify you at ${email} when we launch.`);

this.querySelector('input').value = ''; // Clear the input field

});

</script>

</body>

</html>

Next Template

Download Source Code

Client Testimonal/ Review UI

2025-02-20T02:14:00.000-08:00

Responsive, Customizable Client Review & Testimonial UI
Enhance your website with a sleek and fully customizable client review and testimonial UI. Designed to seamlessly adapt to any device, ensuring a perfect fit and optimal user experience across desktops, tablets, and smartphones.

Fully Customizable Client Testimonial UI
Responsive design that fits every device, delivering a seamless user experience.

HTML

<p>

"Girfa IT Services transformed our outdated website into a modern, user-friendly platform. Their team understood our vision and delivered a sleek, responsive design that perfectly represents our brand. We’ve received great feedback from our customers and seen an increase in online inquiries. Highly recommend their web development services!"

</p>

<h4>— Sarah Thompson, Marketing Manager at Bright Solutions</h4>

</div>

<p>

Thanks to Girfa IT Services, our online presence has never been stronger! Their digital marketing strategies, including SEO and social media campaigns, have significantly increased our website traffic and lead generation. The team is proactive, creative, and results-driven. We’re thrilled with the outcomes!

</p>

<h4>David Carter, CEO of GreenWave Technologies</h4>

</div>

<p>

Girfa IT Services is our go-to partner for both web development and digital marketing. They built a stunning, responsive website for us and continue to boost our online visibility through targeted digital marketing. Their professionalism, expertise, and dedication have helped us grow our business. We couldn’t be happier with their services!

</p>

<h4>Emma Lewis, Founder of FreshBites Café</h4>

</div>

</div>

</section>

CSS

.g-review-slider {

position: relative;

max-width: 100%;

width: 90%; /* Responsive width */

margin: auto;

overflow: hidden;

border: 1px solid #ccc;

padding: 20px;

text-align: center;

}

.g-slides {

display: flex;

transition: transform 0.5s ease-in-out;

}

.g-slide {

min-width: 100%;

box-sizing: border-box;

padding: 0 20px; /* Add padding for better spacing on small screens */

}

.g-slide img {

border-radius:50%;

}

.g-review-slider button {

position: absolute;

top: 50%;

transform: translateY(-50%);

background-color: rgba(0, 0, 0, 0.5);

color: white;

border: none;

padding: 10px;

cursor: pointer;

z-index: 10; /* Ensure buttons are above slides */

}

.g-review-slider button.prev {

left: 10px;

}

.g-review-slider button.next {

right: 10px;

}

/* Responsive adjustments */

@media (max-width: 600px) {

.g-review-slider {

padding: 10px;

}

.g-review-slider button {

padding: 8px;

font-size: 14px;

}

Javascript

let slideIndex = 0;

let autoSlideInterval;

// Function to move slides

function gmoveSlide(n) {

const slides = document.querySelector('.g-slides');

const totalSlides = document.querySelectorAll('.g-slide').length;

slideIndex += n;

if (slideIndex >= totalSlides) {

slideIndex = 0;

} else if (slideIndex < 0) {

slideIndex = totalSlides - 1;

}

slides.style.transform = `translateX(${-slideIndex * 100}%)`;

}

// Function to start auto-sliding

function startAutoSlide() {

autoSlideInterval = setInterval(() => {

gmoveSlide(1);

}, 5000); // Change slide every 5 seconds

}

// Function to stop auto-sliding (optional, for user interaction)

function stopAutoSlide() {

clearInterval(autoSlideInterval);

}

// Start auto-slide when the page loads

window.onload = () => {

startAutoSlide();

};

// Optional: Stop auto-slide when user interacts with the slider

document.querySelector('.g-review-slider').addEventListener('mouseenter', stopAutoSlide);

document.querySelector('.g-review-slider').addEventListener('mouseleave', startAutoSlide);

Download Source Code

Next Template

Summernote Image Upload at server in ASP.NET MVC5 using C#

2024-12-24T21:38:00.000-08:00

Summernote is an online WYSIWYG (What You See Is What You Get) editor that is lightweight and easy to integrate into any platform. Its tools resemble those of MS Word, making it user-friendly and intuitive. By default, Summernote stores images as base64 strings in the database. However, this approach is not ideal from a bandwidth and performance perspective.

A better solution is to store images on a server and save only the file paths in the editor. Summernote also supports adding images via URL, providing additional flexibility.

In this post, I share my custom solution for saving images to a server and integrating them into the editor. Although the example is based on an ASP.NET MVC5 C# web application, the approach is platform-independent and uses jQuery AJAX to handle image uploads.

HTML for Editor

@model ShriAdityaNarayanSingh.Models.MenuDataModel
@{
Layout = null;
}
<HTML>
<head>

<title>Management Message Update</title>
<link href="~/AppCss/gcss.css" rel="stylesheet" />

</head>

<body>

<li><a href="/admin/Index">Dashboard</a></li>

<li><a href="/admin/MenuIndex">Menu Data Index</a></li>

<li> Update Page </li>

</ol>

<h3>@ViewBag.SubMenuName</h3><hr />

</div><br />

</div>

<h4 class="modal-title">Upload Blog Image </h4>

</div>

<form>

<span>Browse</span>

</div><br /><br />

</form>

</div>

<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>

</div>

<span id="lblMsgCopy" style="color:green;display:none;text-align:center;padding:2px;background-color:#edffd8;margin-bottom:6px">Path Copied</span><br />

</div>

</div>

$(document).ready(function () {

$('#summernote').summernote(

);

$('#summernote').summernote('code', $("#hidContent").val());

GetMenuPageImage($("#MenuPageid").val());

});

</script>

function ShowM() {

$('#myModal').modal('show');

document.getElementById('blah').src = '';

document.getElementById('blah').style.width = '';

document.getElementById('blah').style.height = '';

}

function ValidateAbout() {

Flag = true;

if ($('#summernote').summernote('code') == "") {

alert("Please enter something ");

Flag = false;

}

function SaveDescription() {

ValidateAbout();

if (Flag) {

var Userobj =
{
ID: getQueryStringValue("rid"),
PageData: $('#summernote').summernote('code')
}

                $.ajax({
url: '/admin/MenuAddTextUpdate/',
dataType: "json",
type: "POST",
contentType: 'application/json; charset=utf-8',
  data: JSON.stringify(Userobj),
success: function (data) {
  if (data.sMessage == "1") {
alert("Updated Successfully");
window.location = "/Admin/MenuAddText?rid=" + getQueryStringValue("rid");
                  }

                        else
  alert(data.sMessage);
  }

});

}

</script>
@{

Random ob = new Random();
int ran = ob.Next();

}
<script src="~/AppJs/menudata.js?v=@ran"></script>
</body>
</html>

CSS (gcss.css)

.note-group-select-from-files {

display: none;

}

.g-heading {

border-bottom: solid 1px #d0cdcd;

display: block;

margin: 5px;

font-size: large;

}

.fileUpload {

position: relative;

overflow: hidden;

margin-top: 0px;

}

.fileUpload input.upload {

position: absolute;

top: 0;

right: 0;

margin: 0;

padding: 0;

font-size: 20px;

cursor: pointer;

opacity: 0;

filter: alpha(opacity=0);

}

.note-insert {

display: none

}

.divImgContainer {

display: grid;

grid-template-columns: auto auto auto;

/*grid-template-rows: 80px 150px;*/

grid-gap: 10px;

padding: 10px;

height: auto;

width: 300px;

position: relative;

}

.divImgContainer div {

text-align: center;

padding: 0px 0;

font-size: 10px;

}

.divImgContainer img {

width: 110px;

height: 70px;

}

.button {

display: none;

position: absolute;

color: white;

left: 50px;

top: 40px;

text-align: center;

font-size: small;

transition: opacity .35s ease;

}

.divImgContainer div:hover .button {

display: block;

padding: 5px;

}

Java Script (menudata.js)

function UploadMenuPageImage() {

//create blog other img rec

if (ValidateFile('MenuPageImage'))
{

var name = document.getElementById('MenuPageImage');

var fname = name.files.item(0).name;

var fileExtension = fname.split('.').pop();

CreateMenuPageImageRec(fileExtension);

$('#myModal').modal('hide');

GetMenuPageImage($("#MenuPageid").val());

}

function CreateMenuPageImageRec(ext) {

//create image row in MenuDataImg table and upload image with new autoid

var Userobj =
{

ID: $("#MenuPageid").val(),
Ext: ext

}

$.ajax({

url: '/admin/CreateMenuPageImgRec/',
async: false,
dataType: "json",
type: "POST",
contentType: 'application/json; charset=utf-8',
data: JSON.stringify(Userobj),
success: function (data) {

if (data.sMessage != 0) {

UploadImage('MenuPageImage', (data.sMessage + "." + ext));

            }
  else
  alert(data.sMessage);

}
});

}

function UploadImage(imgid, imgname) {

    if (ValidateFile(imgid)) {
  var data = new FormData();
data.append("filename", $("#" + imgid)[0].files[0]);
  var name = document.getElementById(imgid);
  var fname = name.files.item(0).name;
  var fileExtension = fname.split('.').pop();
  var newname = imgname + "." + fileExtension;

$.ajax({

url: '/admin/UploadMenuPageImg?fnm=' + imgname ,
async: false,
type: "POST",
contentType: false, // Not to set any content header
processData: false, // Not to process data
data: data,
success: function (result) {
if (result == "1") {

alert("Image Uploaded Successfully");
var imgNode = document.createElement('img');
imgNode.src = '/Upload/menupageimg/' + imgname;
$('#summernote').summernote('insertNode', imgNode);

}

error: function (abc) {

alert(abc.statusText);

}

});

}

function GetMenuPageImage(pageid) {

$.ajax({

url: '/admin/GetMenuPageImage/',
dataType: "json",
type: "GET",
contentType: 'application/json; charset=utf-8',
data: { pid: pageid },
success: function (data) {

if (data != '') {

$("#divImgContainer").empty();
var html = "";
$.each(data, function (i, item) {

html += "<div id='imgcon'>";
html += " <img src='/Upload/menupageimg/" + item.ID + "." + item.Ext + "' id='img" + item.ID + "' onclick=\"CopyPath(" + item.ID + ",'" + item.Ext + "')\">"; html += "</div>";

})
$("#divImgContainer").append(html);

}

});

}

function ValidateFile(imgid) {

var Flag = true;

try {

if ((document.getElementById(imgid).files[0].size / 1024) > 500) {

alert("Sorry Maximum 500 KB file size is allowed");
Flag = false;

}
else
Flag = true;

}

catch (exception) {

alert('Please select a image file');
Flag = false;

}

return Flag;

}

function CopyPath(id, ext) {

//copy the current img path and put it in clipboard and select image id for delete

$("#hidImgID").val(id);

$("#hidImgName").val(ext);

navigator.clipboard.writeText("https://localhost:44336/Upload/menupageimg/" + id + "." + ext);

$("#imgcon img").css("border", "none");

$('#img' + id).css({ "border": "solid 2px red", "padding": "2px" });

$("#lblMsgCopy").show();

//$("#lblMsgCopy").hide(3000);

$('#lblMsgCopy').delay(2000).hide(0);

var imgNode = document.createElement('img');

imgNode.src = '/Upload/menupageimg/' + id + "." + ext;

$('#summernote').summernote('insertNode', imgNode);

}

function DelImg() {

if ($("#hidImgID").val() == "" || $("#hidImgName").val() == "")

alert('Please select an image for delete');

else {

var Userobj =
{

ID: $("#hidImgID").val(),
Ext: $("#hidImgName").val()

}

$.ajax({

            url: '/admin/DelMenuPageImg/',
async: false,
dataType: "json",
type: "POST",
contentType: 'application/json; charset=utf-8',
data: JSON.stringify(Userobj),
success:
  function (data) {
  if (data.sMessage == 1) {

$("#hidImgID").val("");
$("#hidImgName").val("");
GetMenuPageImage($("#MenuPageid").val());

}

else
alert('Some error occured del line 166');

}

});

}

function readURL(input) {

if (input.files && input.files[0]) {

var reader = new FileReader();

reader.onload = function (e) {

$('#blah')

                .attr('src', e.target.result)
  .width(250)
  .height(150);

};

reader.readAsDataURL(input.files[0]);

}

Controller

public ActionResult MenuAddText(string rid)
{

            SelectRepository ob = new SelectRepository();
MenuDataModel data = new MenuDataModel();
data = ob.GetMenuDataPDFByID(" where id=" + Convert.ToInt32(rid));
  //sub sql is used becoz submenu id saved in menudata data and id is coming from menudata table
ViewBag.SubMenuName = ob.GetSingleValue("select SubMenuName from MenuMaster where id=(select MID from MenuData where id=" + Convert.ToInt32(rid) + ")");
  return View(data);

}

public JsonResult MenuAddTextUpdate(MenuDataModel data)
{

            string ErrMsg = "";
UpdateRepository obj = new UpdateRepository();
  if (obj.UpdateMenuPageDataText(data, ref ErrMsg) == true)
  {
  return Json(new { sMessage = "1", JsonRequestBehavior.AllowGet });
  }
  else
  {
  return Json(new { sMessage = ErrMsg, JsonRequestBehavior.AllowGet });

}

public JsonResult CreateMenuPageImgRec(MenuDataModel data)
{

            string ErrMsg = "", imgname = "";
InsertRepository obj = new InsertRepository();
if (obj.AddMenuDataImgRec(data, ref ErrMsg, ref imgname) == true)
  {
  return Json(new { sMessage = imgname, JsonRequestBehavior.AllowGet });
  }
  else
  {
  return Json(new { sMessage = ErrMsg, JsonRequestBehavior.AllowGet });
  }

}

[HttpPost]
public JsonResult UploadMenuPageImg(string fnm)
{
  if (Request.Files.Count > 0)
  {
  try
  {
  // Get all files from Request object
  HttpFileCollectionBase files = Request.Files;
  for (int i = 0; i <= files.Count - 1; i++)
  {
    HttpPostedFileBase file = files[I];
  string fname = files[0].FileName;
  string fileExtension = Path.GetExtension(fname);
  fname = fnm;
  // Get the complete folder path and store the file inside it.
fname = Path.Combine(Server.MapPath("~/Upload/menupageimg/"), fname);
WebImage img = new WebImage(file.InputStream);
img.Resize(Convert.ToInt16(800), Convert.ToInt16(500), false, false);
  img.Save(fname);

                    }
  // Returns message that successfully uploaded
  var msg = "1";
  return Json(msg, JsonRequestBehavior.AllowGet);
  }
  catch (Exception ex)
  {
  return Json("Error occurred. Error details: " + ex.Message);
  }

            }
  else
  {

return Json("No files selected.");

}
}

public JsonResult GetMenuPageImage(string pid)
{
List<MenuDataModel> data = new List<MenuDataModel>();
SelectRepository ob = new SelectRepository();
data = ob.GetMenuPageImage(pid);
return Json(data, JsonRequestBehavior.AllowGet);
}

public JsonResult DelMenuPageImg(MenuDataModel data)
{

            UpdateRepository ob = new UpdateRepository();
  string sql = "", ErrMsg = "";
sql = "delete from MenuDataImg where id=" + Convert.ToInt32(data.ID);
  string file = Server.MapPath("~/Upload/menupageimg/" + data.ID + "." + data.Ext);
  if (ob.UpdateCommon(sql, ref ErrMsg))
  {
  if (System.IO.File.Exists(file))
  {
  System.IO.File.Delete(file);
  }
  return Json(new { sMessage = "1", JsonRequestBehavior.AllowGet });
  }
  else
  return Json(new { sMessage = "0", JsonRequestBehavior.AllowGet });
}

Repository

public bool UpdateMenuPageDataText(MenuDataModel ob, ref string ErrMsg)

{

            String result = "";
  try
  {
  using (SqlConnection dbcon = new SqlConnection(ConfigurationManager.ConnectionStrings["dbConnection"].ToString()))
  {
  using (SqlCommand cmd = new SqlCommand("[dbo].[UpdateMenuPageDataText]", dbcon))
  {
  cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@rid", Convert.ToInt32(ob.ID));
cmd.Parameters.AddWithValue("@PageData", ob.PageData);
  if (dbcon.State == ConnectionState.Closed)
  dbcon.Open();
  cmd.ExecuteNonQuery();
result = "1";

}

            }
  catch (Exception ex)
  {
  ErrMsg = ex.Message;
  }
  if (result == "1")
  return true;
  else
  return false;

}

public bool AddMenuDataImgRec(MenuDataModel ob, ref string ErrMsg, ref string imgname)
{

            String result = "";
  try
{
  using (SqlConnection dbcon = new SqlConnection(ConfigurationManager.ConnectionStrings["dbConnection"].ToString()))
{
  using (SqlCommand cmd = new SqlCommand("[dbo].[AddPageDataImage]", dbcon))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pid", Convert.ToInt32(ob.ID));
cmd.Parameters.AddWithValue("@ext", ob.Ext);
cmd.Parameters.Add("@imgid", SqlDbType.Int);
cmd.Parameters["@imgid"].Direction = ParameterDirection.Output;
  if (dbcon.State == ConnectionState.Closed)
dbcon.Open();
cmd.ExecuteNonQuery();
imgname = Convert.ToString(cmd.Parameters["@imgid"].Value);
result = "1";

}

            }
  catch (Exception ex)
{
ErrMsg = ex.Message;
}
  if (result == "1")
  return true;
  else
  return false;

}

public List<MenuDataModel> GetMenuPageImage(string bid)
{
List<MenuDataModel> Record = new List<MenuDataModel>();
  string sql = "select ID, ImgName from MenuDataImg where PageID=" + bid;
  try
  {
  using (SqlConnection dbcon = new
qlConnection(ConfigurationManager.ConnectionStrings["dbConnection"].ToString()))

                {
  using (SqlCommand cmd = new SqlCommand(sql, dbcon))
  {
  if (dbcon.State == ConnectionState.Closed)
  dbcon.Open();
  using (SqlDataReader drOb = cmd.ExecuteReader())
  {
  if (drOb.HasRows)
  {
  while (drOb.Read())
  {
MenuDataModel data = new MenuDataModel();
data.ID = drOb.IsDBNull(0) ? " " : Convert.ToString(drOb["ID"]);
data.Ext = Convert.ToString(drOb["ImgName"]);
  Record.Add(data);

}

            }
  catch (Exception ex)
  {

}
return Record;

}

public bool UpdateCommon(string sql, ref string ErrMsg)
{

}

catch (Exception ex)

{

ErrMsg = ex.ToString();

}

if (result == "1")

return true;

else

return false;

}

Database

Table Structure

MenuMaster

Dynamic Menu Record

MenuData

Store many HTML Code

MenuDatImg

store images of menu pages

Store Procedure

USE [tp_adityanarayan]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[UpdateMenuPageDataText]
(
@rid int,@PageData nvarchar(MAX)

)
as
BEGIN
SET NOCOUNT ON
update MenuData set PageData=@PageData where id=@rid

END

USE [tp_adityanarayan]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[AddPageDataImage]
(
@pid int output,
@ext varchar(5),
  @imgid int output
  )
  as
BEGIN
  SET NOCOUNT ON
  declare @maxid int=1
if(select count(*) from MenuDataImg)>0
select @maxid=max(ID)+1 from MenuDataImg
insert into MenuDataImg (ID,PageID, ImgName) values(@maxid,@pid,@ext)
select @imgid=@maxid

END

Next Topic

OPD Management | VB.Net Windows Desktop Application

2024-12-03T21:09:00.001-08:00

OPD Management is a desktop application developed in VB.Net using Visual Studio 2019. This fully integrated software is designed for hospitals to manage patient records and treatment history efficiently. It allows users to store detailed patient information, including treatment history, test reports, and remarks from doctors and staff.

The application enables doctors to quickly access a patient’s complete treatment history, including test results and professional notes, all at the click of a button. This streamlined approach enhances understanding and decision-making, improving the overall quality of care.

Features

Patient Registration.
Patient treatment history record.
Doctor prescription record.
Patient test report record (jpg and written format)
Staff and doctor remarks saved on every OPD visit
Get the patient entire treatment in one click with details reports in chronological order.
Track Earning collection staffwise
Get details by datewise patient registration, earning , refer patient and many more.
Detail customized report with one click share with WhatsApp.

Development Technology

Development language : VB
IDE : Visual Studio 2019
Backend : MS Access

Who can use this project

This software is ideal for doctors managing their personal OPD. It addresses all the essential needs, including OPD management, patient record-keeping, and staff work tracking.

Students pursuing MCA, BCA, BSc, PGDCA, or other computer science courses can also use this project for their main coursework. The software is available with complete source code and documentation. For more information, please contact rajkumar9795@gmail.com.

Screen Shot

Splash Screen

MDI

Patient Entry

OPD Entry

OPD Record Entry

Patient History

OPD History Management

Patient Attachment

Patient Record Show

Patient Entry Report

Disease Management

Fund Collection

Project Video

Download Project Source Code

Download from Github

Next Project

Send OTP Using C# MVC5

2024-11-06T21:18:00.001-08:00

This blog post will guide you through implementing OTP verification during user signup using C# in ASP.NET MVC5. I've simplified the steps to make the OTP verification process clear and easy to Implement.

HTML

<form method="post">
  <input type="hidden" name="OTP1" value="@ViewBag.otp" />
  <input type="number" name="OTP2" required autofocus class="gtxt " placeholder="OTP" /><br />
  <p style="text-align:center">
<input type="submit" value="Submit" class="btn btn-info gbtn" />
  <a href="/Home">
  <input type="button" value="Cancel" class="btn btn-danger gbtn" />   </a><br />
<span style="color:red">@ViewBag.Err </span>
</p>
</form>

Action

public ActionResult otp()
{
SelectRepository ob = new SelectRepository();
Random obr = new Random();
int ran = obr.Next();
string otp = ran.ToString().Substring(0, 5);
string phone = "", url = "";
phone = "9999999999";
url = "https://2factor.in/API/V1/enter-your-key/SMS/" + phone + "/" + otp + "/OTP1"; WebRequest request = HttpWebRequest.Create(url);
WebResponse response = request.GetResponse();
StreamReader reader = new StreamReader(response.GetResponseStream());
string urlText = reader.ReadToEnd(); // it takes the response from your url. now you can use as your need
ViewBag.result = urlText; // for your reference output from SMS provider ViewBag.otp = otp; // otp saved for verification
return View();
}

Verifiy OTP

[HttpPost]
public ActionResult otp(LoginModel data)
{
if (Convert.ToInt32(data.OTP1) == Convert.ToInt32(data.OTP2))
{
return RedirectToAction("successurl", "actionname");
}
else
return RedirectToAction("err", "common", new { msg = "Invalid OTP", color = "red" });
}

Next Topic

Razorpay payment gateway intergration C# ASP.Net MVC5

2024-10-22T21:40:00.006-07:00

Streamline your payments with Razorpay integration in ASP.NET MVC5 using C#. This comprehensive guide provides step-by-step instructions and includes well-commented source code.

Key benefits:

Versatile application: The code can be seamlessly integrated into any e-commerce or web application requiring a secure payment gateway.
Real-world example: The accompanying sample code demonstrates a printing house scenario, similar to VistaPrint, where users upload PDFs for printing and utilize Razorpay for secure transactions.

Need help? Don't hesitate to reach out for assistance via email at rajkumar9795@gmail.com.

Screen Shots

Checkout

Razorpay Payment Page

Steps 1 (Signup Razorpay)

Sign up for Razorpay to obtain your public and secret keys for both test and live environments. Use the test keys to simulate real-world payment scenarios. Once testing is complete, simply replace the test keys with the live keys. For detailed assistance with signing up, you can search for "Razorpay signup" on YouTube, where you’ll find numerous tutorial videos. Steps for signing up are not included here to keep this post concise.

Step 2 (Add Keys)

After obtaining the test key from step 1, open the web.config file and add your key in the <appSettings> section. In the given example below, a test key is used. Replace this keys with your actual test key, and once testing is complete, replace it with your live key.

</appSettings>

Step 3 (Razorpay Extension Installation)

Install Razorpay extension from Nuget . The menu as given below

Tools > Nuget Package Manager > Manage Nuget Packages for solution.

Search Razorpay in the Browse search textbox.

Step 4 (Create Order )

HTML & Javascript

Proceed to Pay

</button>

<form action="/order/payment" method="post" name="razorpayForm">
  <input id="razorpay_payment_id" type="hidden" name="razorpay_payment_id" />
  <input id="razorpay_order_id" type="hidden" name="razorpay_order_id" />
  <input id="razorpay_signature" type="hidden" name="razorpay_signature" />
</form>

// Boolean whether to show image inside a white frame. (default: true) options.theme.image_padding= false;
options.handler = function (response) {
document.getElementById('razorpay_payment_id').value = response.razorpay_payment_id; document.getElementById('razorpay_order_id').value = orderId; document.getElementById('razorpay_signature').value = response.razorpay_signature;
document.razorpayForm.submit();
  };
  options.modal = {
ondismiss: function() {
console.log("This code runs when the popup is closed");
  },
  // Boolean indicating whether pressing escape key
  // should close the checkout form. (default: true)
escape: true,
  // Boolean indicating whether clicking translucent blank
// space outside checkout form should close the form. (default: false) backdropclose: false
};
var rzp = new Razorpay(options);
document.getElementById('rzp-button1').onclick = function (e) {
  rzp.open();
e.preventDefault();

}

</script>

Controller

public ActionResult StartPaymentProcess(string amount)
{

var key = ConfigurationManager.AppSettings["RazorPaykey"].ToString();
var secret = ConfigurationManager.AppSettings["RazorPaySecret"].ToString();
RazorpayClient client = new RazorpayClient(key, secret);
Dictionary <string, object> options = new Dictionary<string, object>();
options.Add("amount", Convert.ToDecimal(amount) * 100); // multiply by 100 to accommodate decimal values
options.Add("currency", "INR"); // change curreny INR to $ g for get payment in dollar
Order order = client.Order.Create(options);
ViewBag.orderId = order["id"].ToString();
return View("Payment"); // view to show user final proceed to pay

}

public ActionResult Payment(string razorpay_payment_id, string razorpay_order_id, string razorpay_signature)
{
Dictionary<string, string> attributes = new Dictionary<string, string>();
attributes.Add("razorpay_payment_id", razorpay_payment_id);|
attributes.Add("razorpay_order_id", razorpay_order_id);
attributes.Add("razorpay_signature", razorpay_signature);
  try
  {
  Utils.verifyPaymentSignature(attributes);
  return View("PaymentSuccess");
  }
  catch (Exception ex)
  {
  return View("PaymentFailure");
}
  return View();

}

Step 5 (Success,Failure page)

You can create success or failure page to show appropriate message to user . you can also save/show the ordered. which is coming from Payment view . Check the payment view signature and save the razorpay_order_id in database for future reference.

Next Payment Gateway Integration

Enum C#

2024-08-26T22:05:00.000-07:00

public enum BranchCode
{

Branch1=1,

Branch2,

Branch3

}

Console.Write(((int)BranchCode.Branch2));

Next Example

Fill date in input type date using javascript

2024-06-30T03:22:00.000-07:00

Input type date takes date in format of yyyy-mm-dd. But it will show you as per your local clock setting.

While editing A form we need to fill the date coming from the database into the date picker. You will have to change format yyyy-mm-dd otherwise date will not be show .

My date formate coming from the database is 15-05-1985

var dt = new Date($("#ddob").val().split("/").reverse().join("/"));

var td = dt.getFullYear() + "-";

month = (dt.getMonth() + 1);

if (month < 10)

td += "0" + month;

else

td += month;

td += "-";

day = dt.getDate();

if (day < 10)

td += "0" + day;

else

td += day;

$("#dob").val(td);

Next Topic

Install Let's Encrypt SSL into Godaddy shared Linux hosting

2024-06-27T23:12:00.000-07:00

Let's Encrypt provide free SSL certificate. Mostly Hosting service provider automatically install Let's Encrypt SSL but some hosting provider like Godaddy doesn't support Let's Encrypt by default.

This post will help you to install Let's Encrypt SSL into Godaddy Linux share hosting. Let's Encrypt Provide SSL for 3 months only at a time . You will have to install new certificate after every 3 motnh.

Follow the steps given below or Watch the video for step by step install SSL .

Many website provide Let's Encrypt SSL . I am using two website
1. https://punchsalad.com/
2.https://thepowerhost.in/free-ssl/
Enter Domain name like . example.com,www.example.com
You will get two files upload them by creating .well-known/acme-challenge
Search on google how to show hidden file in Cpanel and show hidden file
Ones files got upload in given folder then click to verify domain.
if every thing is ok then you will get the certificate in next page.
It's time to install certiifcate into cpanel
Search SSL in search box and goto SSL
Upload private key by clicking upload or generate private key. if you have uploaded private key previousely, in case of renew certificate after 3 month. Then delete the previous private key . You can find private key by searching your domain name.
Search again SSL in Capnel and select SSL/TLC and click Generate, View ,Upload, Delete certificate
Delete previous certificate in care of renewal or scroll down copy paste certificate in certificare box created in Starting .
Search SSL again in Cpanel and select SSL/TLS and click the Manage SSL Sites
Scroll down at the end and select you domain in drop down list
After select domain click Autofill by domain button and click Install
This is all for Install certificate . Visit video for live example

Next Topic

Form Control Post C# ASP.Net MVC

2024-04-18T05:57:00.000-07:00

Form Post is a simple process to submit data to the server. C# works the same as other languages like PHP works. Problems arise with the radio button and checkbox. These controls are different from the textbox. So we need different ways to detect user selection. This is post will help you to learn checkbox and radio button selection using form POST.

Radio Button selection detect

HTML

<form method="post" >
<input type="radio" name="SalaryPerson" value="1" checked/> Salary Person
<input type="radio" name="SalaryPerson" value="0" /> Self Empployee
<input type="submit" value="Save" >
</form>

Model

public class RadioModel
{
public string SalaryPerson { get; set; }
}

Access on server

[HttpPost]

public ActionResult ReadRadio(PostRequirementModel data)
{
  string Radio = data.SalaryPerson; ;
  ViewBag.Data = Radio;
  return View();
}

Next Topic

Query String URI in Route in Code codeigniter 4

2024-04-17T09:41:00.000-07:00

You can pass some information using the query string. Query string is very useful for creating dynamic page. As you can see in the image given above, the Query string is a circle of red color. Page content will be changed as per the product ID provided.

Step 1

Goto App>confirg>Routes.php add the Routes rule

$routes->get('product/(:any)', 'Home::product/$1');

In this write product specified the Page URL and (:any) specified, any thing after product/ will be consider query string . Which is get by the Home Controller's product method . $1 denote only one argument will be pass.

Step 2 (Controller code)

  public function product($arg)
    {
        $data['title']='Contact Us';
        $data['arg']=$arg;
        return view('product',$data);
    }

query string will be save in $arg variable and this variable will pass on view by $data['arg']

Step 3 (View)

You can access query string on view by using $arg variable.

echo $arg;

Next Topic

Online Clinic/Hospital Management Synopsis

2024-04-09T22:18:00.000-07:00

The Online Clinic Management System is a web-based application designed to streamline the administrative tasks of a Clinic/Hospital or healthcare facility. It provides a platform for managing patient records, appointments, billing, and other administrative functions in an efficient and organized manner. The system aims to enhance the overall efficiency and effectiveness of clinic operations while improving patient satisfaction.Live projects have been already made through this synopsis. This synopsis covers all the standards for the synopsis. So this can be used by BCA, MCA, Bsc, O-Level, A-Level, IGNOU students.

Key Features

Dynamic website
Dynamic Entry Panel
Patient signup/login
Online package booking
Online payment
SMS/Email notification
Invoice Printing
Patient chat service
Reporting
Separate login panel for both Patient and web admin
Grievance cell
Discount/Coupon management
Customer database knowledge panel
Backup and restore management

Click to download PDF Version

Get an Editable word file

Download Next Synopsis

Online E-Content Sale Website | ASP.NET C# MVC | Free Source Code

2024-02-25T21:07:00.000-08:00

Sale your E-Content by Online Webinar Management Website with full free source code. A fully functional website with source code to sell E-Content material online. You can create profiles of teachers and their separate virtual web pages. Sale their content in the form of PDF, Audio, and video. Customer management sale to invoice everything is covered. This project can be used as any student project from minor to major. Sample code is run by many business holders around the world. You will get a popular inbuilt payment gateway able to take payment INR or Dollars. SEO friendly fully optimized.

Key Feature

Dynamic Website
Responsive Page design
Lightweight for speed optimization
SEO Friendly page
Fully Feature of E-Commerce
Integrated payment gateway (Stripe,CC Avenue, Paypal)
Customer management
Customer communication
Chat boat
Speaker/Teacher/Auther separate webpage
Intergrated security Feature
Power of ASP.Net MVC C#
SQL Server Database
Cart and Order Management
Live running in many country
Email Notification

Front End Technology

HTML
CSS
Java Script
Angular JS
Jquery

Backend

C#
SQL Server

Framework (ASP.Net MVC 5)

Screenshot


Home Page	About Us


Product	Single Product Page


Cart	Payment Page Page

Contact Us

Service

Signup

Refund

Speaker

Login

Download Free Source Code

Next Project

Install Lets Encrypt SSL in Windows Server Plesk

2023-12-23T23:41:00.000-08:00

Let's Encrypt is the world's biggest free SSL provider. Normally a certificate is provided for 3 months. So you have to re-install the certificate manually, if you are not using any auto-generated SSL generator client program like ACME Client. Many Hosting providers integrate auto SSL generator programs, Some are not like Godaddy.

I am using Godaddy Windows Server with Plesk, Which doesn't support Let's Encrypt SSL . You have to install it manually using a third-party certificate generator like punchsalad.com. There are some steps to get 3-month SSL certificate given below.

SSL Generate Steps

Search Lets Encrypt SSL provider like punchsalad.com.
provide your domain name. i.e. example.com,www.example.com
validate domain by two methods DNS or HTTP.
After successfully validating of domain you will get the certificate.

While validating the domain you have two options DNS and HTTP. Choosing DNS is not a good option because you will have to add it by updating your domain record. Many problems you will while your domain is purchased by a third party because every domain provider has a different user interface. You may ask OTP which login in the domain provider or domain provider sends OTP every time when update DNS.

To avoid the problem in DNS domain validation you can choose HTTP validation is simple. You have to upload a file in the prescribed folder name and the domain will be validated.

Follow The steps given below add SSL in your windows server plesk

Step 1 :

Open punchsalad.com or any other provider . I am using punchsalad.com.

In domain box enter your domain . i.e. example.com,www.example.com
Provide email choose HTTP or DNS. if you want to validate by uploading a file to your server choose HTTP.
Click Create Button

Step 2

Make folder in root of your website named .well-known
Make another folder named acme-challenge in .well-known
Create a web.config file in .well-known folder
Add code below in web.config file

<?xml version="1.0" encoding="UTF-8"?>

<system.webServer>

</staticContent>

</system.webServer>

</configuration>

Download these two files and upload in acme-challenge folder
Click verifiy domain
If you not create web.config file with given configuration then your domain will not validated while clicking on link.

Step 3

Once domain will be verified then you will get your certificate as given below picture

Step 4

Goto your plesk and choose SSL/TLS Certificate
Click Add SSL/TLS Certificate
Fill the form
Copy private keys found in step 3 and paste
Copy CRT + CA Bundle found in Step 3 and paste in certificate (*.crt) * textbox
Click the upload certificate button.

Step 5

Goto Hosting Setting from Plesk
Goto SSL/TLS Support and select your certificate name (Given in Step 4) from the drop-down list.

Click Ok Button

Next Topic

Insert record in a table with only an IDENTITY column? SQL Server

2023-12-11T04:20:00.000-08:00

I was making an image gallery with images only. So I have created a table with a single column named ID with identity. I want to create a row with the auto number and create an image with a created auto. number.

The problem is How to insert a table with only an IDENTITY column.

This problem is solved by the query given below.

INSERT dbo.TABLE DEFAULT VALUES;

Next Example

Restaurant Table Booking Project Synopsis

2023-11-29T22:24:00.000-08:00

Restaurant Table Booking Management Project Synopsis

Restaurant Table Booking Project Synopsis is a complete synopsis, which will help you to cover all business logic. Restaurant Table Booking Project is a system that helps businesses track, manage, and optimize their Table booking. This synopsis is prepared for the core PHP. You can change some minor headings and this synopsis will work for your desired platform project. Live projects have been already made through this synopsis. This synopsis covers all the standards for the synopsis for Computer Science Course. This can be used by BCA, MCA, BSc, O-Level, A-Level, IGNOU students.

Introduction of Project

This project plays a crucial role in a Restaurant Table Booking. A Restaurant Table Booking is a software application that allows users to book table or spaces online. It enables users to view available rooms, reserve rooms, and make payments securely online.

Availability: The software enables users to view the availability of rooms in real-time. This makes it easy for users to find and book rooms quickly.
Reservations: The software allows users to make reservations easily. It keeps track of all reservations and ensures that there are no double bookings.
Payment processing: The software enables users to make payments securely online. This ensures that payments are processed quickly and accurately.
Management: The software helps managers to manage the Restaurant Table Booking effectively. It provides them with real-time information on room availability, reservations, and payments.
Reporting: The software generates reports that provide insights into room occupancy, revenue, and other key performance indicators. This helps managers make informed decisions.

Key Features

Dynamic website
Staff Attendance Entry
Auto Entry and Auto Reporting
Staff Working Performance
Fraud Detection
SMS/Email notification
Work Chart Printing
Customer chat service
Reporting
Separate login panel for both user and web admin
Detail Reporting of daily ,monthly basis
PAyout Reporting
Backup and restore management.

Click to download the Synopsis PDF version

Next Project Synopsis

Success Pending order chart

2023-11-08T20:14:00.006-08:00

Welcome, This post will help you to make a chart for Success Pending order count datewise. This Sales chart shows the business summary of a month date-wise in just a glimpse. It takes a few seconds the get an idea of the whole month's business, It is a better choice to written business summary.

Developer Information

Language : C#

Framework : MVC ASP.Net

Database : SQL Server

Inline : HTML,CSS,Java script

Chart : Google Chart

Application : Show Success-Pending order datewise for a current month

Database Table

Let's get Start

At the beginning I thought it was a simple task but when I dived into dept, I found it a complicated task because success and pedning order is detected by the status field from the database. 1 indicates success, 0 indicates pending. The main problem was counting separately success,pending on the same date

Google Chart

I have used google chart for render chart. Chart data is three column format given below. First parameter is date,second , third for show chart lines for show pending or success order .

data.addRows([
[1, 0, 0],
[2, 2, 0],
[3, 0, 3],
[4, 18, 10]
]);

Requirement

As you see in the above chart data format, it is divided into three parts. The main challenge is to get pending and success counts datewise. I will show you the query step by step because to explanation of the entire query will be difficult to understand. Each sub-query will render output for the next query.

1. Get the pending and success order list of the current month datewise. Pending-Success valie save in status filed. 1 for success and 0 for pending.

with str1 as
(

select day(orderdate) as day,case when status=1 then sum(status) end as success,case when status=0 then count(status) end as pending from [Order]

group by (OrderDate),status having month(OrderDate)=month(getdate())

) select * from str1

I have saved query in CTE to output in str1 variable, which will be used output for next query.

Now we have the list of success and pending order list datewise. We have to combine this in a single row for datewise.

2. Now it is time to sum the pending and success order datewise by combining the above query output to other CTE variable str2

with str1 as

(

select day(orderdate) as day,case when status=1 then sum(status) end as success,case when status=0 then count(status) end as pending from [Order]
group by (OrderDate),status
having month(OrderDate)=month(getdate())
),
str2 as
(

select day,sum(success) as success,count(pending) as pending from str1 group by day,success,pending
) select * from str2

3. We got a list of success-pending order sum in above list. Now, it's time to remove NULL column and merge row into a single row by the query given below.

with str1 as
(
select day(orderdate) as day,case when status=1 then sum(status) end as success,case when status=0 then count(status) end as pending from [Order]

group by (OrderDate),status
having month(OrderDate)=month(getdate())
),
str2 as
(
select day,sum(success) as success,count(pending) as pending from str1 group by day,success,pending

  )
select day,max(success) s,max(pending) as p from (
  select day,isnull(success,'') as success,isnull(pending,'') as pending from str2 group by day,success,pending) tbl
  group by day

Next Topic

Cart Management | C# ASP.Net MVC

2023-09-22T20:48:00.014-07:00

Cart Management | C# ASP.Net MVC

cart management is the most important part of the E-commerce website design. There are many ways to achieve it but Session is one of the simplest method. This post help you to learn, How to implement a shopping cart using Session in C# ASP.Net MVC Pattern from scratch.

Step 1 Model

public class CartModel
{
  public string CID { get; set; }
  public List<CartProductModel> Cart { get; set; }
  public string Total { get; set; }
  public string UID { get; set; }
  public string Discount { get; set; }
}
public class CartProductModel
{
  public string ID { get; set; }
  public string ProductID { get; set; }
  public string ProductName { get; set; }
  public string Price { get; set; }
  public string Qty { get; set; }
}

CartModel is main class which will save the products in cart using CartProductModel class with User ID, Total Amount and Discount. CartProductModel class will save a single product when user add an item in class then add this product in generic list in CartModel class Cart object.

Step 2 Add to Cart

In this sample, I have create Product shop or Single Product page flat in HTML Page. You can modify it as per your code. Normally this section renders dynamically based on data coming from database.

I have created a function AddtoCart() in cart.js. This function call by add to button click.Argument will bind while on click event on Add to cart button. The signature of function is given below

function AddtoCart(pid, pname, price, proqty)
{
FlagSID = true;
  var Lecob =
  {
  ProductID: pid,
  ProductName: pname,
  Price: price,
Qty: $("#" + proqty).val()
  }

    $.ajax({
url: '/Home/AddToCart/',
dataType: "json",
async: false,
type: "POST",
contentType: 'application/json; charset=utf-8',
  data: JSON.stringify(Lecob),
success: function (data)
{
  if (data.sMessage == "1")
{
window.location.href = "/Home/cart";
  }
  else
{
  alert(data.sMessage);
  }
  }
  });
}

Controller JSON function

public JsonResult AddToCart(CartProductModel product)
{
  if (Session["Cart"] == null)  // When cart is null
  {
CartModel ob = new CartModel();
Random r = new Random();
ob.Cart = new List<CartProductModel>();
  ob.CID = r.Next(1, 100).ToString();
  ob.Cart.Add(SetCartProduct(product.ProductID, product.ProductName, product.Price, product.Qty));
  ob.Total = product.Price;
Session["Cart"] = ob;
  return Json(new { sMessage = "1", JsonRequestBehavior.AllowGet });
  }
  else
  {

                 //if cart have item
// Read cart from session and store into Cart model object   CartModel OldCart = (CartModel)Session["Cart"];
// Get all products from cart into product model List<CartProductModel> data = ((CartModel)Session["Cart"]).Cart; var index = data.FindIndex(e => e.ProductID == product.ProductID);    // find current product is exist in cart
  if (index == -1) // product is not exist in cart
  {

                    OldCart.Cart.Add(SetCartProduct(product.ProductID, product.ProductName, product.Price, product.Qty));
Session["Cart"] = OldCart;
        OldCart.Total = Convert.ToString(Convert.ToInt32(OldCart.Total) + (Convert.ToInt32(product.Price) * Convert.ToInt32(product.Qty)));
  return Json(new { sMessage = "1", JsonRequestBehavior.AllowGet });

                }
  else //if product is exist in cart
  {

                    int oqty = 0;
  oqty = Convert.ToInt32(data[index].Qty);
  oqty += Convert.ToInt32(product.Qty);
  data[index].Qty = oqty.ToString();
  return Json(new { sMessage = "1", JsonRequestBehavior.AllowGet });   }

}

// Add an item into cart

protected CartProductModel SetCartProduct(string id, string name, string price, string qty)
{

            CartProductModel ob = new CartProductModel();
  ob.ProductID = id;
  ob.ProductName = name;
  ob.Price = price;
  ob.Qty = qty;
  return ob;
}

Show Products

HTML

<img src="~/img/100.jpg" />
<br /><br />
<strong>PID : </strong> 100 <br />
<strong>Maharaza Chair</strong> <br />
<strong>Price : </strong> 123 <br />
<strong>Qty : </strong><input type="number" value="1" min="1" max="10" id="q100">
<br /><br />
<a href="/home/product?pid=100&nm=Maharaza Chair&price=123">
<input type="button" value="View Product" class="btn btn-success" />
</a>
<input type="button" value="Add to Cart" class="btn btn-primary" onclick="AddtoCart('100','Maharaza Chair','123','q100')" />

I have shown static values for product details. you can implement your login because, in a real environment, these values come from the database and render using a loop

Show a single product

HTML

<div class="row">
  <div class="col-md-6">
<img src="@string.Concat("/img/",Request.QueryString["pid"],".jpg")" />
</div>
  <div class="col-md-6">
<h1>@Request.QueryString["nm"]</h1><hr />
<strong>Price : </strong> @Request.QueryString["price"] <br /><br />
<input type="number" value="1" min="1" max="10" id="qty"><br /><br />
<input type="button" value="Add to Cart" class="btn btn-primary" onclick="AddtoCart('@Request.QueryString["pid"]','@Request.QueryString["nm"]','@Request.QueryString["price"]', 'qty')" />
  </div>
/div>

I have shown product details using query string because I want to make this post simple and short. You can change these HTML as per your theme because in the real world product details will come from the database.

Step 3 Modify Cart

HTML

Cart item count control ID is created using product ID with qty prefix to make a unique ID for every cart count change control. This ID will pass to the function to read the item number entered by the user.

Javascript Function

function ChangeCount(pid, productname, price, qty)
{

if (parseInt($("#" + qty).val()) > 0)
{

window.location.href = "/home/ChangeCartCount?pid=" + pid + "&name=" + productname + "&price=" + price + "&qty=" + $("#" + qty).val();

}
else
{
alert("0 Quantity is not allowed.")
$("#" + qty).val('1');

}

Json function ChangeCartCount on Home controller to handle cart modification request

public ActionResult ChangeCartCount(string pid, string name, string price, string qty)
{
CartModel OldCart = (CartModel)Session["Cart"];
List<CartProductModel> data = ((CartModel)Session["Cart"]).Cart;
  int oqty, oprice, ototal;
  var index = data.FindIndex(e => e.ProductID == pid);
  oqty = Convert.ToInt32(data[index].Qty);
  oprice = Convert.ToInt32(data[index].Price);
  ototal = Convert.ToInt32(OldCart.Total);
  ototal = ototal - (oqty * oprice);
  ototal += Convert.ToInt32(qty) * Convert.ToInt32(price);
  OldCart.Total = ototal.ToString();
  data[index].Price = price;
  data[index].Qty = qty;
  return RedirectToAction("cart", "home");
}

Step 4 (Delete an item from cart)

HTML

Json function DelCartItem on Home controller to delete an item from cart.

public ActionResult DelCartItem(string pid)
{
List<CartProductModel> data = ((CartModel)Session["Cart"]).Cart;
string tot = data.ElementAt(data.FindIndex(e => e.ProductID == pid)).Price; string qty = data.ElementAt(data.FindIndex(e => e.ProductID == pid)).Qty; data.RemoveAt(data.FindIndex(e => e.ProductID == pid));
if (data.Count == 0) // when only item in cart

{
Session["Cart"] = null;
}
else
{
CartModel OldCart = (CartModel)Session["Cart"];
Session["Cart"] = OldCart;
OldCart.Total = Convert.ToString(Convert.ToInt32(OldCart.Total) - (Convert.ToInt32(tot) * Convert.ToInt32(qty)));
}
return RedirectToAction("cart", "home");
}

Download Source Code