C# Projects

C# Projects Inventory

Electronic shop SOURCE CODE IN ASP.NET C# [Download]

Leave a Comment / ASP Projectrs, C# Projects / By Projects Inventory

Download ASP.NET SOURCE CODE for electronic shop STUDY OF EXISTING SYSTEM System analysis is the process of gathering and interpreting facts, identifying problems and using the information to recommend improvements on the system. System analysis is a problem solving activity that requires intensive communication between the system users and system developers. System analysis or study …

Electronic shop SOURCE CODE IN ASP.NET C# [Download] Read More »

ASP.Net Code of Employee Transfer And Promotion Management SYSTEM

Leave a Comment / ASP Projectrs, C# Projects / By Projects Inventory

Mutual Transfer Project.csproj.user

<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="Current" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <Controller_SelectedScaffolderID>MvcControllerEmptyScaffolder</Controller_SelectedScaffolderID>
    <Controller_SelectedScaffolderCategoryPath>root/Common/MVC/Controller</Controller_SelectedScaffolderCategoryPath>
    <WebStackScaffolding_ControllerDialogWidth>650</WebStackScaffolding_ControllerDialogWidth>
    <WebStackScaffolding_IsLayoutPageSelected>True</WebStackScaffolding_IsLayoutPageSelected>
    <WebStackScaffolding_IsPartialViewSelected>False</WebStackScaffolding_IsPartialViewSelected>
    <WebStackScaffolding_IsReferencingScriptLibrariesSelected>False</WebStackScaffolding_IsReferencingScriptLibrariesSelected>
    <WebStackScaffolding_DbContextTypeFullName>Mutual_Transfer_Project.Data.ApplicationDbContext</WebStackScaffolding_DbContextTypeFullName>
    <WebStackScaffolding_IsAsyncSelected>False</WebStackScaffolding_IsAsyncSelected>
    <WebStackScaffolding_IsViewGenerationSelected>True</WebStackScaffolding_IsViewGenerationSelected>
    <View_SelectedScaffolderID>RazorViewEmptyScaffolder</View_SelectedScaffolderID>
    <View_SelectedScaffolderCategoryPath>root/Common/MVC/View</View_SelectedScaffolderCategoryPath>
    <WebStackScaffolding_ViewDialogWidth>650</WebStackScaffolding_ViewDialogWidth>
    <ShowAllFiles>true</ShowAllFiles>
    <WebStackScaffolding_LayoutPageFile />
  </PropertyGroup>
</Project>

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

<Controller_SelectedScaffolderID>MvcControllerEmptyScaffolder</Controller_SelectedScaffolderID>

<Controller_SelectedScaffolderCategoryPath>root/Common/MVC/Controller</Controller_SelectedScaffolderCategoryPath>

<WebStackScaffolding_ControllerDialogWidth>650</WebStackScaffolding_ControllerDialogWidth>

<WebStackScaffolding_IsLayoutPageSelected>True</WebStackScaffolding_IsLayoutPageSelected>

<WebStackScaffolding_IsPartialViewSelected>False</WebStackScaffolding_IsPartialViewSelected>

<WebStackScaffolding_IsReferencingScriptLibrariesSelected>False</WebStackScaffolding_IsReferencingScriptLibrariesSelected>

<WebStackScaffolding_DbContextTypeFullName>Mutual_Transfer_Project.Data.ApplicationDbContext</WebStackScaffolding_DbContextTypeFullName>

<WebStackScaffolding_IsAsyncSelected>False</WebStackScaffolding_IsAsyncSelected>

<WebStackScaffolding_IsViewGenerationSelected>True</WebStackScaffolding_IsViewGenerationSelected>

<View_SelectedScaffolderID>RazorViewEmptyScaffolder</View_SelectedScaffolderID>

<View_SelectedScaffolderCategoryPath>root/Common/MVC/View</View_SelectedScaffolderCategoryPath>

<WebStackScaffolding_ViewDialogWidth>650</WebStackScaffolding_ViewDialogWidth>

<WebStackScaffolding_LayoutPageFile />

</PropertyGroup>

</Project>

Department.cs

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Threading.Tasks;

namespace Mutual_Transfer_Project.Models
{
    public class Department
    {
        [Key]
        public int ID { get; set; }
        public string Title { get; set; }

        public ICollection<Employee> Employees { get; set; }
    }
}

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.Linq;

using System.Threading.Tasks;

namespace Mutual_Transfer_Project.Models

{

public class Department

{

[Key]

public int ID { get; set; }

public string Title { get; set; }

public ICollection<Employee> Employees { get; set; }

}

Designation.cs

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Threading.Tasks;

namespace Mutual_Transfer_Project.Models
{
    public class Designation
    {
        [Key]
        public int ID { get; set; }
        public string Title { get; set; }

        public ICollection<Employee> Employees { get; set; }
    }
}

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.Linq;

using System.Threading.Tasks;

namespace Mutual_Transfer_Project.Models

{

public class Designation

{

[Key]

public int ID { get; set; }

public string Title { get; set; }

public ICollection<Employee> Employees { get; set; }

}

Employee.cs

using Mutual_Transfer_Project.Data;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Threading.Tasks;

namespace Mutual_Transfer_Project.Models
{
    public class Employee
    {
        [Key]
        public int ID { get; set; }
        public string Name { get; set; }
        public string Email { get; set; }
        public string ContactNo { get; set; }
        public string Address { get; set; }

        [ForeignKey("DepartmentId")]
        public int? DepartmentId { get; set; }
        public virtual Department Department { get; set; }

        [ForeignKey("DesignationId")]
        public int? DesignationId { get; set; }
        public virtual Designation Designation { get; set; }

        [ForeignKey("CompanyId")]
        public int? CompanyId { get; set; }
        public virtual Company Company { get; set; }
        [ForeignKey("UserId")]
        public int? UserId { get; set; }
        public virtual User User { get; set; }
        public ICollection<MutualTransferRequest> MutualTransferRequests { get; set; }
    }
}

using Mutual_Transfer_Project.Data;

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

using System.Threading.Tasks;

namespace Mutual_Transfer_Project.Models

{

public class Employee

{

[Key]

public int ID { get; set; }

public string Name { get; set; }

public string Email { get; set; }

public string ContactNo { get; set; }

public string Address { get; set; }

[ForeignKey("DepartmentId")]

public int? DepartmentId { get; set; }

public virtual Department Department { get; set; }

[ForeignKey("DesignationId")]

public int? DesignationId { get; set; }

public virtual Designation Designation { get; set; }

[ForeignKey("CompanyId")]

public int? CompanyId { get; set; }

public virtual Company Company { get; set; }

[ForeignKey("UserId")]

public int? UserId { get; set; }

public virtual User User { get; set; }

public ICollection<MutualTransferRequest> MutualTransferRequests { get; set; }

}

MutualTransferRequest.cs

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Threading.Tasks;

namespace Mutual_Transfer_Project.Models
{
    public class MutualTransferRequest
    {
        [Key]
        public int ID { get; set; }
        public string Description { get; set; }
        public bool IsAccepted { get; set; }
        public DateTime Date { get; set; }

        [ForeignKey("ResponceId")]
        public int? ResponceId { get; set; }
        public virtual MutualTransferRequest Responce { get; set; }
        public ICollection<MutualTransferRequest> MutualTransferRequests { get; set; }
        [ForeignKey("EmployeeId")]
        public int? EmployeeId { get; set; }
        public virtual Employee Employee { get; set; }


        [ForeignKey("CityId")]
        public int? CityId { get; set; }
        public virtual City City { get; set; }

