Comments by ravivangala (Top 7 by date)

i think i will return as
M001
N002
but the code sholud be like
M001
N001

ado.net,connected architecture
jst check out the code bellow

/*presentation layer */

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");



}

/* public void cmbResponsibility_SelectedIndexChanged(object sender, EventArgs e)
{

compliants objcompliants = new compliants();

compliants obj = new compliants();




if (cmbResponsibility.Text == "Select UserType")
{
MessageBox.Show("Please select user !");
}
else if (cmbResponsibility.SelectedIndex == 0)
{
txtCompliantID.Text= "M";
}
else if (cmbResponsibility.SelectedIndex == 1)
{
txtCompliantID.Text ="N";
}
else
{
txtCompliantID.Text ="O";
}

obj.GenerateID(txtCompliantID.Text);
}*/

}
}

/*this is class file */

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 GenerateID(String compliantID)
{

connection = connectionHelper.GetConnection();
SqlCommand cmd = new SqlCommand("select top 1 CompliantID from Compliants where CompliantID like '" + compliantID + "%' order by ID DESC",connection);
connection.Open();
string c = compliantID;

object b = command.ExecuteScalar();
string num = "";
if (b == null)
{
num = c + "001";
}
else
{

num = b.ToString();
int n=Convert.ToInt32(num.Substring(1,num.Length-1));
n++;
if (n >= 1 && n <= 9)
num = c+"00"+n;
if (n >= 10 && n <= 99)
num = c+"0"+n;
if (n >= 100 && n <= 999)
num = c+n;
}
connection.Close();
return compliantID;
}*/
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

}