public void insert_complaindetails(ComplainDetails cd)
{
SqlConnection C = new SqlConnection(ConnectionString);
var complain_insert = new SqlCommand("INSERT INTO [dbo].[ComplainDetails] ([Complain_Id], [Clientid], [ProblemDetails], [ProblemStatus], [Date] ) VALUES (@Complain_Id, @Clientid, @ProblemDetails, @ProblemStatus, @Date)", C);
SqlParameter p1 = new SqlParameter("@Complain_Id ", SqlDbType.VarChar, 50);
p1.Value = cd.Complain_Id;
SqlParameter p2 = new SqlParameter("@Clientid ", SqlDbType.VarChar, 50);
p2.Value = cd.ClientId;
SqlParameter p3 = new SqlParameter("@ProblemDetails ", SqlDbType.VarChar);
p3.Value = cd.ProblemDetails;
SqlParameter p4 = new SqlParameter("@ProblemStatus ", SqlDbType.VarChar, 50);
p4.Value = cd.ProblemStatus;
SqlParameter p5 = new SqlParameter("@Date ", SqlDbType.DateTime);
p5.Value = cd.Date;
complain_insert.Parameters.Add(p1);
complain_insert.Parameters.Add(p2);
complain_insert.Parameters.Add(p3);
complain_insert.Parameters.Add(p4);
complain_insert.Parameters.Add(p5);
C.Open();
complain_insert.ExecuteNonQuery();
C.Close();
}
public complaintsmr(ComplainDetails _cds)
{
InitializeComponent();
_compidtextbox.Text = _cds.Complain_Id.ToString();
cdtextbox.Text = _cds.ClientId.ToString();
_probdate.Value = _cds.Date;
_problemdetailstextbox.Text = _cds.ProblemDetails.ToString();
probstatus.Text = _cds.ProblemStatus.ToString();
delete.Enabled = true;
modify.Enabled = false;
_probdate.Enabled = false;
probstatus.Enabled = false;
}
public bool UpdateComplainDetails(ComplainDetails comd_obj)
{
SqlConnection C = new SqlConnection(ConnectionString);
SqlCommand command = new SqlCommand("UPDATE [dbo].[ComplainDetails] SET [ClientId]=@ClientId, [ProblemDetails]=@ProblemDetails,[ProblemStatus]=@ProblemStatus,[Date]=@Date WHERE [Complain_Id] = @Complain_Id", C);
SqlParameter p1 = new SqlParameter("@ClientId", System.Data.SqlDbType.VarChar, 20);
p1.Value = comd_obj.ClientId;
command.Parameters.Add(p1);
SqlParameter p2 = new SqlParameter("@ProblemDetails", System.Data.SqlDbType.VarChar, 25);
p2.Value = comd_obj.ProblemDetails;
command.Parameters.Add(p2);
SqlParameter p3 = new SqlParameter("@ProblemStatus", System.Data.SqlDbType.VarChar, 50);
p3.Value = comd_obj.ProblemStatus;
command.Parameters.Add(p3);
SqlParameter p4 = new SqlParameter("@Date", System.Data.SqlDbType.DateTime);
p4.Value = comd_obj.Date;
command.Parameters.Add(p4);
SqlParameter p5 = new SqlParameter("@Complain_Id", System.Data.SqlDbType.VarChar);
p5.Value = comd_obj.Complain_Id;
command.Parameters.Add(p5);
C.Open();
int result = command.ExecuteNonQuery();
C.Close();
return(result > 0);
}