        [ForeignKey("DesignationId")]
        public int? DesignationId { get; set; }
        public virtual Designation Designation { get; set; }
        [ForeignKey("DepartmentId")]
        public int? DepartmentId { get; set; }
        public virtual Department Department { get; set; }

    }
}

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

using System.Threading.Tasks;

namespace Mutual_Transfer_Project.Models

{

public class MutualTransferRequest

{

[Key]

public int ID { get; set; }

public string Description { get; set; }

public bool IsAccepted { get; set; }

public DateTime Date { get; set; }

[ForeignKey("ResponceId")]

public int? ResponceId { get; set; }

public virtual MutualTransferRequest Responce { get; set; }

public ICollection<MutualTransferRequest> MutualTransferRequests { get; set; }

[ForeignKey("EmployeeId")]

public int? EmployeeId { get; set; }

public virtual Employee Employee { get; set; }

[ForeignKey("CityId")]

public int? CityId { get; set; }

public virtual City City { get; set; }

[ForeignKey("DesignationId")]

public int? DesignationId { get; set; }

public virtual Designation Designation { get; set; }

[ForeignKey("DepartmentId")]

public int? DepartmentId { get; set; }

public virtual Department Department { get; set; }

}

Download ASP.Net Full Code of Employee Transfer And Promotion Management SYSTEM Employee Transfer And Promotion Management System INTRODUCTION PROJECT OBJECTIVES of Employee Transfer And Promotion Management System The objective of the project is to make a website Employee transfer and Promotion management …

ASP.Net Code of Employee Transfer And Promotion Management SYSTEM Read More »

Code of Bakery Inventory Management System in C# [FreeDownload]

Leave a Comment / C# Projects / By Projects Inventory

Code of Bakery Inventory Management System in C# [Free Download] The Bakery Inventory Management System is a software delveped in C#.net. The Bakery Inventory Management System is very good if you have a small bakery business in your city. We all know that keeping track of inventory can be a problem during rush hours, but with the use of this …

Code of Bakery Inventory Management System in C# [FreeDownload] Read More »

Code of Leave management system project in c#net

Leave a Comment / C# Projects / By Projects Inventory

Leave management system project in c#net Leave management system project in c#net is developed in C# and MySQL Database. Leave management system project track the activity of every worker/employee/servant in a company most especially their leave of absence. By the use of Leave management system, the admin user has the ability to see how …

Code of Leave management system project in c#net Read More »

Inventory Management System in C# – Project Code

Leave a Comment / C# Projects / By Projects Inventory

Inventory Management System in C# – Project Code Functional requirements of Inventory Management System in C# The user can search Category The admin can insert, delete, view, update and search Warehouse Easy dashboard Item insert, delete, view, update and search by the admin The admin can add Category The admin can delete Category The admin …

Inventory Management System in C# – Project Code Read More »

[Source Code Download] Students Course Enrollment Management System Project in C#

Leave a Comment / C# Projects / By Projects Inventory

The Students Course Enrollment Management System has the advantage of decreasing the time and effort in the student enrollment process. This system aids you to eliminate unnecessary paperwork and bringing a new level of enrollment transaction. The Students Course Enrollment Management System is an easy way of retrieving and storing student information made easy and …

[Source Code Download] Students Course Enrollment Management System Project in C# Read More »

[Free Code Download] Laboratory Monitoring Project in C#

Leave a Comment / C# Projects / By Projects Inventory

Laboratory Monitoring Project in C# The Laboratory Monitoring Project in C# is an automated system developed in C# and MySQL is used for the database. The Laboratory Monitoring Project is a user-friendly system that users can easily operate and understood how the system will operate. In The Laboratory Monitoring Project, we can view with ease the list of items that contain the …

[Free Code Download] Laboratory Monitoring Project in C# Read More »

LIBRARY MANAGEMENT SYSTEM C# Download Source code OF Project (FYP)

Leave a Comment / C# Projects / By Projects Inventory

Let’s see the code of the LIBRARY MANAGEMENT SYSTEM project in C#. frmOverdue.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using LibrarySystem.Includes;
using LibrarySystem.Properties;

namespace LibrarySystem
{
    public partial class frmOverdue : Form
    {
        public frmOverdue()
        {
            InitializeComponent();
        }

        SQLConfig config = new SQLConfig();
        usableFunction funct = new usableFunction();
        string sql;

        private void btnPenNew_Click(object sender, EventArgs e)
        {
            funct.clearTxt(GroupBox7);
            funct.clearTxt(GroupBox10);


            sql = "SELECT br.`BorrowerId`, `BookTitle`,`DateBorrowed`, `Purpose`, `DueDate` , BorrowId,br.AccessionNo " + 
              " FROM `tblborrow` br,`tblbooks` b,`tblborrower` bw  " + 
              " WHERE br.AccessionNo=b.AccessionNo AND br.`BorrowerId`=bw.`BorrowerId` AND br.Status='Borrowed' AND Due=1 ";
            config.Load_ResultList(sql, dtgPenalties);
            dtgPenalties.Columns[5].Visible = false;
            dtgPenalties.Columns[6].Visible = false;

        }

        private void frmOverdue_Load(object sender, EventArgs e)
        {
            btnPenNew_Click(sender, e);
        }

        private void txtSearchPborrower_TextChanged(object sender, EventArgs e)
        {
            sql = "SELECT br.`BorrowerId`, `BookTitle`,`DateBorrowed`, `Purpose`, `DueDate` , BorrowId,br.AccessionNo " +
             " FROM `tblborrow` br,`tblbooks` b,`tblborrower` bw  " +
             " WHERE br.AccessionNo=b.AccessionNo AND br.`BorrowerId`=bw.`BorrowerId` AND br.Status='Borrowed' AND Due=1 AND   br.`BorrowerId` Like '%" + txtSearchPborrower.Text + "%'";
            config.Load_ResultList(sql, dtgPenalties);
            dtgPenalties.Columns[5].Visible = false;
            dtgPenalties.Columns[6].Visible = false;
        }

        private void dtgPenalties_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            sql = "SELECT  TIMEDIFF( NOW( ) ,  `DueDate` ),`AccessionNo` " 
                 + "FROM  `tblborrow` WHERE `BorrowId` = '" + dtgPenalties.CurrentRow.Cells[5].Value.ToString() + "'";
            config.singleResult(sql);
            if (config.dt.Rows.Count > 0)
            {
                TimeSpan ts = config.dt.Rows[0].Field<TimeSpan>(0);
                int tsdays, hourperday, tshours, totalhours;
                //MessageBox.Show(ts.Hours.ToString());

                tsdays = ts.Days;

                hourperday = tsdays * 24;
                tshours = ts.Hours;
                totalhours = hourperday + tshours;



                txtOverdueTime.Text = ts.ToString();
                txttothours.Text = totalhours.ToString();

            } 

        }

        private void txtamount_TextChanged(object sender, EventArgs e)
        {

            try
            {
                int totalpayments;

                totalpayments = int.Parse(txttothours.Text) * int.Parse(txtamount.Text);

            }
            catch (Exception ex)
            {

            }
        
            //totalhours = condays + tValueHour
            //totalhours = totalhours / Val(frmPayments.txthours.Text)
            //frmPayments.txtTotPay.Text = totalhours * Val(frmPayments.txtamount.Text)
        }
         
        private void txthours_ValueChanged(object sender, EventArgs e)
        {
            try
            {

                double total_hours, total_payments;

                total_hours = int.Parse(txttothours.Text) / int.Parse(txthours.Text);
                total_payments = total_hours * double.Parse(txtamount.Text);

                txtTotPay.Text = total_payments.ToString();

            }
            catch (Exception ex)
            {

            }
        }

        private void txthours_KeyPress(object sender, KeyPressEventArgs e)
        {
            try
            {

                double total_hours, total_payments;

                total_hours = int.Parse(txttothours.Text) / int.Parse(txthours.Text);
                total_payments = total_hours * double.Parse(txtamount.Text);

                txtTotPay.Text = total_payments.ToString();

            }
            catch (Exception ex)
            {

            }
        }

        private void txttenderedAmount_TextChanged(object sender, EventArgs e)
        {
            double change;
            change = double.Parse(txttenderedAmount.Text) - double.Parse(txtTotPay.Text);
            txtChange.Text = change.ToString();
        }

