public string Post([FromBody] SignUpCreds creds)
{
SignUpResult result = new SignUpResult();
result.ok = false;
result.message = "An unexpected error occured. Sign up couln't be completed.";
SqlConnection myDbCon = new SqlConnection(DBConst.conStr);
myDbCon.Open();
try
{
string CommandText = "INSERT INTO USERInfo(USERNAME, NAME, SURNAME, WORKGROUP, EMAIL, Insert_Date, PASSWORD) VALUES (@username, @name, @surname, @workgroup, @email, GETDATE(), @Password)";
SqlCommand command = new SqlCommand(CommandText, myDbCon);
command.Parameters.Add("@username", SqlDbType.VarChar).Value = creds.username;
command.Parameters.Add("@name", SqlDbType.VarChar).Value = creds.name;
command.Parameters.Add("@surname", SqlDbType.VarChar).Value = creds.surname;
command.Parameters.Add("@workgroup", SqlDbType.Int).Value = creds.workgroup;
command.Parameters.Add("@email", SqlDbType.VarChar).Value = creds.email;
command.Parameters.Add("@Password", SqlDbType.VarChar).Value = creds.password;
command.ExecuteNonQuery();
}
catch (Exception ex)
{
result.ok = false;
result.message = ex.Message;
return(JsonConvert.SerializeObject(result));
}
result.ok = true;
result.message = "Signup completed successfully!";
myDbCon.Close();
return(JsonConvert.SerializeObject(result));
}
public string Get()
{
List <QualityIssueResult> resultList = new List <QualityIssueResult>();
SqlConnection myDbCon = new SqlConnection(DBConst.conStr);
myDbCon.Open();
try
{
string CommandText = "SELECT * FROM QualityIssue";
SqlCommand command = new SqlCommand(CommandText, myDbCon);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
QualityIssueResult result = new QualityIssueResult();
result.Id = Convert.ToInt32(reader["Id"]);
result.Customer_Id = Convert.ToInt32(reader["Customer_Id"]);
result.Project_Id = Convert.ToInt32(reader["Project_Id"]);
result.Partnumber_Id = Convert.ToInt32(reader["Partnumber_Id"]);
result.Problem_Date = Convert.ToDateTime(reader["Problem_Date"]);
result.Description = (string)(reader["Description"]);
result.Location_Id = Convert.ToInt32(reader["Location_Id"]);
result.Grade_Id = (string)(reader["Grade_Id"]);
result.Resp_Dept_Id = Convert.ToInt32(reader["Resp_Dept_Id"]);
result.Request_Date = Convert.ToDateTime(reader["Request_Date"]);
result.Target_Date = Convert.ToDateTime(reader["Target_Date"]);
result.Qty_In_1_Month = Convert.ToInt32(reader["Qty_In_1_Month"]);
result.Qty_In_3_Month = Convert.ToInt32(reader["Qty_In_3_Month"]);
result.Receive_Date1 = Convert.ToDateTime(reader["Receive_Date1"]);
result.Receive_Date2 = Convert.ToDateTime(reader["Receive_Date2"]);
result.Receive_Date3 = Convert.ToDateTime(reader["Receive_Date3"]);
result.Send_Date = Convert.ToDateTime(reader["Send_Date"]);
result.Awaiting_Date = Convert.ToDateTime(reader["Awaiting_Date"]);
result.Doc_Update = Convert.ToInt32(reader["Doc_Update"]);
result.Doc_Update_Description = (string)(reader["Doc_Update_Desc"]);
result.Insert_User_Id = Convert.ToInt32(reader["Insert_User_Id"]);
result.Insert_Date = Convert.ToDateTime(reader["Insert_Date"]);
result.Update_User_Id = Convert.ToInt32(reader["Update_User_Id"]);
result.Update_Date = Convert.ToDateTime(reader["Update_Date"]);
result.ok = true;
result.message = "Data is successfully retrieved.";
resultList.Add(result);
}
}
catch (Exception ex)
{
SignUpResult result = new SignUpResult();
result.ok = false;
result.message = ex.Message;
myDbCon.Close();
return(JsonConvert.SerializeObject(result));
}
myDbCon.Close();
return(JsonConvert.SerializeObject(resultList));
}
public string Post([FromBody] QualityIssue issueInfo)
{
SignUpResult result = new SignUpResult();
result.ok = false;
result.message = "Login failed";
SqlConnection myDbCon = new SqlConnection(DBConst.conStr);
myDbCon.Open();
try
{
string CommandText = "INSERT INTO QualityIssue(" +
"Customer_Id, Project_Id, Partnumber_Id, Problem_Date, Description, Location_Id, Grade_Id," +
"Resp_Dept_Id, Request_Date, Target_Date, Qty_In_1_Month, Qty_In_3_Month, " +
"Insert_Date, Insert_User_Id)" +
"VALUES (@Customer_Id, @Project_Id, @Partnumber_Id, @Problem_Date, @Description, @Location_Id, @Grade_Id," +
"@Resp_Dept_Id, @Request_Date, @Target_Date, @Qty_In_1_Month, @Qty_In_3_Month," +
"GETDATE(), @Insert_User_Id )";
SqlCommand command = new SqlCommand(CommandText, myDbCon);
command.Parameters.Add("@Customer_Id", SqlDbType.Int).Value = issueInfo.Customer_Id;
command.Parameters.Add("@Project_Id", SqlDbType.Int).Value = issueInfo.Project_Id;
command.Parameters.Add("@Partnumber_Id", SqlDbType.Int).Value = issueInfo.Partnumber_Id;
command.Parameters.Add("@Problem_Date", SqlDbType.DateTime).Value = issueInfo.Problem_Date;
command.Parameters.Add("@Description", SqlDbType.VarChar).Value = issueInfo.Description;
command.Parameters.Add("@Location_Id", SqlDbType.Int).Value = issueInfo.Location_Id;
command.Parameters.Add("@Grade_Id", SqlDbType.VarChar).Value = issueInfo.Grade_Id;
command.Parameters.Add("@Resp_Dept_Id", SqlDbType.Int).Value = issueInfo.Resp_Dept_Id;
command.Parameters.Add("@Request_Date", SqlDbType.DateTime).Value = issueInfo.Request_Date;
command.Parameters.Add("@Target_Date", SqlDbType.DateTime).Value = issueInfo.Target_Date;
command.Parameters.Add("@Qty_In_1_Month", SqlDbType.Int).Value = issueInfo.Qty_In_1_Month;
command.Parameters.Add("@Qty_In_3_Month", SqlDbType.Int).Value = issueInfo.Qty_In_3_Month;
command.Parameters.Add("@Insert_User_Id", SqlDbType.Int).Value = issueInfo.Insert_User_Id;
command.ExecuteNonQuery();
}
catch (Exception ex)
{
result.ok = false;
result.message = ex.Message;
return(JsonConvert.SerializeObject(result));
}
result.ok = true;
result.message = "Signup completed successfully!";
myDbCon.Close();
return(JsonConvert.SerializeObject(result));
}
public string Put(int id, [FromBody] QualityIssue issueInfo)
{
SignUpResult result = new SignUpResult();
result.ok = false;
result.message = "Login failed";
SqlConnection myDbCon = new SqlConnection(DBConst.conStr);
myDbCon.Open();
try
{
string CommandText = "UPDATE QualityIssue SET " +
"Customer_Id=@Customer_Id, " +
"Project_Id=@Project_Id, " +
"Partnumber_Id=@Partnumber_Id, " +
"Problem_Date=@Problem_Date, " +
"Description=@Description, " +
"Location_Id=@Location_Id, " +
"Grade_Id=@Grade_Id, " +
"Resp_Dept_Id=@Resp_Dept_Id, " +
"Request_Date=@Request_Date, " +
"Target_Date=@Target_Date, " +
"Qty_In_1_Month=@Qty_In_1_Month, " +
"Qty_In_3_Month=@Qty_In_3_Month, " +
"Receive_Date1=@Receive_Date1, " +
"Receive_Date2=@Receive_Date2, " +
"Receive_Date3=@Receive_Date3, " +
"Send_Date=@Send_Date, " +
"Awaiting_Date=@Awaiting_Date, " +
"Doc_Update=@Doc_Update, " +
"Doc_Update_Desc=@Doc_Update_Desc, " +
"Update_Date=GETDATE(), " +
"Update_User_Id=@Update_User_Id" +
" WHERE Id = @Id";
SqlCommand command = new SqlCommand(CommandText, myDbCon);
command.Parameters.Add("@Id", SqlDbType.Int).Value = id;
command.Parameters.Add("@Customer_Id", SqlDbType.Int).Value = issueInfo.Customer_Id;
command.Parameters.Add("@Project_Id", SqlDbType.Int).Value = issueInfo.Project_Id;
command.Parameters.Add("@Partnumber_Id", SqlDbType.Int).Value = issueInfo.Partnumber_Id;
command.Parameters.Add("@Problem_Date", SqlDbType.DateTime).Value = issueInfo.Problem_Date;
command.Parameters.Add("@Description", SqlDbType.VarChar).Value = issueInfo.Description;
command.Parameters.Add("@Location_Id", SqlDbType.Int).Value = issueInfo.Location_Id;
command.Parameters.Add("@Grade_Id", SqlDbType.VarChar).Value = issueInfo.Grade_Id;
command.Parameters.Add("@Resp_Dept_Id", SqlDbType.Int).Value = issueInfo.Resp_Dept_Id;
command.Parameters.Add("@Request_Date", SqlDbType.DateTime).Value = issueInfo.Request_Date;
command.Parameters.Add("@Target_Date", SqlDbType.DateTime).Value = issueInfo.Target_Date;
command.Parameters.Add("@Qty_In_1_Month", SqlDbType.Int).Value = issueInfo.Qty_In_1_Month;
command.Parameters.Add("@Qty_In_3_Month", SqlDbType.Int).Value = issueInfo.Qty_In_3_Month;
command.Parameters.Add("@Receive_Date1", SqlDbType.DateTime).Value = issueInfo.Receive_Date1;
command.Parameters.Add("@Receive_Date2", SqlDbType.DateTime).Value = issueInfo.Receive_Date2;
command.Parameters.Add("@Receive_Date3", SqlDbType.DateTime).Value = issueInfo.Receive_Date3;
command.Parameters.Add("@Send_Date", SqlDbType.DateTime).Value = issueInfo.Send_Date;
command.Parameters.Add("@Awaiting_Date", SqlDbType.DateTime).Value = issueInfo.Awaiting_Date;
command.Parameters.Add("@Doc_Update", SqlDbType.Int).Value = issueInfo.Doc_Update;
command.Parameters.Add("@Doc_Update_Desc", SqlDbType.VarChar).Value = issueInfo.Doc_Update_Description;
command.Parameters.Add("@Update_User_Id", SqlDbType.Int).Value = issueInfo.Update_User_Id;
command.ExecuteNonQuery();
}
catch (Exception ex)
{
result.ok = false;
result.message = ex.Message;
return(JsonConvert.SerializeObject(result));
}
result.ok = true;
result.message = "Signup completed successfully!";
myDbCon.Close();
return(JsonConvert.SerializeObject(result));
}
