Inventory Maintenance of Wedding card Organization: 

  • The System is undertaken for the development of electronic maintenance of inventory of the organization who works as wholesale merchandise of wedding and varied types of cards.
  • The information related to enterprise such as transportation details, sales details, purchase details, dealers details, are maintained manually on paperwork. It becomes overhead for the entrepreneur of organization to maintain this entire task manually and to generate report & analysis of any activity on demand.
  • So the demand for electronically maintaining this all task under single head had gave rise to the development of this system.

The process of organizational workflow goes in following way:-

  • Transportation Company provides the goods to the proprietor of the organization, sent by the manufacturers.
  • The organization keeps details of transportation.
  • The parcels are kept in the go down where the details of inward goods are maintained.
  • The details of inward goods are maintained by organization from the bill (invoice) from dealers/manufacturers.
  • The single invoice contains details for more than one item.
  • The organization after recording the details of inward invoice assigns a unique identification to each card/ product and also the sale price.
  • The organization sale this goods on retail and wholesale basis to their customers.
  • Customers of this organization are printing press firms and common people as it is wedding card organization.
  • Additionally the organization also maintains the current stock of organization by deducting sold stock from purchase stock.
  • Organization also maintains personal details of dealers and customers for their reference purpose.

Scope

As the system maintains the inventory of a commercial organization of sole proprietorship, its bound is up to the entrepreneur of the firm. The owner of the business maintains all the task of maintaining details about transportation, purchase, sales, stock and personal information of dealers and customer as well.

We can extend this system by portioning stock into two parts. I.e. stock on shop and stock in go down. And e-mail will automatically send to customer s about their purchases and dealers about the confirmation of receiving goods successfully.

Requirements:

  • The system should be able to maintain the personal information of dealer which includes :

Dealer name, firm name, address, city, state, contact no, e-mail ID (if any), category, and tin no

  • The system should be able to store the details of purchase which includes:

Dealer‘s firm name, product name, product type, quantity, price, payment mode, payment details.

  • The system should also be able to store the details of sales done by organization. The details include:

Customer name, date, product name, qty, price.

  • The system should also be able to maintain the stock of the organization by manipulating purchase and sales details.
  • Owner should be able to assign unique no to the product and sales price.
  • Owner must also be facilitate to store the transportation details which includes:

Receipt no, Dealer firm, transportation name, date, no of parcels, transportation cost.

  • The entrepreneur must also be facilitate to make the post payment to the dealers and should be able to maintain details of it like dealer name, amt paid, date of payment, mode of payment, payment details. 
  • Owner must be able to store personal details of customers. Which include:

Name, address, city, state, contact no, email ID (if any), tin no (if he is wholesale customer).

  • And last but never the least, the owner must be able to edit and delete the existing details. This includes:

Transportation  details.

Personal details of dealers as well as customers.

Purchase information (If any, due to wrong entry of data.)

Sales information (If any, due to wrong entry of data.)

Details of product (unique on and sale price).

Output Screens Below:

  • Login Section
  • Inventory Maintenance Login System
  • Validation Page
  • Add Transportation Details
  • View-Edit  Transportation Details:
  • Add Dealers details
  • View-edit Dealer
  • Add Purchase Details
  • Add more purchase details
  • View Purchase Details
  • Assign list of numbers to be assigned
  • Assign Numbers and sale price
  • View Assigned Numbers
  • Add New Customer
  • View Customer details
  • Generate Sales Invoice
  • View Sales Details
  • View Total Stock
  • View Sold Stock
  • Current Stock
  • Do Payment to Dealer

Transportation Details Source Code below:


Transportation Details.aspx.cs
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class TransportDetails : System.Web.UI.Page
{
//string dlrid;
public string name;
public string id;
public void clear()
{
txtrrno.Text = "";
txttransname.Text = "";
txttransdate.Text = "";
txtnop.Text = "";
txttranscost.Text = "";

}
protected void Page_Load(object sender, EventArgs e)
{
name = Session["name"].ToString();
id = Session["id"].ToString();
TextBox1.Text = "Welcome," + name;

}
protected void btnstore_Click(object sender, EventArgs e)
{

Dealers dls = new Dealers();
DataSet ds = dls.getDealerNames(ddldlrfirm.SelectedItem.Text);
string dlrid = ds.Tables[0].Rows[0][0].ToString();
Transport trans = new Transport();

string userid = id;

try
{
trans.insertTransportDetails(Convert.ToInt32(txtrrno.Text), dlrid, userid, txttransname.Text, txttransdate.Text, Convert.ToInt32(txtnop.Text), Convert.ToInt32(txttranscost.Text));
Response.Redirect("ViewTransportationDetails.aspx");
}

catch (Exception ex)
{
// Response .Write (ex.Message );
TextBox1.Text = "Error in Recording.!!";
}
}

protected void ddldlrfirm_SelectedIndexChanged(object sender, EventArgs e)
{
ddldlrfirm.Focus();
}
}

Contact us for more details about this project.