        private void btnPSave_Click(object sender, EventArgs e)
        {
            if (txtamount.Text == "" || txthours.Text == "" || txttenderedAmount.Text == "" || txtOverdueTime.Text == "")
            {
                MessageBox.Show("You must fill all the fields inorder to save.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                return;
            }
            if(int.Parse(txtChange.Text) < 0)
            {
                MessageBox.Show("The tendered amount is less than the total payments. Its not valid", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                return;

            }


            sql = "INSERT INTO `tblpayment` (`BorrowId`, `Payment`, `Change`, `DatePayed`, `BorrowerId`, `Remarks`) "
                + " VALUES (" + dtgPenalties.CurrentRow.Cells[6].Value + ",'" + txtTotPay.Text + "','" + txtChange.Text +
                "',Now(),'" + dtgPenalties.CurrentRow.Cells[0].Value + "','Settled')";
            config.Execute_Query(sql);

            sql = "INSERT INTO `tblreturn` (`BorrowId`, `NoCopies`, `DateReturned`, `Remarks`)" +
                  " VALUES (" + dtgPenalties.CurrentRow.Cells[6].Value + ",1,NOW(),'Returned')";
            config.Execute_Query(sql);


            sql = "UPDATE  `tblbooks` SET  `Status` =  'Available' WHERE  `AccessionNo` = '" + dtgPenalties.CurrentRow.Cells[6].Value + "'";
            config.Execute_Query(sql);

            sql = "UPDATE `tblborrow` SET  `Status` =  'Returned', Due = 0 WHERE `BorrowId` = " + dtgPenalties.CurrentRow.Cells[5].Value;
            config.Execute_Query(sql);

            MessageBox.Show("Book has been returned and settled in the library");
            btnPenNew_Click(sender, e); 
        }

        private void btnPenClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using LibrarySystem.Includes;

using LibrarySystem.Properties;

namespace LibrarySystem

{

public partial class frmOverdue : Form

{

public frmOverdue()

{

InitializeComponent();

}

SQLConfig config = new SQLConfig();

usableFunction funct = new usableFunction();

string sql;

private void btnPenNew_Click(object sender, EventArgs e)

{

funct.clearTxt(GroupBox7);

funct.clearTxt(GroupBox10);

sql = "SELECT br.`BorrowerId`, `BookTitle`,`DateBorrowed`, `Purpose`, `DueDate` , BorrowId,br.AccessionNo " +

" FROM `tblborrow` br,`tblbooks` b,`tblborrower` bw " +

" WHERE br.AccessionNo=b.AccessionNo AND br.`BorrowerId`=bw.`BorrowerId` AND br.Status='Borrowed' AND Due=1 ";

config.Load_ResultList(sql, dtgPenalties);

dtgPenalties.Columns[5].Visible = false;

dtgPenalties.Columns[6].Visible = false;

}

private void frmOverdue_Load(object sender, EventArgs e)

{

btnPenNew_Click(sender, e);

}

private void txtSearchPborrower_TextChanged(object sender, EventArgs e)

{

sql = "SELECT br.`BorrowerId`, `BookTitle`,`DateBorrowed`, `Purpose`, `DueDate` , BorrowId,br.AccessionNo " +

" FROM `tblborrow` br,`tblbooks` b,`tblborrower` bw " +

" WHERE br.AccessionNo=b.AccessionNo AND br.`BorrowerId`=bw.`BorrowerId` AND br.Status='Borrowed' AND Due=1 AND br.`BorrowerId` Like '%" + txtSearchPborrower.Text + "%'";

config.Load_ResultList(sql, dtgPenalties);

dtgPenalties.Columns[5].Visible = false;

dtgPenalties.Columns[6].Visible = false;

}

private void dtgPenalties_CellClick(object sender, DataGridViewCellEventArgs e)

{

sql = "SELECT TIMEDIFF( NOW( ) , `DueDate` ),`AccessionNo` "

+ "FROM `tblborrow` WHERE `BorrowId` = '" + dtgPenalties.CurrentRow.Cells[5].Value.ToString() + "'";

config.singleResult(sql);

if (config.dt.Rows.Count > 0)

{

TimeSpan ts = config.dt.Rows[0].Field<TimeSpan>(0);

int tsdays, hourperday, tshours, totalhours;

//MessageBox.Show(ts.Hours.ToString());

tsdays = ts.Days;

hourperday = tsdays * 24;

tshours = ts.Hours;

totalhours = hourperday + tshours;

txtOverdueTime.Text = ts.ToString();

txttothours.Text = totalhours.ToString();

}

private void txtamount_TextChanged(object sender, EventArgs e)

{

try

{

int totalpayments;

totalpayments = int.Parse(txttothours.Text) * int.Parse(txtamount.Text);

}

catch (Exception ex)

{

}

//totalhours = condays + tValueHour

//totalhours = totalhours / Val(frmPayments.txthours.Text)

//frmPayments.txtTotPay.Text = totalhours * Val(frmPayments.txtamount.Text)

}

private void txthours_ValueChanged(object sender, EventArgs e)

{

try

{

double total_hours, total_payments;

total_hours = int.Parse(txttothours.Text) / int.Parse(txthours.Text);

total_payments = total_hours * double.Parse(txtamount.Text);

txtTotPay.Text = total_payments.ToString();

}

catch (Exception ex)

{

}

private void txthours_KeyPress(object sender, KeyPressEventArgs e)

{

try

{

double total_hours, total_payments;

total_hours = int.Parse(txttothours.Text) / int.Parse(txthours.Text);

total_payments = total_hours * double.Parse(txtamount.Text);

txtTotPay.Text = total_payments.ToString();

}

catch (Exception ex)

{

}

private void txttenderedAmount_TextChanged(object sender, EventArgs e)

{

double change;

change = double.Parse(txttenderedAmount.Text) - double.Parse(txtTotPay.Text);

txtChange.Text = change.ToString();

}

private void btnPSave_Click(object sender, EventArgs e)

{

if (txtamount.Text == "" || txthours.Text == "" || txttenderedAmount.Text == "" || txtOverdueTime.Text == "")

{

MessageBox.Show("You must fill all the fields inorder to save.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);

return;

}

if(int.Parse(txtChange.Text) < 0)

{

MessageBox.Show("The tendered amount is less than the total payments. Its not valid", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);

return;

}

sql = "INSERT INTO `tblpayment` (`BorrowId`, `Payment`, `Change`, `DatePayed`, `BorrowerId`, `Remarks`) "

+ " VALUES (" + dtgPenalties.CurrentRow.Cells[6].Value + ",'" + txtTotPay.Text + "','" + txtChange.Text +

"',Now(),'" + dtgPenalties.CurrentRow.Cells[0].Value + "','Settled')";

config.Execute_Query(sql);

sql = "INSERT INTO `tblreturn` (`BorrowId`, `NoCopies`, `DateReturned`, `Remarks`)" +

" VALUES (" + dtgPenalties.CurrentRow.Cells[6].Value + ",1,NOW(),'Returned')";

config.Execute_Query(sql);

sql = "UPDATE `tblbooks` SET `Status` = 'Available' WHERE `AccessionNo` = '" + dtgPenalties.CurrentRow.Cells[6].Value + "'";

config.Execute_Query(sql);

sql = "UPDATE `tblborrow` SET `Status` = 'Returned', Due = 0 WHERE `BorrowId` = " + dtgPenalties.CurrentRow.Cells[5].Value;

config.Execute_Query(sql);

MessageBox.Show("Book has been returned and settled in the library");

btnPenNew_Click(sender, e);

}

private void btnPenClose_Click(object sender, EventArgs e)

{

this.Close();

}

frmCategories.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using LibrarySystem.Includes;
using LibrarySystem.Properties;
using System.IO;

namespace LibrarySystem
{
    public partial class frmCategories : Form
    {
        public frmCategories()
        {
            InitializeComponent();
        }

        SQLConfig config = new SQLConfig();
        usableFunction funct = new usableFunction();
        string sql,categoryid;
        private void frmCategories_Load(object sender, EventArgs e)
        {
            btnnew_Click(sender, e);
        }

        private void btnnew_Click(object sender, EventArgs e)
        {
            categoryid = "0";
            txtCategory.Clear();
            txtDeweyDecimal.Clear();
            sql = "Select CategoryId,`Category`,`DDecimal` as 'DeweyDecimal' From tblcategory WHERE Category !='ALL'";
            config.Load_DTG(sql, dtglist);
            btndelete.Enabled = false;
        }

        private void btnsave_Click(object sender, EventArgs e)
        {

            if( txtCategory.Text == "")
            {
                funct.emptymessage();
            }

            sql = "Select * From tblcategory WHERE CategoryId = '" + categoryid + "'";
            config.singleResult(sql);
            if (config.dt.Rows.Count > 0)
            {
                sql = "UPDATE `tblcategory` SET `Category`='" + txtCategory.Text + "',`DDecimal`='" + txtDeweyDecimal.Text + "' WHERE CategoryId='" + categoryid + "'";
                config.Execute_CUD(sql, "error to execute the query.", "Category has been updated in the database.");
            }
            else
            {
                sql = "INSERT INTO `tblcategory` (`Category`,`DDecimal`) VALUES ('" + txtCategory.Text + "','" + txtDeweyDecimal.Text + "')";
                config.Execute_CUD(sql, "error to execute the query.", "New category has been saved in the database.");
            } 
            btnnew_Click(sender, e);

          
        }

        private void btndelete_Click(object sender, EventArgs e)
        {
            sql = "Delete From tblcategory WHERE CategoryId = " + dtglist.CurrentRow.Cells[0].Value;
            config.Execute_Query(sql);
            MessageBox.Show("Data has been deleted.");
            btnnew_Click(sender, e);
        }

        private void dtglist_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            categoryid = dtglist.CurrentRow.Cells[0].Value.ToString();
            txtCategory.Text = dtglist.CurrentRow.Cells[1].Value.ToString();
            txtDeweyDecimal.Text = dtglist.CurrentRow.Cells[2].Value.ToString();
            btndelete.Enabled = true;
        }
    }
}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using LibrarySystem.Includes;

using LibrarySystem.Properties;

using System.IO;

namespace LibrarySystem

{

public partial class frmCategories : Form

{

public frmCategories()

{

InitializeComponent();

}

SQLConfig config = new SQLConfig();

usableFunction funct = new usableFunction();

string sql,categoryid;

private void frmCategories_Load(object sender, EventArgs e)

{

btnnew_Click(sender, e);

}

private void btnnew_Click(object sender, EventArgs e)

{

categoryid = "0";

txtCategory.Clear();

txtDeweyDecimal.Clear();

sql = "Select CategoryId,`Category`,`DDecimal` as 'DeweyDecimal' From tblcategory WHERE Category !='ALL'";

config.Load_DTG(sql, dtglist);

btndelete.Enabled = false;

}

private void btnsave_Click(object sender, EventArgs e)

{

if( txtCategory.Text == "")

{

funct.emptymessage();

}

sql = "Select * From tblcategory WHERE CategoryId = '" + categoryid + "'";

config.singleResult(sql);

if (config.dt.Rows.Count > 0)

{

sql = "UPDATE `tblcategory` SET `Category`='" + txtCategory.Text + "',`DDecimal`='" + txtDeweyDecimal.Text + "' WHERE CategoryId='" + categoryid + "'";

config.Execute_CUD(sql, "error to execute the query.", "Category has been updated in the database.");

}

else

{

sql = "INSERT INTO `tblcategory` (`Category`,`DDecimal`) VALUES ('" + txtCategory.Text + "','" + txtDeweyDecimal.Text + "')";

config.Execute_CUD(sql, "error to execute the query.", "New category has been saved in the database.");

}

btnnew_Click(sender, e);

}

private void btndelete_Click(object sender, EventArgs e)

{

sql = "Delete From tblcategory WHERE CategoryId = " + dtglist.CurrentRow.Cells[0].Value;

config.Execute_Query(sql);

MessageBox.Show("Data has been deleted.");

btnnew_Click(sender, e);

}

private void dtglist_CellClick(object sender, DataGridViewCellEventArgs e)

{

categoryid = dtglist.CurrentRow.Cells[0].Value.ToString();

txtCategory.Text = dtglist.CurrentRow.Cells[1].Value.ToString();

txtDeweyDecimal.Text = dtglist.CurrentRow.Cells[2].Value.ToString();

btndelete.Enabled = true;

}

frmReport.Designer.cs

namespace LibrarySystem
{
    partial class frmReport
    {
        /// <summary>
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary>
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Windows Form Designer generated code

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.dtp_endDate = new System.Windows.Forms.DateTimePicker();
            this.btn_preview = new System.Windows.Forms.Button();
            this.btnTotalbooks = new System.Windows.Forms.Button();
            this.btnListBooks = new System.Windows.Forms.Button();
            this.rdoMonthly = new System.Windows.Forms.RadioButton();
            this.rdoWeekly = new System.Windows.Forms.RadioButton();
            this.rdoDaily = new System.Windows.Forms.RadioButton();
            this.dtp_strtDate = new System.Windows.Forms.DateTimePicker();
            this.Label2 = new System.Windows.Forms.Label();
            this.Label3 = new System.Windows.Forms.Label();
            this.Label1 = new System.Windows.Forms.Label();
            this.cboStatus = new System.Windows.Forms.ComboBox();
            this.GroupBox1 = new System.Windows.Forms.GroupBox();
            this.FlowLayoutPanel1 = new System.Windows.Forms.FlowLayoutPanel();
            this.GroupBox2 = new System.Windows.Forms.GroupBox();
            this.crystalReportViewer1 = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
            this.GroupBox1.SuspendLayout();
            this.FlowLayoutPanel1.SuspendLayout();
            this.GroupBox2.SuspendLayout();
            this.SuspendLayout();
            // 
            // dtp_endDate
            // 
            this.dtp_endDate.CustomFormat = "yyyy-MM-dd";
            this.dtp_endDate.Format = System.Windows.Forms.DateTimePickerFormat.Custom;
            this.dtp_endDate.Location = new System.Drawing.Point(10, 89);
            this.dtp_endDate.Name = "dtp_endDate";
            this.dtp_endDate.Size = new System.Drawing.Size(132, 20);
            this.dtp_endDate.TabIndex = 17;
            // 
            // btn_preview
            // 
            this.btn_preview.Location = new System.Drawing.Point(64, 120);
            this.btn_preview.Name = "btn_preview";
            this.btn_preview.Size = new System.Drawing.Size(78, 28);
            this.btn_preview.TabIndex = 15;
            this.btn_preview.Text = "Preview";
            this.btn_preview.UseVisualStyleBackColor = true;
            this.btn_preview.Click += new System.EventHandler(this.btn_preview_Click);
            // 
            // btnTotalbooks
            // 
            this.btnTotalbooks.Location = new System.Drawing.Point(10, 53);
            this.btnTotalbooks.Name = "btnTotalbooks";
            this.btnTotalbooks.Size = new System.Drawing.Size(133, 22);
            this.btnTotalbooks.TabIndex = 3;
            this.btnTotalbooks.Text = "Total No. of Books";
            this.btnTotalbooks.UseVisualStyleBackColor = true;
            this.btnTotalbooks.Click += new System.EventHandler(this.btnTotalbooks_Click);
            // 
            // btnListBooks
            // 
            this.btnListBooks.Location = new System.Drawing.Point(9, 25);
            this.btnListBooks.Name = "btnListBooks";
            this.btnListBooks.Size = new System.Drawing.Size(133, 22);
            this.btnListBooks.TabIndex = 2;
            this.btnListBooks.Text = "List of Books";
            this.btnListBooks.UseVisualStyleBackColor = true;
            this.btnListBooks.Click += new System.EventHandler(this.btnListBooks_Click);
            // 
            // rdoMonthly
            // 
            this.rdoMonthly.AutoSize = true;
            this.rdoMonthly.Location = new System.Drawing.Point(24, 186);
            this.rdoMonthly.Name = "rdoMonthly";
            this.rdoMonthly.Size = new System.Drawing.Size(97, 17);
            this.rdoMonthly.TabIndex = 2;
            this.rdoMonthly.TabStop = true;
            this.rdoMonthly.Text = "Monthly Report";
            this.rdoMonthly.UseVisualStyleBackColor = true;
            this.rdoMonthly.CheckedChanged += new System.EventHandler(this.rdoMonthly_CheckedChanged);
            // 
            // rdoWeekly
            // 
            this.rdoWeekly.AutoSize = true;
            this.rdoWeekly.Location = new System.Drawing.Point(24, 163);
            this.rdoWeekly.Name = "rdoWeekly";
            this.rdoWeekly.Size = new System.Drawing.Size(96, 17);
            this.rdoWeekly.TabIndex = 2;
            this.rdoWeekly.TabStop = true;
            this.rdoWeekly.Text = "Weekly Report";
            this.rdoWeekly.UseVisualStyleBackColor = true;
            this.rdoWeekly.CheckedChanged += new System.EventHandler(this.rdoWeekly_CheckedChanged);
            // 
            // rdoDaily
            // 
            this.rdoDaily.AutoSize = true;
            this.rdoDaily.Location = new System.Drawing.Point(24, 140);
            this.rdoDaily.Name = "rdoDaily";
            this.rdoDaily.Size = new System.Drawing.Size(83, 17);
            this.rdoDaily.TabIndex = 2;
            this.rdoDaily.TabStop = true;
            this.rdoDaily.Text = "Daily Report";
            this.rdoDaily.UseVisualStyleBackColor = true;
            this.rdoDaily.CheckedChanged += new System.EventHandler(this.rdoDaily_CheckedChanged);
            // 
            // dtp_strtDate
            // 
            this.dtp_strtDate.CustomFormat = "yyyy-MM-dd";
            this.dtp_strtDate.Format = System.Windows.Forms.DateTimePickerFormat.Custom;
            this.dtp_strtDate.Location = new System.Drawing.Point(10, 41);
            this.dtp_strtDate.Name = "dtp_strtDate";
            this.dtp_strtDate.Size = new System.Drawing.Size(132, 20);
            this.dtp_strtDate.TabIndex = 14;
            // 
            // Label2
            // 
            this.Label2.AutoSize = true;
            this.Label2.Location = new System.Drawing.Point(10, 26);
            this.Label2.Name = "Label2";
            this.Label2.Size = new System.Drawing.Size(61, 13);
            this.Label2.TabIndex = 16;
            this.Label2.Text = "Start Date :";
            // 
            // Label3
            // 
            this.Label3.AutoSize = true;
            this.Label3.Location = new System.Drawing.Point(10, 73);
            this.Label3.Name = "Label3";
            this.Label3.Size = new System.Drawing.Size(58, 13);
            this.Label3.TabIndex = 18;
            this.Label3.Text = "End Date :";
            // 
            // Label1
            // 
            this.Label1.AutoSize = true;
            this.Label1.Location = new System.Drawing.Point(7, 84);
            this.Label1.Name = "Label1";
            this.Label1.Size = new System.Drawing.Size(43, 13);
            this.Label1.TabIndex = 1;
            this.Label1.Text = "Status :";
            // 
            // cboStatus
            // 
            this.cboStatus.FormattingEnabled = true;
            this.cboStatus.Items.AddRange(new object[] {
            "Borrowed",
            "Returned",
            "Overdue"});
            this.cboStatus.Location = new System.Drawing.Point(6, 103);
            this.cboStatus.Name = "cboStatus";
            this.cboStatus.Size = new System.Drawing.Size(137, 21);
            this.cboStatus.TabIndex = 0;
            this.cboStatus.Text = "Borrowed";
            // 
            // GroupBox1
            // 
            this.GroupBox1.Controls.Add(this.btnTotalbooks);
            this.GroupBox1.Controls.Add(this.btnListBooks);
            this.GroupBox1.Controls.Add(this.rdoMonthly);
            this.GroupBox1.Controls.Add(this.rdoWeekly);
            this.GroupBox1.Controls.Add(this.rdoDaily);
            this.GroupBox1.Controls.Add(this.Label1);
            this.GroupBox1.Controls.Add(this.cboStatus);
            this.GroupBox1.Location = new System.Drawing.Point(3, 3);
            this.GroupBox1.Name = "GroupBox1";
            this.GroupBox1.Size = new System.Drawing.Size(152, 229);
            this.GroupBox1.TabIndex = 0;
            this.GroupBox1.TabStop = false;
            this.GroupBox1.Text = "Books";
            // 
            // FlowLayoutPanel1
            // 
            this.FlowLayoutPanel1.Controls.Add(this.GroupBox1);
            this.FlowLayoutPanel1.Controls.Add(this.GroupBox2);
            this.FlowLayoutPanel1.Dock = System.Windows.Forms.DockStyle.Left;
            this.FlowLayoutPanel1.Location = new System.Drawing.Point(0, 0);
            this.FlowLayoutPanel1.Name = "FlowLayoutPanel1";
            this.FlowLayoutPanel1.Size = new System.Drawing.Size(161, 551);
            this.FlowLayoutPanel1.TabIndex = 3;
            // 
            // GroupBox2
            // 
            this.GroupBox2.Controls.Add(this.dtp_strtDate);
            this.GroupBox2.Controls.Add(this.Label2);
            this.GroupBox2.Controls.Add(this.Label3);
            this.GroupBox2.Controls.Add(this.dtp_endDate);
            this.GroupBox2.Controls.Add(this.btn_preview);
            this.GroupBox2.Location = new System.Drawing.Point(3, 238);
            this.GroupBox2.Name = "GroupBox2";
            this.GroupBox2.Size = new System.Drawing.Size(152, 162);
            this.GroupBox2.TabIndex = 2;
            this.GroupBox2.TabStop = false;
            this.GroupBox2.Text = "Date Filter";
            // 
            // crystalReportViewer1
            // 
            this.crystalReportViewer1.ActiveViewIndex = -1;
            this.crystalReportViewer1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
            this.crystalReportViewer1.Cursor = System.Windows.Forms.Cursors.Default;
            this.crystalReportViewer1.Dock = System.Windows.Forms.DockStyle.Fill;
            this.crystalReportViewer1.Location = new System.Drawing.Point(161, 0);
            this.crystalReportViewer1.Name = "crystalReportViewer1";
            this.crystalReportViewer1.Size = new System.Drawing.Size(727, 551);
            this.crystalReportViewer1.TabIndex = 4;
            // 
            // frmReport
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.ClientSize = new System.Drawing.Size(888, 551);
            this.Controls.Add(this.crystalReportViewer1);
            this.Controls.Add(this.FlowLayoutPanel1);
            this.Name = "frmReport";
            this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
            this.Text = "Inventory Reports";
            this.Load += new System.EventHandler(this.frmReport_Load);
            this.GroupBox1.ResumeLayout(false);
            this.GroupBox1.PerformLayout();
            this.FlowLayoutPanel1.ResumeLayout(false);
            this.GroupBox2.ResumeLayout(false);
            this.GroupBox2.PerformLayout();
            this.ResumeLayout(false);

        }

        #endregion
        internal System.Windows.Forms.DateTimePicker dtp_endDate;
        internal System.Windows.Forms.Button btn_preview;
        internal System.Windows.Forms.Button btnTotalbooks;
        internal System.Windows.Forms.Button btnListBooks;
        internal System.Windows.Forms.RadioButton rdoMonthly;
        internal System.Windows.Forms.RadioButton rdoWeekly;
        internal System.Windows.Forms.RadioButton rdoDaily;
        internal System.Windows.Forms.DateTimePicker dtp_strtDate;
        internal System.Windows.Forms.Label Label2;
        internal System.Windows.Forms.Label Label3;
        internal System.Windows.Forms.Label Label1;
        internal System.Windows.Forms.ComboBox cboStatus;
        internal System.Windows.Forms.GroupBox GroupBox1;
        internal System.Windows.Forms.FlowLayoutPanel FlowLayoutPanel1;
        internal System.Windows.Forms.GroupBox GroupBox2;
        private CrystalDecisions.Windows.Forms.CrystalReportViewer crystalReportViewer1;
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

namespace LibrarySystem

{

partial class frmReport

{

/// <summary>

/// Required designer variable.

/// </summary>

private System.ComponentModel.IContainer components = null;

/// <summary>

/// Clean up any resources being used.

/// </summary>

/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

protected override void Dispose(bool disposing)

{

if (disposing && (components != null))

{

components.Dispose();

}

base.Dispose(disposing);

}

#region Windows Form Designer generated code

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.dtp_endDate = new System.Windows.Forms.DateTimePicker();

this.btn_preview = new System.Windows.Forms.Button();

this.btnTotalbooks = new System.Windows.Forms.Button();

this.btnListBooks = new System.Windows.Forms.Button();

this.rdoMonthly = new System.Windows.Forms.RadioButton();

this.rdoWeekly = new System.Windows.Forms.RadioButton();

this.rdoDaily = new System.Windows.Forms.RadioButton();

this.dtp_strtDate = new System.Windows.Forms.DateTimePicker();

this.Label2 = new System.Windows.Forms.Label();

this.Label3 = new System.Windows.Forms.Label();

this.Label1 = new System.Windows.Forms.Label();

this.cboStatus = new System.Windows.Forms.ComboBox();

this.GroupBox1 = new System.Windows.Forms.GroupBox();

this.FlowLayoutPanel1 = new System.Windows.Forms.FlowLayoutPanel();

this.GroupBox2 = new System.Windows.Forms.GroupBox();

this.crystalReportViewer1 = new CrystalDecisions.Windows.Forms.CrystalReportViewer();

this.GroupBox1.SuspendLayout();

this.FlowLayoutPanel1.SuspendLayout();

this.GroupBox2.SuspendLayout();

this.SuspendLayout();

// dtp_endDate

this.dtp_endDate.CustomFormat = "yyyy-MM-dd";

this.dtp_endDate.Format = System.Windows.Forms.DateTimePickerFormat.Custom;

this.dtp_endDate.Location = new System.Drawing.Point(10, 89);

this.dtp_endDate.Name = "dtp_endDate";

this.dtp_endDate.Size = new System.Drawing.Size(132, 20);

this.dtp_endDate.TabIndex = 17;

// btn_preview

this.btn_preview.Location = new System.Drawing.Point(64, 120);

this.btn_preview.Name = "btn_preview";

this.btn_preview.Size = new System.Drawing.Size(78, 28);

this.btn_preview.TabIndex = 15;

this.btn_preview.Text = "Preview";

this.btn_preview.UseVisualStyleBackColor = true;

this.btn_preview.Click += new System.EventHandler(this.btn_preview_Click);

// btnTotalbooks

this.btnTotalbooks.Location = new System.Drawing.Point(10, 53);

this.btnTotalbooks.Name = "btnTotalbooks";

this.btnTotalbooks.Size = new System.Drawing.Size(133, 22);

this.btnTotalbooks.TabIndex = 3;

this.btnTotalbooks.Text = "Total No. of Books";

this.btnTotalbooks.UseVisualStyleBackColor = true;

this.btnTotalbooks.Click += new System.EventHandler(this.btnTotalbooks_Click);

// btnListBooks

this.btnListBooks.Location = new System.Drawing.Point(9, 25);

this.btnListBooks.Name = "btnListBooks";

this.btnListBooks.Size = new System.Drawing.Size(133, 22);

this.btnListBooks.TabIndex = 2;

this.btnListBooks.Text = "List of Books";

this.btnListBooks.UseVisualStyleBackColor = true;

this.btnListBooks.Click += new System.EventHandler(this.btnListBooks_Click);

// rdoMonthly

this.rdoMonthly.AutoSize = true;

this.rdoMonthly.Location = new System.Drawing.Point(24, 186);

this.rdoMonthly.Name = "rdoMonthly";

this.rdoMonthly.Size = new System.Drawing.Size(97, 17);

this.rdoMonthly.TabIndex = 2;

this.rdoMonthly.TabStop = true;

this.rdoMonthly.Text = "Monthly Report";

this.rdoMonthly.UseVisualStyleBackColor = true;

this.rdoMonthly.CheckedChanged += new System.EventHandler(this.rdoMonthly_CheckedChanged);

// rdoWeekly

this.rdoWeekly.AutoSize = true;

this.rdoWeekly.Location = new System.Drawing.Point(24, 163);

this.rdoWeekly.Name = "rdoWeekly";

this.rdoWeekly.Size = new System.Drawing.Size(96, 17);

this.rdoWeekly.TabIndex = 2;

this.rdoWeekly.TabStop = true;

this.rdoWeekly.Text = "Weekly Report";

this.rdoWeekly.UseVisualStyleBackColor = true;

this.rdoWeekly.CheckedChanged += new System.EventHandler(this.rdoWeekly_CheckedChanged);

// rdoDaily

this.rdoDaily.AutoSize = true;

this.rdoDaily.Location = new System.Drawing.Point(24, 140);

this.rdoDaily.Name = "rdoDaily";

this.rdoDaily.Size = new System.Drawing.Size(83, 17);

this.rdoDaily.TabIndex = 2;

this.rdoDaily.TabStop = true;

this.rdoDaily.Text = "Daily Report";

this.rdoDaily.UseVisualStyleBackColor = true;

this.rdoDaily.CheckedChanged += new System.EventHandler(this.rdoDaily_CheckedChanged);

// dtp_strtDate

this.dtp_strtDate.CustomFormat = "yyyy-MM-dd";

this.dtp_strtDate.Format = System.Windows.Forms.DateTimePickerFormat.Custom;

this.dtp_strtDate.Location = new System.Drawing.Point(10, 41);

this.dtp_strtDate.Name = "dtp_strtDate";

this.dtp_strtDate.Size = new System.Drawing.Size(132, 20);

this.dtp_strtDate.TabIndex = 14;

// Label2

this.Label2.AutoSize = true;

this.Label2.Location = new System.Drawing.Point(10, 26);

this.Label2.Name = "Label2";

this.Label2.Size = new System.Drawing.Size(61, 13);

this.Label2.TabIndex = 16;

this.Label2.Text = "Start Date :";

// Label3

this.Label3.AutoSize = true;

this.Label3.Location = new System.Drawing.Point(10, 73);

this.Label3.Name = "Label3";

this.Label3.Size = new System.Drawing.Size(58, 13);

this.Label3.TabIndex = 18;

this.Label3.Text = "End Date :";

// Label1

this.Label1.AutoSize = true;

this.Label1.Location = new System.Drawing.Point(7, 84);

this.Label1.Name = "Label1";

this.Label1.Size = new System.Drawing.Size(43, 13);

this.Label1.TabIndex = 1;

this.Label1.Text = "Status :";

// cboStatus

this.cboStatus.FormattingEnabled = true;

this.cboStatus.Items.AddRange(new object[] {

"Borrowed",

"Returned",

"Overdue"});

this.cboStatus.Location = new System.Drawing.Point(6, 103);

this.cboStatus.Name = "cboStatus";

this.cboStatus.Size = new System.Drawing.Size(137, 21);

this.cboStatus.TabIndex = 0;

this.cboStatus.Text = "Borrowed";

// GroupBox1

this.GroupBox1.Controls.Add(this.btnTotalbooks);

this.GroupBox1.Controls.Add(this.btnListBooks);

this.GroupBox1.Controls.Add(this.rdoMonthly);

this.GroupBox1.Controls.Add(this.rdoWeekly);

this.GroupBox1.Controls.Add(this.rdoDaily);

this.GroupBox1.Controls.Add(this.Label1);

this.GroupBox1.Controls.Add(this.cboStatus);

this.GroupBox1.Location = new System.Drawing.Point(3, 3);

this.GroupBox1.Name = "GroupBox1";

this.GroupBox1.Size = new System.Drawing.Size(152, 229);

this.GroupBox1.TabIndex = 0;

this.GroupBox1.TabStop = false;

this.GroupBox1.Text = "Books";

// FlowLayoutPanel1

this.FlowLayoutPanel1.Controls.Add(this.GroupBox1);

this.FlowLayoutPanel1.Controls.Add(this.GroupBox2);

this.FlowLayoutPanel1.Dock = System.Windows.Forms.DockStyle.Left;

this.FlowLayoutPanel1.Location = new System.Drawing.Point(0, 0);

this.FlowLayoutPanel1.Name = "FlowLayoutPanel1";

this.FlowLayoutPanel1.Size = new System.Drawing.Size(161, 551);

this.FlowLayoutPanel1.TabIndex = 3;

// GroupBox2

this.GroupBox2.Controls.Add(this.dtp_strtDate);

this.GroupBox2.Controls.Add(this.Label2);

this.GroupBox2.Controls.Add(this.Label3);

this.GroupBox2.Controls.Add(this.dtp_endDate);

this.GroupBox2.Controls.Add(this.btn_preview);

this.GroupBox2.Location = new System.Drawing.Point(3, 238);

this.GroupBox2.Name = "GroupBox2";

this.GroupBox2.Size = new System.Drawing.Size(152, 162);

this.GroupBox2.TabIndex = 2;

this.GroupBox2.TabStop = false;

this.GroupBox2.Text = "Date Filter";

// crystalReportViewer1

this.crystalReportViewer1.ActiveViewIndex = -1;

this.crystalReportViewer1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;

this.crystalReportViewer1.Cursor = System.Windows.Forms.Cursors.Default;

this.crystalReportViewer1.Dock = System.Windows.Forms.DockStyle.Fill;

this.crystalReportViewer1.Location = new System.Drawing.Point(161, 0);

this.crystalReportViewer1.Name = "crystalReportViewer1";

this.crystalReportViewer1.Size = new System.Drawing.Size(727, 551);

this.crystalReportViewer1.TabIndex = 4;

// frmReport

this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);

this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

this.ClientSize = new System.Drawing.Size(888, 551);

this.Controls.Add(this.crystalReportViewer1);

this.Controls.Add(this.FlowLayoutPanel1);

this.Name = "frmReport";

this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;

this.Text = "Inventory Reports";

this.Load += new System.EventHandler(this.frmReport_Load);

this.GroupBox1.ResumeLayout(false);

this.GroupBox1.PerformLayout();

this.FlowLayoutPanel1.ResumeLayout(false);

this.GroupBox2.ResumeLayout(false);

this.GroupBox2.PerformLayout();

this.ResumeLayout(false);

}

#endregion

internal System.Windows.Forms.DateTimePicker dtp_endDate;

internal System.Windows.Forms.Button btn_preview;

internal System.Windows.Forms.Button btnTotalbooks;

internal System.Windows.Forms.Button btnListBooks;

internal System.Windows.Forms.RadioButton rdoMonthly;

internal System.Windows.Forms.RadioButton rdoWeekly;

internal System.Windows.Forms.RadioButton rdoDaily;

internal System.Windows.Forms.DateTimePicker dtp_strtDate;

internal System.Windows.Forms.Label Label2;

internal System.Windows.Forms.Label Label3;

internal System.Windows.Forms.Label Label1;

internal System.Windows.Forms.ComboBox cboStatus;

internal System.Windows.Forms.GroupBox GroupBox1;

internal System.Windows.Forms.FlowLayoutPanel FlowLayoutPanel1;

internal System.Windows.Forms.GroupBox GroupBox2;

private CrystalDecisions.Windows.Forms.CrystalReportViewer crystalReportViewer1;

}

frmBorrower.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using LibrarySystem.Includes;
using LibrarySystem.Properties;
using System.IO;

namespace LibrarySystem
{
    public partial class frmBorrower : Form
    {
        public frmBorrower()
        {
            InitializeComponent();
        }

        SQLConfig config = new SQLConfig();
        usableFunction funct = new usableFunction();
        string sql;
        int inc, maxrow;

        private void navigate_records(int inc)
        {
            sql = "SELECT BorrowerId FROM tblborrower";
            config.singleResult(sql);

            if (config.dt.Rows.Count > 0)
            {
                txt_bid.Text = config.dt.Rows[inc].Field<string>(0);
            }
        }
        private void btn_New_Click(object sender, EventArgs e)
        {
            funct.clearTxt(this);  
            sql = "SELECT BorrowerId,`Firstname`, `Lastname`, `MiddleName`, `Address`, `Sex`, `ContactNo`, `CourseYear`  as 'Course/Year' FROM `tblborrower`  WHERE Stats='Active'";
            config.Load_ResultList(sql, dtg_ABorrowLists); 
            PictureBox1.ImageLocation = "";
            btn_delete.Enabled = false;

            sql = "SELECT * FROM `tblborrower`  WHERE Stats='Active'";
            config.singleResult(sql);
            if (config.dt.Rows.Count > 0)
            {
                maxrow = config.dt.Rows.Count - 1;
            }

            inc = 0;
        }

        private void frmBorrower_Load(object sender, EventArgs e)
        {
            btn_New_Click(sender, e);
        }

        private void txt_bid_TextChanged(object sender, EventArgs e)
        {
            sql = "SELECT * FROM `tblborrower` WHERE `BorrowerId` = '" + txt_bid.Text + "'";
            config.singleResult(sql);

            if(config.dt.Rows.Count > 0)
            {
                txt_fname.Text = config.dt.Rows[0].Field<string>("Firstname");
                txt_lname.Text = config.dt.Rows[0].Field<string>("Lastname");
                txt_mname.Text = config.dt.Rows[0].Field<string>("MiddleName");
                rch_address.Text = config.dt.Rows[0].Field<string>("Address");
                txtContact.Text = config.dt.Rows[0].Field<string>("ContactNo");
                txtCourse.Text = config.dt.Rows[0].Field<string>("CourseYear");
                PictureBox1.ImageLocation = Application.StartupPath + "\\BorrowerPhoto\\" + config.dt.Rows[0].Field<string>("BorrowerPhoto");

                if (config.dt.Rows[0].Field<string>("Sex") == "Female")
                {
                    rdio_female.Checked = true;
                }
                else
                {
                    rdio_male.Checked = true;
                }
                btn_delete.Enabled = true;
                 
            }
            else
            {
                btn_delete.Enabled = false;
                clearme();
            }
             
        }
        private void clearme()
        {
            txt_fname.Clear();
            txt_lname.Clear();
            txt_mname.Clear();
            rch_address.Clear();
            txtContact.Clear();
            txtCourse.Clear();
            txtPhoto.Clear();
        }

        private void btn_save_Click(object sender, EventArgs e)
        {
             
            if( txt_bid.Text == "" 
            || txt_fname.Text == "" || txt_lname.Text == "" 
            || txt_mname.Text == "" || txtCourse.Text == "" ){
              funct.emptymessage();
            }

            string gender;
            if (rdio_female.Checked)
            {
                gender = "Female";
            }
            else
            {
                gender = "Male";
            }  

            sql = "SELECT * FROM `tblborrower` WHERE `BorrowerId`=" + txt_bid.Text;
            config.singleResult(sql);
            if (config.dt.Rows.Count > 0)
            {
                sql = "update  tblborrower set  `Firstname`='" + txt_fname.Text
                      + "', `Lastname`='" + txt_lname.Text + "', `MiddleName`='" + txt_mname.Text
                      + "', `Address`='" + rch_address.Text + "', `Sex`='" + gender
                      + "', `ContactNo` ='" + txtContact.Text + "', `CourseYear`='" + txtCourse.Text.ToUpper()
                      + "', `BorrowerPhoto`='" + Path.GetFileName(PictureBox1.ImageLocation) + "', `BorrowerType`='Student' where `BorrowerId`='" + txt_bid.Text + "'";
                config.Execute_CUD(sql, "error to execute the query", "Borrower has been updated in the database.");

            }
            else
            {
                sql = "insert into tblborrower (`BorrowerId`, `Firstname`, `Lastname`, `MiddleName`, `Address`, "
                       + "`Sex`, `ContactNo`, `CourseYear`,  `BorrowerPhoto`,`BorrowerType`,Stats)"
                       + "values ('" + txt_bid.Text + "','" + txt_fname.Text + "','" + txt_lname.Text
                       + "','" + txt_mname.Text + "','" + rch_address.Text
                       + "','" + gender + "','" + txtContact.Text + "','" + txtCourse.Text
                       + "','" + Path.GetFileName(PictureBox1.ImageLocation) + "','Student','Active')";
                config.Execute_CUD(sql, "error to execute the query", "New borrower has been added in the database.");

            }
            if(txtPhoto.Text!= "")
            {
                File.Copy(txtPhoto.Text, Application.StartupPath + "\\BorrowerPhoto\\" + Path.GetFileName(PictureBox1.ImageLocation),true);
            }

            btn_New_Click(sender, e);

        }

        private void PictureBox1_Click(object sender, EventArgs e)
        {
            //With OpenFileDialog1

            //    'CHECK THE SELECTED FILE IF IT EXIST OTHERWISE THE DIALOG BOX WILL DISPLAY A WARNING.
            OpenFileDialog1.CheckFileExists = true;


            //    'CHECK THE SELECTED PATH IF IT EXIST OTHERWISE THE DIALOG BOX WILL DISPLAY A WARNING.
            OpenFileDialog1.CheckPathExists = true;


            //    'GET AND SET THE DEFAULT EXTENSION
            OpenFileDialog1.DefaultExt = "jpg";


            //    'RETURN THE FILE LINKED TO THE LNK FILE
            OpenFileDialog1.DereferenceLinks = true;

            //    'SET THE FILE NAME TO EMPTY 
            OpenFileDialog1.FileName = "";

            //    'FILTERING THE FILES
            OpenFileDialog1.Filter = "(*.jpg)|*.jpg|(*.png)|*.png|(*.jpg)|*.jpg|All files|*.*";

            //    'SET THIS FOR ONE FILE SELECTION ONLY.
            OpenFileDialog1.Multiselect = false;



            //    'SET THIS TO PUT THE CURRENT FOLDER BACK TO WHERE IT HAS STARTED.
            OpenFileDialog1.RestoreDirectory = true;

            //    'SET THE TITLE OF THE DIALOG BOX.
            OpenFileDialog1.Title = "Select a file to open";

            //    'ACCEPT ONLY THE VALID WIN32 FILE NAMES.
            OpenFileDialog1.ValidateNames = true;

            if (OpenFileDialog1.ShowDialog() == DialogResult.OK)
            {
                txtPhoto.Text = OpenFileDialog1.FileName; 
                PictureBox1.ImageLocation = OpenFileDialog1.FileName;
                PictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
            }
  
        }

        private void btn_delete_Click(object sender, EventArgs e)
        { 
            if (MessageBox.Show("Are you sure you want to delete this borrower?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { 
                sql = "UPDATE `tblborrower` SET  `Stats` =  'NotActive' WHERE `BorrowerId` ='" + dtg_ABorrowLists.CurrentRow.Cells[0].Value + "'";
                config.Execute_Query(sql);

                MessageBox.Show("Borrower has been deleted in the database.", "Success", MessageBoxButtons.OK);
                btn_New_Click(sender, e);
            } 
        }

        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void btn_last_Click(object sender, EventArgs e)
        {
            inc = maxrow;
            navigate_records(inc);
        }

        private void btn_prev_Click(object sender, EventArgs e)
        {
            if(inc == 0)
            {
                MessageBox.Show("First Records.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else if(inc <= maxrow)
            {
                inc = inc - 1;
                navigate_records(inc);
            }
        }

        private void btn_next_Click(object sender, EventArgs e)
        {
            if (inc == maxrow)
            { 
                MessageBox.Show("Last Records.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else  if (inc >= 0)
            {
                inc = inc + 1;
                navigate_records(inc);
            }
        }

        private void dtg_ABorrowLists_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            txt_bid.Text = dtg_ABorrowLists.CurrentRow.Cells[0].Value.ToString();
        }

        private void btn_first_Click(object sender, EventArgs e)
        {
            inc = 0;
            navigate_records(inc);
        }
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using LibrarySystem.Includes;

using LibrarySystem.Properties;

using System.IO;

namespace LibrarySystem

{

public partial class frmBorrower : Form

{

public frmBorrower()

{

InitializeComponent();

}

SQLConfig config = new SQLConfig();

usableFunction funct = new usableFunction();

string sql;

int inc, maxrow;

private void navigate_records(int inc)

{

sql = "SELECT BorrowerId FROM tblborrower";

config.singleResult(sql);

if (config.dt.Rows.Count > 0)

{

txt_bid.Text = config.dt.Rows[inc].Field<string>(0);

}

private void btn_New_Click(object sender, EventArgs e)

{

funct.clearTxt(this);

sql = "SELECT BorrowerId,`Firstname`, `Lastname`, `MiddleName`, `Address`, `Sex`, `ContactNo`, `CourseYear` as 'Course/Year' FROM `tblborrower` WHERE Stats='Active'";

config.Load_ResultList(sql, dtg_ABorrowLists);

PictureBox1.ImageLocation = "";

btn_delete.Enabled = false;

sql = "SELECT * FROM `tblborrower` WHERE Stats='Active'";

config.singleResult(sql);

if (config.dt.Rows.Count > 0)

{

maxrow = config.dt.Rows.Count - 1;

}

inc = 0;

}

private void frmBorrower_Load(object sender, EventArgs e)

{

btn_New_Click(sender, e);

}

private void txt_bid_TextChanged(object sender, EventArgs e)

{

sql = "SELECT * FROM `tblborrower` WHERE `BorrowerId` = '" + txt_bid.Text + "'";

config.singleResult(sql);

if(config.dt.Rows.Count > 0)

{

txt_fname.Text = config.dt.Rows[0].Field<string>("Firstname");

txt_lname.Text = config.dt.Rows[0].Field<string>("Lastname");

txt_mname.Text = config.dt.Rows[0].Field<string>("MiddleName");

rch_address.Text = config.dt.Rows[0].Field<string>("Address");

txtContact.Text = config.dt.Rows[0].Field<string>("ContactNo");

txtCourse.Text = config.dt.Rows[0].Field<string>("CourseYear");

PictureBox1.ImageLocation = Application.StartupPath + "\\BorrowerPhoto\\" + config.dt.Rows[0].Field<string>("BorrowerPhoto");

if (config.dt.Rows[0].Field<string>("Sex") == "Female")

{

rdio_female.Checked = true;

}

else

{

rdio_male.Checked = true;

}

btn_delete.Enabled = true;

}

else

{

btn_delete.Enabled = false;

clearme();

}

private void clearme()

{

txt_fname.Clear();

txt_lname.Clear();

txt_mname.Clear();

rch_address.Clear();

txtContact.Clear();

txtCourse.Clear();

txtPhoto.Clear();

}

private void btn_save_Click(object sender, EventArgs e)

{

if( txt_bid.Text == ""

|| txt_fname.Text == "" || txt_lname.Text == ""

|| txt_mname.Text == "" || txtCourse.Text == "" ){

funct.emptymessage();

}

string gender;

if (rdio_female.Checked)

{

gender = "Female";

}

else

{

gender = "Male";

}

sql = "SELECT * FROM `tblborrower` WHERE `BorrowerId`=" + txt_bid.Text;

config.singleResult(sql);

if (config.dt.Rows.Count > 0)

{

sql = "update tblborrower set `Firstname`='" + txt_fname.Text

+ "', `Lastname`='" + txt_lname.Text + "', `MiddleName`='" + txt_mname.Text

+ "', `Address`='" + rch_address.Text + "', `Sex`='" + gender

+ "', `ContactNo` ='" + txtContact.Text + "', `CourseYear`='" + txtCourse.Text.ToUpper()

+ "', `BorrowerPhoto`='" + Path.GetFileName(PictureBox1.ImageLocation) + "', `BorrowerType`='Student' where `BorrowerId`='" + txt_bid.Text + "'";

config.Execute_CUD(sql, "error to execute the query", "Borrower has been updated in the database.");

}

else

{

sql = "insert into tblborrower (`BorrowerId`, `Firstname`, `Lastname`, `MiddleName`, `Address`, "

+ "`Sex`, `ContactNo`, `CourseYear`, `BorrowerPhoto`,`BorrowerType`,Stats)"

+ "values ('" + txt_bid.Text + "','" + txt_fname.Text + "','" + txt_lname.Text

+ "','" + txt_mname.Text + "','" + rch_address.Text

+ "','" + gender + "','" + txtContact.Text + "','" + txtCourse.Text

+ "','" + Path.GetFileName(PictureBox1.ImageLocation) + "','Student','Active')";

config.Execute_CUD(sql, "error to execute the query", "New borrower has been added in the database.");

}

if(txtPhoto.Text!= "")

{

File.Copy(txtPhoto.Text, Application.StartupPath + "\\BorrowerPhoto\\" + Path.GetFileName(PictureBox1.ImageLocation),true);

}

btn_New_Click(sender, e);

}

private void PictureBox1_Click(object sender, EventArgs e)

{

//With OpenFileDialog1

// 'CHECK THE SELECTED FILE IF IT EXIST OTHERWISE THE DIALOG BOX WILL DISPLAY A WARNING.

OpenFileDialog1.CheckFileExists = true;

// 'CHECK THE SELECTED PATH IF IT EXIST OTHERWISE THE DIALOG BOX WILL DISPLAY A WARNING.

OpenFileDialog1.CheckPathExists = true;

// 'GET AND SET THE DEFAULT EXTENSION

OpenFileDialog1.DefaultExt = "jpg";

// 'RETURN THE FILE LINKED TO THE LNK FILE

OpenFileDialog1.DereferenceLinks = true;

// 'SET THE FILE NAME TO EMPTY

OpenFileDialog1.FileName = "";

// 'FILTERING THE FILES

OpenFileDialog1.Filter = "(*.jpg)|*.jpg|(*.png)|*.png|(*.jpg)|*.jpg|All files|*.*";

// 'SET THIS FOR ONE FILE SELECTION ONLY.

OpenFileDialog1.Multiselect = false;

// 'SET THIS TO PUT THE CURRENT FOLDER BACK TO WHERE IT HAS STARTED.

OpenFileDialog1.RestoreDirectory = true;

// 'SET THE TITLE OF THE DIALOG BOX.

OpenFileDialog1.Title = "Select a file to open";

// 'ACCEPT ONLY THE VALID WIN32 FILE NAMES.

OpenFileDialog1.ValidateNames = true;

if (OpenFileDialog1.ShowDialog() == DialogResult.OK)

{

txtPhoto.Text = OpenFileDialog1.FileName;

PictureBox1.ImageLocation = OpenFileDialog1.FileName;

PictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;

}

private void btn_delete_Click(object sender, EventArgs e)

{

if (MessageBox.Show("Are you sure you want to delete this borrower?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) {

sql = "UPDATE `tblborrower` SET `Stats` = 'NotActive' WHERE `BorrowerId` ='" + dtg_ABorrowLists.CurrentRow.Cells[0].Value + "'";

config.Execute_Query(sql);

MessageBox.Show("Borrower has been deleted in the database.", "Success", MessageBoxButtons.OK);

btn_New_Click(sender, e);

}

private void btnClose_Click(object sender, EventArgs e)

{

this.Close();

}

private void btn_last_Click(object sender, EventArgs e)

{

inc = maxrow;

navigate_records(inc);

}

private void btn_prev_Click(object sender, EventArgs e)

{

if(inc == 0)

{

MessageBox.Show("First Records.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);

}

else if(inc <= maxrow)

{

inc = inc - 1;

navigate_records(inc);

}

private void btn_next_Click(object sender, EventArgs e)

{

if (inc == maxrow)

{

MessageBox.Show("Last Records.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);

}

else if (inc >= 0)

{

inc = inc + 1;

navigate_records(inc);

}

private void dtg_ABorrowLists_CellClick(object sender, DataGridViewCellEventArgs e)

{

txt_bid.Text = dtg_ABorrowLists.CurrentRow.Cells[0].Value.ToString();

}

private void btn_first_Click(object sender, EventArgs e)

{

inc = 0;

navigate_records(inc);

}

Free- Download Source code OF LIBRARY MANAGEMENT SYSTEM Project (FYP) Full file in C# Library Management System Software Documentation FUNCTIONAL REQUIREMENTS OF LIBRARY MANAGEMENT SYSTEM Non FUNCTIONAL REQUIREMENTS OF LIBRARY MANAGEMENT SYSTEM Use Case …

LIBRARY MANAGEMENT SYSTEM C# Download Source code OF Project (FYP) Read More »

Point of Sale for CAFE in C# – Free Source Code Download

Leave a Comment / C# Projects / By Projects Inventory

Point of Sale for CAFE in C# – Free Source Code Download POS Project for a Cafe. It is a software-based application that helps to manage the sale transaction of Cafe businesses. The system will calculate the total amount to pay the customer and print a simple receipt after payment succeeds. About the Cafe Point …

Point of Sale for CAFE in C# – Free Source Code Download Read More »

Online Courier Services Project using Python PHP or C Sharp

Leave a Comment / C# Projects, PHP Projects, SRS Document / By Projects Inventory

Code and documentation of Online Courier Services Project using Python PHP or C# Project Domain / Category Web Application Abstract/Introduction In the modern age, people’s needs & requirements increases as per demands of livings. People want more facilities and try to do their tasks quickly and within time limits. But such a …

Online Courier Services Project using Python PHP or C Sharp Read More »