1) You have to make a compliant register.
Compliants(CompliantID,Comp.Date,IpAdress,ProblemDesc,Resp)
Compliant ID to be generated automatically as… If Resp. is Management Start with M001 like that..
If Network Person is responsible start with N001 if Others are responsible start with O001 like that.
Task 2 :
______
Create a table as Resolved. And take ur own fields. Once the compliant get resolved, the the record to be moved from Complaints to Resolve.
Task 3:
Make a form as dashboard, and display all complaints in the data grid.
If any compliant not resolved in 7days time, that record to be displayed in Red color.
Coding Standards
1) All Script Files
2) To be used stored procedures.
3) Front-end code must be in business object, not in the events.
4) Naming Standards to be implemented strictly.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Text;
namespace compliants
{
#region class compliants
class compliants
{
#region variables
SqlConnection connection;
SqlCommand command;
SqlDataReader dr;
#endregion variables
#region properties
public int ID
{ get;
set;
}
public string compliantID
{
get;
set;
}
public DateTime compliantDate
{
get;
set;
}
public string IpAddress
{
get;
set;
}
public string ProblemDescription
{
get;
set;
}
public string Responsibility
{
get;
set;
}
#endregion properties
#region methods
public void Savecompliants(compliants objcompliants)
{
compliantID = objcompliants.compliantID;
compliantDate = objcompliants.compliantDate;
IpAddress = objcompliants.IpAddress;
ProblemDescription = objcompliants.ProblemDescription;
Responsibility = objcompliants.Responsibility;
}
public string Insertcompliants()
{
connection = connectionHelper.GetConnection();
command = new SqlCommand("proccomplaint", connection);
connection.Open();
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@compliantID",compliantID);
command.Parameters.AddWithValue("@CompliantDate",compliantDate);
command.Parameters.AddWithValue("@IpAddress",IpAddress);
command.Parameters.AddWithValue("@ProblemDescription",ProblemDescription);
command.Parameters.AddWithValue("@Responsibility",Responsibility);
command.ExecuteNonQuery();
string compliantid =Convert.ToString(command.Parameters["@CompliantID"].Value);
return compliantid;
}
#endregion methods
}
#endregion class compliants
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace compliants
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void btnRegister_Click(object sender, EventArgs e)
{
compliants objcompliants = new compliants();
objcompliants.compliantID = txtCompliantID.Text;
objcompliants.compliantDate = dtpCompliantDate.Value;
objcompliants.IpAddress = txtIpAddress.Text;
objcompliants.ProblemDescription = txtDescription.Text;
objcompliants.Responsibility = cmbResponsibility.Text;
compliants obj = new compliants();
obj.Savecompliants(objcompliants);
string compliantid = obj.Insertcompliants();
txtCompliantID.Text = compliantid;
MessageBox.Show("success");
}
}
}