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